Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    277

    Unanswered: close one database open another?

    how do I close one database and go to another to switch from say the Dispatch program to the Accounting

    thanks in advance

  2. #2
    Join Date
    Dec 2004
    Posts
    277
    no one knows how to do this?

  3. #3
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404
    It's quite simple.

    Set up a button on a form, in the OnClick event something on the lines of:

    Shell ("C:\Program Files\Microsoft OfficeXP\Office10\MsAccess.exe C:\Finance.mdb"), vbNormalFocus

    Me.Application.Quit
    You could put the code behind other events, but I find it useful to have it on a clearly marked button so the user has an idea what to expect.


  4. #4
    Join Date
    Dec 2004
    Posts
    277
    ya know I knew that code... but just didn't think of it

    thanks for gettin my memory started this mornin

Posting Permissions

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