Programmers can control which actions their users can take when viewing forms. In this video, learn how to allow or disallow additions, deletions, and edits.
- [Instructor] When you create VBA code for a form…or report, you can use the me object as a shortcut…to refer to that object.…If you're working with a form, for example,…you can use the me keyword properties to allow…or prohibit additions, edits, and deletions using that form.…I'll demonstrate how to define those properties…in this movie.…I have opened up the course database…and in the forms collection,…I have opened the categories form in design view.…You might see different forms based…on what you've done already in the course.…
I want to crate an event handler…for when the form is opened.…So I will right-click a blank spot…in the detail section and then click build event.…In the choose builder dialog box, I'll click code builder,…and click okay.…And I get an event handler for the detail click event.…That's actually not what I want.…So I'll go up to the object control, click it's down arrow,…and click form.…
Now I get a new event handler for when the form loads.…On the title bar of the code module window,…you can see form on the left and the object control…
- 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.