Jumat, 29 Januari 2016

Re: [MS_AccessPros] Re: Folder picker debug problem


oh wait a minute .... sorry I gave you bad information

 use the VALUE of msoFileDialogFolderPicker, which is 3 and is a number not an object so try Integer as the data type


warm regards,

~ have an awesome day ~

On 1/29/2016 12:27 PM, runuphillracing@yahoo.com [MS_Access_Professionals] wrote:

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 :

Hi Adam,

As Object


warm regards,

VBA Tip: Select File or Folder using FileDialog using Access (cc)
by Adrian Bell

~ 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.



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 (6)



Tidak ada komentar:

Posting Komentar