There are 3 parts to the Icon command line.
1. Drive and full path to the Access program itself ôMSAccess.exeö
2. Drive and full path to Access database (either .MDB or .MDE)
3. /X and Macro name (make the name without spaces in it)
Each of the three parameters has a space between it
To create a desktop Icon
1. Right click on the Desktop
2. Then click "New", then "shortcutö
3. Click the Browse button to find the Access Program itself (usually in C:\Program files\Microsoft Office\Office
4. Highlight the whole line it just found than copy it to the Windows clipboard. Press Ctrl-C
5. Next hit the browse button again to find the Database. It may be on a Network Share Drive
6. When you are back and see the whole network path to the database...
7. Press the "Home" Key on the keyboard. Then paste (press Ctrl-V) the path for Access in front of the path for the database. Press the space key once.
8. Hit the "End" key on the keyboard then press space bar once again.
9. Type /X and a space thenà
10. Type in the name of the macro
11. So you should end up with the following:
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.