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]

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" <ne*********@johndeere.com> wrote in message
news:3f********@news1.dpn.deere.com...

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.

[David Nelson]

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]

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" <Al*********@SeeSig.Invalid> wrote in message news:<3f**********************@freenews.iinet.net. au>...

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" <ne*********@johndeere.com> wrote in message
news:3f********@news1.dpn.deere.com...

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]

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" <he******@naco.nl> wrote in message
news:11**************************@posting.google.c om...

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" <Al*********@SeeSig.Invalid> wrote in message

news:<3f**********************@freenews.iinet.net. au>...

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" <ne*********@johndeere.com> wrote in message
news:3f********@news1.dpn.deere.com...

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.