Running external app

[John]

Hi

How can I run a vb.net exe app from within access, while passing a parameter
to the vb.net app?

Thanks

Regards

 

[Dale Fye]

take a look at the Shell command.

Might also want to search the newsgroup on that command. The challenge is
always building the string with the quotes in the right places.

 

[Arvin Meyer MVP]

Hi

How can I run a vb.net exe app from within access, while passing a
parameter to the vb.net app?

You can run any registered file using the ShellExecute api:

http://www.mvps.org/access/api/api0018.htm

If you can use automation, you can pass the parameter from VBA. If not, the
vb.net app will need to pull the parameter from an Access table or query.

 

[aaron.kempf]

keep your parameters in the database

I prefer SQL Server because it is a natively supported database for
Access, VB6, VB.net, etc