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 every row in a table (recordset)

Display every row in a table (recordset)

From the course: Access: VBA

Start my 1-month free trial

Display every row in a table (recordset)

“

- [Instructor] If you, or one of your users, wants to review the values in a table without using a form, you can do so by moving through each tabled row and displaying a couple of fields values in a message box. For example, you could display a category name and a category number to make sure you haven't missed anything in your records. I'll demonstrate how to do that in this movie. I'm using the Show Records form, which you can find in the Forms section of the course database. This form is very simple, it just has a single button on it for Show All Records. I would like to add a VBA code routine that will run when the button is clicked. To do that I need to be in Design View. So on the Home tab, I'll click the View button's down arrow. And click Design View. Then I'll right click the Show All Records button. And at the top of the shortcut menu, click Build Event. In the Choose Builder dialog box, I'll click Code Builder and click OK. This code module is for command button zero on…

Contents