Software

Ask something
Discussion Locked

Access Question

0 helpful
2 replies

by chiangchien

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I developed an Access database and am having an issue. Is there any way to use a command line switch so that the database can pull up a particular record? My application is being called from a different program and it would be great if we could pull the account that we need up directly instead of searching for it within the access program.

2 replies

by sgt_shultz

i think there are lots of ways to do what you want. one is, just add the database name after a space on the command line, e.g. access.exe mydatabase. you can also have it run a macro, e.g. access.exe mydatabase /x mymacro.
see all the command-line switches for access 2000 at support.microsoft.com search for article 209207.
instead of having your application call up the database, why not have it call up a query (this is where the macro might come it, can run the query at startup). you can makeit a parameter query (see Help in Access, it's easy). then when your application calls the query, you'll be prompted for the parameter to specify the search criteria for the record...does this make sense/fill the bill?

by chiangchien

Is there a way that I can include on the command line the exact quantity I need to search for? Basically, it is a customer number field so that we can bring up the information about a particular client directly from the command line?

This discussion is closed to new replies.