How to Create a Desktop Shortcut for a Form- Access Window Hidden 1

[eaglehill]

New Poster Here! Hello!

This routine will create a shortcut on the user's desktop that will just open up a form, the Access main window is hidden.

1- Create a macro that opens the form in Window Mode: Dialog

2- (optional)I usually have a "Close" command button that is coded:
DoCmd.Quit
and set the form's Close Button property to No

3- Create a new shortcut on the desktop. If you use the wizard, for the location text box enter:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "M:\CompanyApps\Task.mdb" /x "OpenTask"

**Include the quotation marks and spaces**
The format is: the location of the Access exec, the location of the mdb file, /x (run a macro), the macro name

4 - Right click on the new shortcut and choose properties. Change the Run dropdown to Minimized.

5 - You can rename the shortcut and change the icon

6 - If you have multiple users, you can distribute the shortcut ***the path to their exec file has to be the same, it usually is.

My users love this. They usually only interact with a few forms and this puts the forms one-click away.