Opening Access Objects from Desktop

Frequently Used Methods.

1. Set the Form Name in Display Form Option of 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 FormOpen Action with the required Form Name in the Property.

Both the above options open a Form, always we wanted to open it first when the database is launched.

Opening Form Directly, without any Changes in Database.

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

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 be in the open state 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