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.
Adam
---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :
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 ~
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 ~
On 1/29/2016 11:42 AM, runuphillracing@... [MS_Access_Professionals] wrote:
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: runuphillracing@yahoo.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar