Passing parameters into Access using VBA

[MaryM]

Hi
I am trying to pass some text parameters into Access using VBA, but can't seem to find any code to do this.
Does anyone have any ideas?

Thanks

 

[AlanS]

What object are you trying to pass parameters to, and in what context?

 

[MaryM]

Hi
I'm trying to pass from another system, which will run a program passing 5 pieces of information. The program being Access and then display the 5 pieces of info or use one of them as a key to get a record and show this record.

 

[AlanS]

You can use the /cmd command line argument to pass a text argument to Access on startup, and which will be available while your application is running via the Command() function. If that's not practical, you can put the argument(s) into a simple text file, and have some VBA code in Access read that file as needed.