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.

Display or hide warnings

Display or hide warnings

From the course: Access: VBA

Start my 1-month free trial

Display or hide warnings

“

- Writing a VBA code lets you automate actions within your database. One benefit of that automation is speed. You don't need to users to initiate or confirm many actions, they just happen because of your code. Some actions, such as deleting a table row, usually do require users to verify the action. You can choose to hide those warning boxes, so your code runs without interruption. I'll demonstrate how to do that in this movie. I have opened the course database, and I need to create a form with two command buttons on it. One to turn warnings off, and the other to turn them back on. So I will go to the Create tab on the ribbon, and I'll click, Form Design. That gives me a form in the design view. On the Design contextual tab of the ribbon, I will click the Button control, and click on the body, the detail section of the form. I don't want to use the Command Button Wizard, so I'll just click, Cancel, and I have my first Command button. I'll do the same thing for another, and we have…

Contents