Join Curt Frye for an in-depth discussion in this video Introducing Access Automation, part of Access: VBA.
Microsoft Access is a powerful program.…One of its most useful aspects is the built-in flexibility to customize the…program using macros, data macros, and Visual Basic for Applications.…In this movie, I'll describe how you can use each of those capabilities to…enhance your Access databases.…Macros are a series of steps that you can have Access replay automatically.…For example, in this database I have the Open Products Report macro, which is…here in the Navigation pane.…If I right-click the macro and click Design view, you can see the steps, or in…this case the single step, in the macro.…
What this macro, which is named Open Products Report, does is to implement the…OpenReport method, and then it opens the report named Products Report, and that…Product Report is here in the Navigation pane.…With the macro open, if I click Run, Access runs the code and displays…the Products Report.…I will go ahead and close the Products Report by pressing Ctrl+W and do the same…for the Open Products Report macro, pressing Ctrl+W again.…
Author
Curt Frye
Released
10/6/2011- Working with macros and managing macro security settings
- Creating, exporting, and deleting code modules
- Running a VBA procedure
- Debugging VBA code
- Defining variables, constants, and calculations
- Displaying a calculated result in a message box
- Repeating tasks with loops
- Creating conditional statements
- Manipulating database objects, such as forms, tables, and queries
- Adding, editing, and deleting records
- Looking up values in a table
- Requerying and repainting forms
Skill Level Advanced
Duration
Views
-
Introduction
-
Welcome54s
-
-
1. Automating Processes Using Macros
-
Running macros2m 30s
-
Working with data macros4m 15s
-
2. Introducing Visual Basic for Applications (VBA)
-
Creating a subroutine1m 41s
-
Creating a function4m 12s
-
Adding comments to your code2m 59s
-
Running a VBA procedure1m 23s
-
3. Debugging Your VBA Code
-
4. Defining Variables, Constants, and Calculations
-
Managing variable scope5m 4s
-
Defining an array6m 21s
-
5. Adding Logic to Your VBA Code
-
6. Manipulating Database Objects Using DoCmd
-
Opening a form6m 18s
-
Opening a report4m 45s
-
Opening a table3m 30s
-
Opening a query3m 24s
-
Closing an object3m 59s
-
Running a menu command2m 28s
-
-
7. Reading and Manipulating Table Data
-
Closing a Recordset3m 39s
-
Deleting the current record4m 49s
-
Moving within a Recordset5m 12s
-
8. Manipulating a Database Using the Application Object
-
9. Controlling Forms and Reports Using the Me Object
-
Manipulating form filters6m 15s
-
Conclusion
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: Introducing Access Automation