Hi Adam,
use:
As Object
instead
warm regards,
crystal
VBA Tip: Select File or Folder using FileDialog using Access (cc)
by Adrian Bell
http://www.youtube.com/watch?v=rNHLea359p4
~ have an awesome day ~
I need help figuring out why I get a Variable not defined compile error on msoFileDialogFolderPicker
in the function:
Public Function FSBrowse(Optional strStart As String = "", _
Optional lngType As MsoFileDialogType = msoFileDialogFolderPicker, _
Optional strPattern As String = "All Files,*.*") As String
which is called from strPath = FSBrowse(lngType:=msoFileDialogFolderPicker)
The exact same code (in utility module) works in one database but not in another.
Adam
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar