Results 1 to 10 of 10
  1. #1
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    74

    FileDialog

    Greetings,



    What must I do to get "FileDialog" to appear in Code?

    I use this in the following code to open a select folder; Strangest thing...It works in one database (same version) but not the other..

    Any help would be appreciated!

    Tommy


    Private Sub Command496_Click()

    Dim fd As FileDialog

    Set fd = Application.FileDialog(msoFileDialogFilePicker)

    fd.InitialFileName = "W:\VanPool\ACTIVE VANPOOL FILES\" & Me.ID_CODE

    fd.Show
    End Sub

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    what does "doesnt work" mean?

  3. #3
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    74
    In one database in Code, when initially typing in FileDialog, a list comes up that shows "FileDialog" as an option.

    In another database, no such list comes up.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    wow, what are your references?? can you tell us pls? what are the differences between the two? alternatively, are you sure the other db has intellisense turned on?? if it's off, that'll happen.

  5. #5
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    74
    how do I check if the intellisense is on/off?

  6. #6
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    74
    btw - many thanks for the assistance!

  7. #7
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by Tomfernandez1 View Post
    btw - many thanks for the assistance!
    OK!

    in the vb editor: TOOLS > OPTIONS > AUTO LIST MEMBERS.

  8. #8
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    74
    Auto List Members is currently checked

  9. #9
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by Tomfernandez1 View Post
    Auto List Members is currently checked
    ref lists??

  10. #10
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    74
    checked Microsoft Office 12.0 Object Library and am now able to find "Filedialog" on a list.

    Thanks, so much for the direction and assistance!!

    Tommy

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums