Results 1 to 3 of 3
  1. #1
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402

    open db from within a db


    Hi, I'm back after a long break of not working and need some help, I have been given the job of creating a simple db - 1 form with several buttons each to be used to open a different database they have on thier server. Can I open other db's from this form action, keeping the first form/db open so it's still available after they close the db they selected on the form?
    If so some direction on how to do this would appriciated thanks.
    regards
    Trevor

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    depending on what you what to do...

    you could use the opencurrentdatabase method

    https://msdn.microsoft.com/en-us/lib.../ff837226.aspx

    or to open within the current instance you would use the opendatabase method

    https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

    or to open in a new instance of access look at the shell function

    https://msdn.microsoft.com/en-GB/lib...(v=vs.90).aspx

  3. #3
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402
    thanks for the fast reply, I'll look into these options and see how I get on.

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

Similar Threads

  1. Replies: 2
    Last Post: 04-25-2014, 11:22 AM
  2. Replies: 2
    Last Post: 08-07-2013, 07:44 AM
  3. Help on report to open form to open query...
    By saseymour in forum Programming
    Replies: 13
    Last Post: 07-16-2013, 08:11 AM
  4. Replies: 10
    Last Post: 06-13-2012, 05:57 AM
  5. Replies: 2
    Last Post: 02-26-2010, 08:14 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