Jumat, 29 Januari 2016

Re: [MS_AccessPros] Folder picker debug problem

 

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 ~

On 1/29/2016 11:42 AM, runuphillracing@yahoo.com [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: 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:

Poskan Komentar