I assume "instead" refers to As String, of which there are several. Didn't work no matter where I tried it. That doesn't explain why the code works in another database.
---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :
VBA Tip: Select File or Folder using FileDialog using Access (cc)
by Adrian Bell
~ 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.
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (3)|