Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Custom Desktop Icon for different Macros

Access 101

Create Custom Desktop Icon for different Macros

by  DougP  Posted    (Edited  )
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:

"C:\Microsoft Office2000\Office\MSACCESS.EXE" "Y:\Databases\WEB Quotes2000.mde" /X OpenMain
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top