Q
QB
I know one can create a shortcut to a form, but how can I do this using vba?
Thank you for your help,
QB
Thank you for your help,
QB
Jim,
actually my question has changed since I posted it originally. I am now
able to create a shortcut using vba to launch my db.
My issue is that I want the shortcut to run a macro. I tried using the /x
command line switch but it does nothing. The db opens correctly, but nothing
happens! I checked the macro does work.
My shortcut's target is
"D:\Main\My Documents\devlor.mdb" /x PerfChecks
Any idea why it will not trigger the macro. Is my synthax wrong?
The result of not supplying a complete os command is the os will look in the
registry for the executable associated with the file name and associated
arguments. These are called the defaults. Your defaults (till you change
them) look something like this:
"c:\program files\microsoft office\office11\msaccess.exe" %1
That means no matter how many arguments you supplied, it only accepts one
argument, the file name, and ignores the rest.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.