Results 1 to 10 of 10
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    File Dialog object error (Access XP)

    When I use the FileDialog object method to get a filename or folder I now get a RunTime Error 438 - Object does not support property or method

    This used to work. Help!!

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: File Dialog object error (Access XP)

    Ignore my previous post. I was trying to use the FileDialog in Access 2000, I have since converted to Access 2002 and voila.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: File Dialog object error (Access XP)

    A further comment on this.

    Even though FileDialog does work in access 2002, the type msoFileDialogSaveAs does not.

    It is offered by Access, and compiles OK, but it does not work.

    I have been using it for months in 2003, but the other day i opened the same db in 2002 and this procedure crashed.

    The Microsoft Knoweldge Base has an article about this problem.
    Regards
    John



  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: File Dialog object error (Access XP)

    Hi John
    I was using FileDialog with the following parameters to get the address of a file or folder.

    I am using msoFileDialogFolderPicker and msoFileDialogFilePicker.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: File Dialog object error (Access XP)

    Pat,

    I think John meant his comment mostly for other Loungers reading this thread.

  6. #6
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: File Dialog object error (Access XP)

    Patt

    Hans is correct. I thought I would post my experience in case others encountered the same problem.
    I was going to start a new thread, but your recent post seemed a reasonable alternative.
    Regards
    John



  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: File Dialog object error (Access XP)

    My mistake <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: File Dialog object error (Access XP)

    I now have this problem in Access 2003, I had previously converted my FE database from Access 2000 to Acces 2002-2003 format.

    Can anybody shed some light.

  9. #9
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: File Dialog object error (Access XP)

    You mean the error "When I use the FileDialog object method to get a filename or folder I now get a RunTime Error 438 - Object does not support property or method" that started this thread?

    Does the db compile?
    Did you set a reference ? From memory, you need a reference to Windows Office ?

    Can you post the code showing what you are doing with the file dialog?
    Regards
    John



  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: File Dialog object error (Access XP)

    Thanks for your interest John.

    I was using a Clear filter and an add to filter commands. I looked up the help again and deleted those commands as that was how the Help was doing it, and it now works beautifully.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •