Results 1 to 2 of 2

Thread: Open Dialog

  1. #1
    Join Date
    Apr 2002

    Unanswered: Open Dialog

    I use linked tables to a MDB in a server. Sometimes, the
    MDB is moved to another directory, so I have to re-link
    it. Does anyone know how to get "Open" dialog box in
    Access ? In Excel, I use Application.GetOpenFilename. What
    it does is it opens "Open" dialog box, and you can click
    on a file you want, and it returns the full path and the
    name of the file you click.

    I need this for my linked tables. If the originalDB is
    moved to other directory, users can click on a button that
    asks for a new path and it links to the new path. Up to
    now, I use InputBox, but it's a bit annoying when the path
    is long.


  2. #2
    Join Date
    Nov 2001

    This question was answered here several times, just search this forum.


Posting Permissions

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