From the course: Access: VBA
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Examine the Access object model
- [Instructor] Microsoft Access is a huge program with hundreds, if not thousands, of objects, but the program team defined every element of Access from the application itself to individual table rows as objects that you can manipulate using VBA commands. Taken as a whole, the definitions comprise the Access Object Model. The first thing to know is that it is absolutely huge. Like I said, hundreds, even thousands of objects, not to mention the properties, methods, and events that go along with them. You can read it in a book, and there are several good references, but it's better to look at it within Access. In this movie, I will hit the high points. We'll start at the top with the application object, and this is the top level for an instance of Access. You can have two copies of Access running at the same time, and each one of them is a separate application. What are the properties that are useful within the application object? Well, there's CurrentDb, which refers to the database…
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.
Contents
-
-
-
(Locked)
Introduction to object-oriented programming1m 59s
-
(Locked)
Examine the Access object model4m 57s
-
(Locked)
Work in the Visual Basic Editor3m 52s
-
(Locked)
Create, export, and delete code modules5m 47s
-
Create a subroutine5m
-
(Locked)
Create a function5m 26s
-
(Locked)
Add comments to your code4m 15s
-
(Locked)
Run a VBA procedure5m 7s
-
(Locked)
-
-
-
-
-
-
-
-
-