can I run an exe. file from a command button in access?

  • Thread starter Thread starter JIXPIX
  • Start date Start date
J

JIXPIX

I have a very small .exe file which I understand from the manufacturers just
'kicks' open a cash drawer - can I add the instruction to run it to a button
in MS Access? please be kind, struggling here!

Outside of Access the file runs without a problem, probably being dense but
cannot see how to add command to the button!

Thanks in anticipation of help!
 
JIXPIX said:
I have a very small .exe file which I understand from the manufacturers
just
'kicks' open a cash drawer - can I add the instruction to run it to a
button
in MS Access? please be kind, struggling here!

Outside of Access the file runs without a problem, probably being dense
but
cannot see how to add command to the button!
Click to expand...


You should be able to use the Shell function to run the .exe. Something
like this code for the button's Click event:

'----- start of code -----
Private Sub cmdOpenDrawer_Click()

Shell "C:\Program Files\Some Folder\OpenDrawer.exe", vbMinimizedNoFocus

End Sub
'----- end of code -----

Obviously, you have to correct the names and path in the above example.
 
Use the Shell function:

Shell """C:\Program Files\MyApp\MyApp.exe"""

That's three double quotes in a row before and after: because of the space
in the path, you need to ensure that there are quotes around the path, and
to put quotes in a quoted string, you need to double the quotes.
 
Douglas J. Steele said:
Use the Shell function:

Shell """C:\Program Files\MyApp\MyApp.exe"""

That's three double quotes in a row before and after: because of the space
in the path, you need to ensure that there are quotes around the path, and
to put quotes in a quoted string, you need to double the quotes.
Click to expand...


I don't seem to need the quotes if there are no command-line arguments.
 
You could be right. I didn't test, but it makes sense that it would see
everything before the comma as a command.
 
Many thanks to both of you for your responses, unfortunately neither works (suspect it's user error on my part).

Here's the script as it appears in MS Access....

Private Sub Open_Drawer_Click()
Shell "C:\users\Janine\Documents\Worpos\USBCRopen.rls\USBCRopen.exe", vbMinimizedNoFocus
End Sub

Nothing happens!

if I double click the exe file the drawer opens fine, likewise if I add and html link in access it opens ok once I've confirmed acceptance against the two windows messages which come up as;

"A potential securtiy concern has been identified, ........ do you want to continue?"

and after that a further message saying that some files may contain virus' would I like to open this file.

As I said, am not used to VBasic so any help really appreciated!

JixPix
 
Back
Top