Results 1 to 2 of 2
  1. #1
    andy-29 is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2012
    Location
    Culver City
    Posts
    34

    Open another access db from a form

    I'm in need of opening another database from within a form.


    Button click, closes form and opens the other database.

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    To Open the File:

    Code:
    Application.FollowHyperlink "C:\FolderName\FileName.FileExtension"


    Do you want to Close the calling Form or the Database?

    For the Form:

    DoCmd.Close acForm, "YourFormName"

    For the calling Database:

    Me.Quit

    Of course, opening the second DB essentially closes the first DB, anyway.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Open word file off Access form
    By BorisGomel in forum Access
    Replies: 8
    Last Post: 07-12-2012, 12:01 PM
  2. Replies: 1
    Last Post: 05-03-2012, 02:25 PM
  3. Open pdf file from Access form
    By lios1984 in forum Access
    Replies: 7
    Last Post: 02-21-2012, 01:11 PM
  4. Replies: 1
    Last Post: 01-02-2012, 06:39 PM
  5. access search open new form
    By jellybeannn in forum Access
    Replies: 1
    Last Post: 08-05-2010, 05:18 AM

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