From the course: Access: VBA
Unlock this course with a free trial
Join today to access over 25,500 courses taught by industry experts.
Requery and repaint forms
- [Narrator] When you manage an Access database, there's a lot going on behind the scenes. Occasionally, you will find that a table providing values to a form has changed, and your form doesn't contain the most recent values. You can also find that Access consistently fails to redraw a form properly. There are millions upon millions of Windows users around the world and it's impossible for the operating system programmers to get everything working perfectly, all the time, on every machine. If you happen to have created a form that doesn't redraw properly, then I'll show you how to repaint it so that it does look good. During this introduction, you might have noticed that I said these techniques refer to forms and I left out reports, well that's true. Normally the me object can refer to either forms or reports but what I'm showing you here refers to forms only. I have opened the course database and I'm currently looking at the Customers form in form view and I've also opened the…
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)
Allow or disallow additions, deletions, and edits3m 39s
-
(Locked)
Manipulate form filters3m 19s
-
(Locked)
Set the caption and background picture4m 38s
-
(Locked)
Requery and repaint forms4m 1s
-
(Locked)
Discover a record source2m 26s
-
(Locked)
Render a form or report visible or invisible2m 30s
-
(Locked)
-
-