INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Access 101

Create Custom Desktop Icon for different Macros by DougP
Posted: 10 Oct 01

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

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close