Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Open Form in Other Database (A2K)

    Hereís what Iím attempting:

    From: SRT Systems.mdb

    I want to open form: frm 01 CN_99_Archives which is sitting in: SRT_ArchSys.mdb

    Having trolled thru the Forum I found the following code provided by Hans back in
    Post: 566,889 which appeared to answer my problem:

    Dim app As New Access.Application
    app.OpenCurrentDatabase "SRT_ArchSys.mdb"
    app.DoCmd.OpenForm "frm 01 CN_99_Archives"
    app.DoCmd.Maximize
    app.RunCommand acCmdAppMaximize
    app.Visible = True
    Set app = Nothing

    My problem is that Iím getting:

    Run-time error Ď7866í
    Microsoft Office Access canít open the database because it is missing, or opened exclusively by another user.

    Both MDBís are in the same directory and Iím the only one around.

    Iíd appreciate any suggestions as to what I may have missed in the translation,

    Cheers,
    Cheers,
    Andy

  2. #2
    Star Lounger
    Join Date
    Sep 2002
    Location
    Hastings, Sussex, England
    Posts
    67
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Open Form in Other Database (A2K)

    Andy,

    could this be as simple as the database not being in the default Access folder? If so, you'll need to add the path before the filename, e.g. "D:myfolderfilename,mdb".

    Worth a try.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Open Form in Other Database (A2K)

    Hi Jules,

    Thanks for the quick reply.

    Stupid, stupid Access! It should have known what I meant!

    Worked Perfectly,

    Thanks and Cheers,
    Cheers,
    Andy

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    Hastings, Sussex, England
    Posts
    67
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Open Form in Other Database (A2K)

    Andy,

    Glad to be of help.

Posting Permissions

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