Microsoft® Access® 2010 Inside Out

Controlling How Your Application Starts and Runs

Especially if you’re distributing your application for others to use, you probably want your application to automatically start when the user opens your database. You’ll also want to create a main form, such as a navigation form, to help the user navigate to the various parts of your application. You should also set properties and write code to ensure that your user can cleanly exit your application.

Setting Startup Properties for Your Database

At this point, you know how to build all the pieces you need to fully implement your database application. But what if you want your application to start automatically when you open your database? One way is to create a macro named Autoexec—Access always runs ...