467,146 Members | 1,256 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

Open File Dialog

I am using Access 2010 (64 bit). I had no problem with the Access 2003 using the GetOpenFileName function with the "comdlg32.dll" declaration. With Access 2010 (64 bit) this does not work. I have found the following code on the web to show the Windows open file dialog box. How do I retrieve the path and file name that was selected?

Here is what I found to open the dialog box;
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdFileDialog_Click()
  2. Dim f    As Object
  3. Set f = Application.FileDialog(3)
  4. f.AllowMultiSelect = True
  5. f.Show
  6. MsgBox "file choosen = " & f.selecteditems.Count
  7. End Sub
Thanks,

ET
Nov 25 '13 #1
  • viewed: 7199
Share:
1 Reply
zmbd
Expert Mod 4TB
Please read thru the following insight article, it explains things in great detail.
Select a File or Folder using the FileDialog Object
Nov 25 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Bernavich2004 | last post: by
reply views Thread by ungvichian | last post: by
2 posts views Thread by nissiml | last post: by
9 posts views Thread by Amit D.Shinde | last post: by
3 posts views Thread by The ants are driving me crazy | last post: by
1 post views Thread by SAL | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.