RunApp

[emillard]

I created a button on a form to run an application - linking customer information on the database to an image (scanned contract) I can open the image program but now I want to open to a specific page. I found sendkey statment but not quite what I need. Any help?

 

[Atomic Shrimp]

If you're using VBA you want the Shell command instead of RunApp.

You can open most programs with a specific file by just adding a space and the file path/name to the command line string, for example:

Shell "c:\program files\accessories\mspaint.exe c:\windows\1stboot.bmp", vbNormalFocus

Opens the Windows Paint App with a bitmap file called 1stboot in c:\windows\

Or if you want to open a file where the path and name are stored in a variable (called strYour...etc):

Shell "c:\program files\accessories\mspaint.exe " & strYourFileNameAndPath, vbNormalFocus

HTH

Mike