Launching macros at startup is just that: having a macro event run every time you start Microsoft Access. Programming macros to launch when Microsoft Access launches is a good way to automate and streamline work that is part of your daily schedule. This video gives a detailed explanation on how to configure macros to launch at startup.
It might be useful to have a macro run immediately when the database is first opened.…We could do that by giving one of our macro objects a very special name.…Let's create a macro that will run at startup.…I'll go to the Create tab and create a new Macro in Design View here.…First thing I want to do is have a little message box pop up welcoming us to the…No Obstacles Database.…I'll type in M E and that will jump me to the MessageBox action.…I'll press Enter and here we can fill in the details.…The message is going to be Welcome to the No Obstacles Database.…
If you have any questions, please ask Adam.…We could choose whether we want the MessageBox to Beep or not, I am going…to change that to No.…We can have a Type here, it can either be a None,…it can be a Critical message, a warning or an Informational message.…This will define what icon displays to the left of it.…I am going to leave it as None.…And we can have a Title here that will appear at the top of the MessageBox.…I am going to put in the No Obstacles tagline, Defy Obstacles, Live Boldly.…
Author
Adam Wilbert
Released
2/8/2013- Understanding table structures and relationships
- Setting primary and foreign keys
- Establishing relationships and maintaining referential integrity
- Sorting and filtering data
- Building queries with constraints and criteria
- Editing table data with queries
- Generating forms from tables
- Adding form controls
- Creating reports with totals and labels
- Embedding macros in buttons
- Repairing your database
- Protecting databases with passwords
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 1s
-
-
1. Getting Started
-
Key database concepts4m 21s
-
Creating the database file3m 25s
-
Digging in to Ribbon tabs3m 39s
-
Using the Navigation pane3m 36s
-
Taking backups47s
-
Accessing help1m 8s
-
-
2. Creating Tables
-
Importing tables4m 57s
-
3. Setting Field Properties
-
Setting the default value2m 15s
-
Creating lookup fields4m 29s
-
4. Organizing Records
-
Formatting columns2m 52s
-
Sorting table data3m 18s
-
Filtering table data2m 21s
-
-
5. Using Queries
-
Understanding queries2m 2s
-
Building expressions5m 23s
-
-
6. Working with Specialty Queries
-
Using update queries3m 21s
-
Using make table queries2m 57s
-
Using delete queries2m 48s
-
Using append queries2m 49s
-
-
7. Creating Forms
-
Generating forms from tables3m 10s
-
Using the Form Wizard2m 38s
-
8. Designing Forms
-
Setting data sources5m 39s
-
Understanding input boxes3m 31s
-
Recording navigation2m 36s
-
Adding buttons4m 18s
-
Assigning tab order4m 5s
-
Creating a navigation form3m 36s
-
9. Creating Reports
-
Introducing reports2m 15s
-
Using the Report Wizard5m 9s
-
Creating calculated totals3m 32s
-
Creating labels4m 18s
-
Adjusting print settings2m 58s
-
-
10. Working with Macros
-
Creating macros5m 3s
-
-
11. Integrating Access with the Office Suite
-
Emailing with macros4m 4s
-
12. Maintaining the Database
-
Documenting your work4m 41s
-
Creating custom Ribbon tabs3m 35s
-
Conclusion
-
Next steps1m 6s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Launching macros at startup