Calling Access 'form' from other applications

Discussion in 'Access Forms Coding' started by jan.simpson@bigpond.com, Dec 12, 2013.

  1. Guest

    Hi

    I can’t seem to find any relevant posts regarding my particular issue/question...
    I have several Access databases and forms, and want to be able to ‘integrate’ these dbs and forms to "other systems".
    I have done this in the past by using command-line <start msaccess.exe ‘database’ /x ...> calls to open Access and load a macro.
    The macro calls/runs modules.

    This has served fairly well until later versions of Access and OS. Now eachtime the command line is sent, multiple versions of Access get loaded. I know I can use the \excl switch at command line to prevent multiple copies of the same database, but that only stops a new instance of the Access database loading and will not execute the macro/module.

    What I really want to do is send a command to a particular Access database,load it if it is not already loaded and open a form to display the relevant data/record, or if the database is already loaded, open a form to displaythe relevant data/record.

    One way I do get the relevant data is write a text file (from APP1 which isnot an access database) with the search argument from the originating application, then when the appropriate Access database is loaded, a module is called to read the text file, creating search criteria and then apply the criteria to the form.

    I do a lot of prototyping and proof of concept development with Access, andam currertly trying to integrate Access to MapInfo and several web-based applications where the Access runs Client-Server with SQL Server backend

    Can anyone help?

    Thank.... Jan
     
    , Dec 12, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Brian

    Calling Form Function from another form

    Brian, Aug 25, 2003, in forum: Access Forms Coding
    Replies:
    2
    Views:
    463
    Marshall Barton
    Aug 25, 2003
  2. Marcel K.
    Replies:
    2
    Views:
    95
  3. Phil Everist

    Identify calling form for use by a common calander form

    Phil Everist, Dec 10, 2003, in forum: Access Forms Coding
    Replies:
    2
    Views:
    87
    PC Datasheet
    Dec 10, 2003
  4. Savvoulidis Iordanis

    Calling DoCmd.RunCommand acCmdSaveRecord, after calling an API function

    Savvoulidis Iordanis, Mar 14, 2005, in forum: Access Forms Coding
    Replies:
    2
    Views:
    408
    Savvoulidis Iordanis
    Mar 19, 2005
  5. Vensia

    Calling Sub Procedure In Other Form

    Vensia, Apr 5, 2005, in forum: Access Forms Coding
    Replies:
    4
    Views:
    89
    Andreas
    Apr 6, 2005
  6. robert d via AccessMonster.com

    Calling a form module but opening the form with acHidden

    robert d via AccessMonster.com, Jan 13, 2006, in forum: Access Forms Coding
    Replies:
    1
    Views:
    93
    robert d via AccessMonster.com
    Jan 14, 2006
  7. ThomasAJ
    Replies:
    2
    Views:
    169
    Klatuu
    Sep 10, 2007
  8. Don

    Open other Access Applications

    Don, Jan 27, 2009, in forum: Access Forms Coding
    Replies:
    6
    Views:
    137
    Douglas J. Steele
    Jan 28, 2009
Loading...