Use the File Open Browse box

[Dave N]

I want to programatically open the Access "File" "Open" browse box to search
for a file. When it is selected I wnat to have it put the path in a text
box so it can be added to a list box.

[Allen Browne]

Re: Use the File Open Browse box

Best approach is to use the API call. Details:

http://www.mvps.org/access/api/api0001.htm

It can look a little intimidating if you are not used to API calls, but it's
basically copy the code and call the function.

You mentioned the path: if you just wanted to browse for a folder, use this
one instead:

http://www.mvps.org/access/api/api0002.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave N" <nelsondavea@jo hndeere.com> wrote in message
news:3fd880a7$1 @news1.dpn.deer e.com...[color=blue]
> I want to programatically open the Access "File" "Open" browse box to[/color]
search[color=blue]
> for a file. When it is selected I wnat to have it put the path in a text
> box so it can be added to a list box.
>
>[/color]

[David Nelson]

Re: Use the File Open Browse box

Allen,

Thanks for the tips. I tried the browse folders and it works good. But
I need to get to the actual file name so will try the other (API) one.
I have never worked with them so I guess it is time to get my feet wet.
I will let you know how I make out.

Thanks again,
Dave.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Rob]

Re: Use the File Open Browse box

Allen,

I'm just beginning with programming in Access 2000 and i can't get the
API call http://www.mvps.org/access/api/api0001.htm to work. I don't
have problems with the browse function (.../api0002.htm).

Can you help me by explaning what to do step by step or send an
example *.mdb file.

Thanx,

Rob



"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message news:<3fd8895c$ 0$1741$5a62ac22 @freenews.iinet .net.au>...[color=blue]
> Best approach is to use the API call. Details:
> http://www.mvps.org/access/api/api0001.htm
>
> It can look a little intimidating if you are not used to API calls, but it's
> basically copy the code and call the function.
>
> You mentioned the path: if you just wanted to browse for a folder, use this
> one instead:
> http://www.mvps.org/access/api/api0002.htm
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Dave N" <nelsondavea@jo hndeere.com> wrote in message
> news:3fd880a7$1 @news1.dpn.deer e.com...[color=green]
> > I want to programatically open the Access "File" "Open" browse box to[/color]
> search[color=green]
> > for a file. When it is selected I wnat to have it put the path in a text
> > box so it can be added to a list box.
> >
> >[/color][/color]

[Allen Browne]

Re: Use the File Open Browse box

Be sure to include the declarations in a standard module (i.e. on that shows
on the Modules tab of the Database window, not the module of some form).

Not sure what else to suggest.


--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rob" <helleman@naco. nl> wrote in message
news:11c1cdff.0 401050436.62c89 c87@posting.goo gle.com...[color=blue]
> Allen,
>
> I'm just beginning with programming in Access 2000 and i can't get the
> API call http://www.mvps.org/access/api/api0001.htm to work. I don't
> have problems with the browse function (.../api0002.htm).
>
> Can you help me by explaning what to do step by step or send an
> example *.mdb file.
>
> Thanx,
>
> Rob
>
>
>
> "Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in message[/color]
news:<3fd8895c$ 0$1741$5a62ac22 @freenews.iinet .net.au>...[color=blue][color=green]
> > Best approach is to use the API call. Details:
> > http://www.mvps.org/access/api/api0001.htm
> >
> > It can look a little intimidating if you are not used to API calls, but[/color][/color]
it's[color=blue][color=green]
> > basically copy the code and call the function.
> >
> > You mentioned the path: if you just wanted to browse for a folder, use[/color][/color]
this[color=blue][color=green]
> > one instead:
> > http://www.mvps.org/access/api/api0002.htm
> >
> > --
> > Allen Browne - Microsoft MVP. Perth, Western Australia.
> > Tips for Access users - http://allenbrowne.com/tips.html
> > Reply to group, rather than allenbrowne at mvps dot org.
> >
> > "Dave N" <nelsondavea@jo hndeere.com> wrote in message
> > news:3fd880a7$1 @news1.dpn.deer e.com...[color=darkred]
> > > I want to programatically open the Access "File" "Open" browse box to[/color]
> > search[color=darkred]
> > > for a file. When it is selected I wnat to have it put the path in a[/color][/color][/color]
text[color=blue][color=green][color=darkred]
> > > box so it can be added to a list box.
> > >
> > >[/color][/color][/color]