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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Brian

    Calling Form Function from another form

    Brian, Aug 25, 2003, in forum: Access Forms Coding
    Replies:
    2
    Views:
    507
    Marshall Barton
    Aug 25, 2003
  2. Marcel K.
    Replies:
    2
    Views:
    115
  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:
    111
    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:
    432
    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:
    107
    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:
    117
    robert d via AccessMonster.com
    Jan 14, 2006
  7. ThomasAJ
    Replies:
    2
    Views:
    193
    Klatuu
    Sep 10, 2007
  8. Don

    Open other Access Applications

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