How to use VBA to reference table records and field values after opening a database in ACCESS

In fact, I personally feel that you can't express yourself clearly.

I have to talk about it a little bit here.

1. About creating forms. Select the table where you want to display the data, then click Insert form, follow the wizard to finish, and then adjust the controls to add aesthetics.

2. The form obtained according to 1 is a bound form, so there is no problem such as reference table records. When set to Unbound or Semi-Bound (unbound is defined as: the data source is empty, and the control is not bound; Semi-binding: unbound data source, bound control, you need to use references.

Unbound reference method: a, as mentioned on the first floor, use dlookup to implement; b. Open the recordset and populate the elements of the recordset to the control. Semi-bound reference methods can be used to update the data source during some events, or to reference unbound reference methods.

3. About entering the VBE interface.

The most common method: select the control right-click on the property (for the form, you only need to right-click on the body and select the form in the drop-down box) event, select "Event Process" to enter the VBE interface (if the dialog box pops up, select the bottom "**" to enter).

For buttons, by default, as long as the button control is added, a dialog box will pop up directly to select, please cancel it and then follow the above method.

Alternatively, you can press Alt+F11 to go directly to the VBE interface, which will enter the module level by default, and then you can select the form on the left (if not, select "Project Explorer" on the VBE view. , then double-click and select Controls and Event Procedures in the "General" and "Declarations" sections on the right (so, if you don't know enough about event processes, it's best to do it the first way).

Field values can be referenced using the dlookup function.

1. First of all, find and open the access database on your computer, as shown in the figure below.

2. Then click "Visual Basic" in the "Database Tools" tab, as shown in the following figure.

3. In the pop-up VBA interface, select the database first, then right-click, select "Insert", "Module", different from VBA in Excel, VBA** in Access needs to be placed in the module, as shown in the figure below.

4. Enter VBA** in the module and click "Run Subroutine", as shown in the figure below.

5. In this way, the input VBA** will run in the access database, as shown in the following figure.

2.In the Actions section, select RunCode from the drop-down list.

3.The operation parameters dialog box pops up, click on the ellipsis to the right of the function name.

4.Open the expression generator, select the function below, or enter the formula yourself, and click the OK button.

5.Click the Save button at the top of the menu bar, enter a name for the macro in the Save As dialog box that pops up, and then click OK.

6.In the macro object, find the macro you just created [Run VBA], then right-click it, select Run, and the VBA function will run.

Premise: The OpenQuery method of the DOCMD object is only available in the Microsoft Access database environment (.).mdb)。

Syntax: , view, datamode).

The openquery method is used to open a preset query, but not a SQL query statement, so your above usage is incorrect.

The correct way to use it is to pre-save the SQL statement: "select * from student transcript where score" 90 as an access query, for example, name: high score score query table.

Then add the following procedure to a command button. For example:

private sub command1_click:

High Score Enquiry Form"

end sub

Note: The use of the openquery method of the docmd object can be varied, but only one example is listed above.