Opening Access Objects from Desktop

Opening Access Objects from the Desktop.

1. Set the Form Name in the Display Form Option of the current database in Access Options.

   BIG DEAL! This is the first trick any novice learns when he/she starts learning Microsoft Access.

2. Create an AutoExec macro with the FormOpen action and the required Form Name in the Property.

The above method opens the form when the database is launched.

Opening a Form Directly, without any Changes to the Database.

We would like to launch a specific Form tomorrow to continue updating data in that form, without making any changes in the database.

If you would like to print a particular Report, first thing in the morning without fail, then here is a simple trick.

Note: Your Database's Navigation Pane must be accessible.

1. Open the Database.

2. Click the Restore Window Control Button to reduce the Application Window size, so that the empty area of the Desktop is visible.

3. Click and hold the Mouse Button on the Form Name in the Navigation Pane, then drag the form to the desktop and drop it there.

4. Close the Database.

5. Double-Click on the Desktop-Shortcut. The Form will open when the Database is open.

   You can open the following Objects directly with Desktop-Shortcuts:

   • Report.

   • Table.

   • Select Query.

   • VBA Module.

   • Macro.

Try it out yourself.

1. MS-Access Class Module and VBA
2. MS-Access and Collection Object Basics
3. Dictionary Objects Basics
4. Withevents and All Form Control Types