Running VBA procedures lets you manage your data exactly like you want. In this video, learn how to run a VBA procedure.
- When you create VBA macros in Access,…you need to be able to run them…from inside of your database.…There are two main ways to do that.…The first is from within the visual basic editor…and the second is by clicking command buttons…on forms or other database objects.…In this movie, I will show you…how to do both of those things.…I have opened the course database…and I will start by creating a blank form…and then a command button.…So I'll go to the Create tab on the ribbon…and click blank form.…
I want to work with the form in Design View,…so I will, on the Design contextual tab of the ribbon…go to the View Control, click the down arrow,…and click Design View, there we go.…Now I can add a command button.…So I'll switch to the Design contextual tab…and then click the Button button on the controls gallery…and then click in the body of the form…in the Details section and I have a command button.…
I want to create my own code using VBA…so I will click cancel to get out of…the command button wizard and then I have my button here.…
- Working with macros
- Running a VBA procedure
- Debugging VBA code
- Defining variables, constants, and calculations
- Displaying a calculated result in a message box
- Repeating tasks with loops
- Manipulating database objects
- Adding, editing, and deleting records
- Looking up values in a table
- Automating processes with macros
Skill Level Advanced
What you should know1m 38s
1. Introduction to Visual Basic for Applications
2. Define Variables, Constants, and Calculations
3. Add Logic to Your VBA Code
4. Debug Your VBA Code
5. Manipulate Database Objects Using DoCmd
6. Read and Manipulate Table Data
7. Manipulate a Database Using the Application Object
8. Control Forms and Reports Using the Me Object
9. Automate Processes Using Macros
Next steps1m 7s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.