BobLoblaws
Programmer
I have an Access database on a shared network drive. There is another vb application in the same folder.
In the Access App, when a user clicks on a button, I want to open the vb app. I can't hard code the location because the shared folder is mapped differently on each pc that opens the database.
Ideally, I would like the Shell() to look in the same folder as the database.
I have tried Shell("vbApp.exe"
, Shell("\vbApp.exe"
, Shell(".\vbApp.exe"
and none of it seems to work.
In the Access App, when a user clicks on a button, I want to open the vb app. I can't hard code the location because the shared folder is mapped differently on each pc that opens the database.
Ideally, I would like the Shell() to look in the same folder as the database.
I have tried Shell("vbApp.exe"