From the course: Access 2021: Tips, Tricks, and Techniques
Join today to access over 24,700 courses taught by industry experts.
Create an AutoExec macro
From the course: Access 2021: Tips, Tricks, and Techniques
Create an AutoExec macro
- Sometimes you're going to want your Database to do several things on startup. Right now, I have a copy of the Database that we've been working with called Red30Tech AutoExecute. When I double click on it, you'll see my splash screen. And after three seconds, it'll automatically close and take me to the main menu. We can get similar functionality but with more flexibility, by using a special macro in the Database to control the startup behavior. Let's close this Database down and I'll reopen it by bypassing these startup options. I'll select it here in the Windows Explore. Hold down the Shift key and then double click on it to open it up. That'll bypass those startup options and give me access to the navigation pane and my ribbons. Now, the first thing I want to do is disable the splash screen. I'll go up here to the File tab, come down to Options. And in the current Database options, the display form property, I'll…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.