Results 1 to 2 of 2
  1. #1
    ChrisW is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    1

    Passing a Parameter into a MS Access 2007 Form from Command Line

    I'm trying to pass a parameter from one of my work's applications. This application runs command lines to get to the data, which is now stored in an Access database instead of separate Excel spreadsheets.

    I can open the database and view the form I need just fine with the command line: "C:\Test.accdb" /ro /x Form1

    The problem is that the user now has to select a value from a combo box in the form. Is there a way to pass a parameter from the command line from my work's application into that combo box? I've been searching for a way to do this, but I'm new to a lot of this. Can I create a batch file or script that can do this? Maybe something else?



    Thanks,


    Chris

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    I doubt that is possible.

    What is it the user has to select from combobox? Is it an unbound control? Why have a combobox if you want to make the choice for the user?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Passing Parameter from Excel TO Access
    By jo15765 in forum Queries
    Replies: 1
    Last Post: 11-29-2011, 03:28 PM
  2. Parameter Passing
    By Juan4412 in forum Queries
    Replies: 1
    Last Post: 11-21-2011, 10:23 AM
  3. Passing List of Parameter
    By vignes10 in forum Access
    Replies: 3
    Last Post: 09-15-2011, 07:35 AM
  4. Replies: 10
    Last Post: 09-27-2010, 08:06 PM
  5. Macro passing a parameter
    By SlowPoke in forum Access
    Replies: 1
    Last Post: 09-26-2010, 09:57 PM

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