Browse folder button on Access form

[Allen Browne]

Best way to choose a folder is outlined in this link:
[url]http://www.mvps.org/access/api/api0002.htm[/url]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
Reply to the newsgroup. (Email address has spurious "_SpamTrap")

"Dave Cole" <djc03fss@hotmail.com> wrote in message
news:23fe01c33f13$ce5e7050$a601280a@phx.gbl...

> I wish to create a browse folder button which basically
> allows the user to choose a folder which will then be
> used to find information and load it into the database.
>
> In a similar Word VBA app I used:
>
> dlgAnswer = Application.Dialogs(wdDialogFileOpen).Show
>
> To allow the user to select a file.
>
> I either want the Access equivalent or better still I
> want the user to choose a folder only and do the rest in
> code!
>
> Dave

[Dave Cole]

Thanks for that - looks exactly what I want

Dave

>-----Original Message-----
>Best way to choose a folder is outlined in this link:
> [url]http://www.mvps.org/access/api/api0002.htm[/url]
>
>--
>Allen Browne - Microsoft MVP. Perth, Western Australia.
>Tips for Access users - [url]http://allenbrowne.com/tips.html[/url]
>Reply to the newsgroup. (Email address has

spurious "_SpamTrap")

>
>"Dave Cole" <djc03fss@hotmail.com> wrote in message
>news:23fe01c33f13$ce5e7050$a601280a@phx.gbl...

>> I wish to create a browse folder button which basically
>> allows the user to choose a folder which will then be
>> used to find information and load it into the database.
>>
>> In a similar Word VBA app I used:
>>
>> dlgAnswer = Application.Dialogs(wdDialogFileOpen).Show
>>
>> To allow the user to select a file.
>>
>> I either want the Access equivalent or better still I
>> want the user to choose a folder only and do the rest

in

>> code!
>>
>> Dave

>
>
>.
>

[Dave Cole]

Thanks for that - looks exactly what I want

Dave

>-----Original Message-----

>> I wish to create a browse folder button which basically
>> allows the user to choose a folder which will then be
>> used to find information and load it into the database.
>>
>> In a similar Word VBA app I used:
>>
>> dlgAnswer = Application.Dialogs(wdDialogFileOpen).Show
>>
>> To allow the user to select a file.
>>
>> I either want the Access equivalent or better still I
>> want the user to choose a folder only and do the rest

in

>> code!

>
>See the following page at The Access Web:
>
> API: BrowseFolder Dialog
> [url]http://www.mvps.org/access/api/api0002.htm[/url]
>
>--
>Bruce M. Thompson, Microsoft Access MVP
>bthmpson@mvps.org (See the Access FAQ at

[url]http://www.mvps.org/access[/url])

>>>No Email, Please. Keep all communications

> within the newsgroups so that all might benefit.<<
>
>
>.
>