Object variables represent database objects, such as tables or forms. In this video, learn how to define and use an object variable,
- [Narrator] When you want to use VBA…to manipulate an open table, form,…or other database object,…you need to assign that object to a variable.…Those variables are called object variables.…And in this movie, I will show you how to work with them.…I have opened the course database…and I have opened the product and categories forms…so I can work with them in VBA.…With those two objects open I can press…alt F11 to move to the visual basic editor.…
In the visual basic editor I will create a code module.…So I'll go to the insert menu and click module.…And an empty code module appears.…The first thing I'll do is create my subroutine.…So I'll type sub and then show form name…and open and closed parenthesis because I'm not…adding any arguments to be used in the subroutine.…And I'll press enter a few times…to give myself some room to work.…
The first thing I need to do is to declare a variable…that will hold the form.…And that will be dim.…The variable name is my form.…And we will declare it as type form.…So I have a variable called my form…
- 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.