How do I use FolderBrowserDialog in Access 2003..."W/O" VS install

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

M.C - 14 May 2008 17:36 GMT

As title, working on Access 2003 here and trying to find/utilize
"FolderBrowserDialog" without Visual Studio installed. Is it still possible?

10-4

Reply to this Message

Douglas J. Steele - 14 May 2008 19:23 GMT

Use the code from http://www.mvps.org/access/api/api0002.htm at "The Access
Web".

Signature

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

> As title, working on Access 2003 here and trying to find/utilize
> "FolderBrowserDialog" without Visual Studio installed. Is it still
> possible?
>
> 10-4

Reply to this Message

Albert D. Kallal - 15 May 2008 07:44 GMT

> As title, working on Access 2003 here and trying to find/utilize
> "FolderBrowserDialog" without Visual Studio installed. Is it still
> possible?

Dim f As FileDialog
Set f = Application.FileDialog(msoFileDialogFilePicker)
f.Show
MsgBox "file choose was " & f.SelectedItems(1)

You can use late binding if you wish (I actually recommand the following
code).

Dim f As Object
Set f = Application.FileDialog(3)
f.AllowMultiSelect = True
f.Show

MsgBox "file choosen = " & f.SelectedItems.Count

The above works well with the runtime version also....

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message