Directory Picker for Access VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt Sonic - 29 Mar 2005 16:33 GMT

Isn't there a directory picker control for MS Access? All I need to do is
select a directory and save it's path in a table. ???

Reply to this Message

Alex Dybenko - 29 Mar 2005 17:26 GMT

Hi,
you can use API call like here:
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=39

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Isn't there a directory picker control for MS Access? All I need to do is
> select a directory and save it's path in a table. ???

Reply to this Message

Douglas J. Steele - 29 Mar 2005 23:46 GMT

In addition to Alex's great example, Stephen Lebans has code at
http://www.lebans.com/callbackbrowser.htm that will let you open the browser
at a particular folder.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> you can use API call like here:
[quoted text clipped - 3 lines]
>> is
>> select a directory and save it's path in a table. ???

Reply to this Message

Stephen Lebans - 30 Mar 2005 02:01 GMT

I've got an updated version that works with Networks that I need to post
sometime as well.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

> In addition to Alex's great example, Stephen Lebans has code at
> http://www.lebans.com/callbackbrowser.htm that will let you open the browser
[quoted text clipped - 17 lines]
> >> is
> >> select a directory and save it's path in a table. ???

Reply to this Message

linjuan - 24 May 2005 02:22 GMT

"ui0puip-0iou8-

Reply to this Message