469,626 Members | 978 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

Use the File Open Browse box

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.
Nov 12 '05 #1
4 1902
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.

Nov 12 '05 #2
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!
Nov 12 '05 #3
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.

Nov 12 '05 #4
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.

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Flashman | last post: by
3 posts views Thread by JoNaS | last post: by
2 posts views Thread by OutdoorGuy | last post: by
3 posts views Thread by Farshid Lashkari | last post: by
1 post views Thread by Dachshund Digital | last post: by
5 posts views Thread by =?Utf-8?B?UGF1bA==?= | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.