Microsoft Access Database Development With VBA

MAOL Topics: Opening a Table

   

Description

Opening a table is equivalent to opening a record set. Therefore, to open a table in the Microsoft Access Object Library, call the OpenRecordset() method of the Database class. This method can take as argument the name of the table on which you want to perform data entry. Based on this, here is an example of calling the method:

Private Sub cmdDataEntry_Click()
    curDatabase.OpenRecordset("Students")
End Sub

Once you have the record set, you can use it as you see fit. To support this, the OpenRecordset() method returns an object named Recordset. If you want to use the table after opening the record set, get the return value of the method. To do this, declare a variable of type Object and assign it to the return value of this method call. Here is an example:

Private Sub cmdDataEntry_Click()
    Dim curDatabase As Object
    Dim rstStudents As Object
    
    Set curDatabase = CurrentDb
    Set rstStudents = curDatabase.OpenRecordset("Students")
    
    . . . Use the table as you see fit

    Set rstStudents = Nothing
    Set curDatabase = Nothing
End Sub
   
     
 

Home Copyright © 2013 FunctionX, Inc. Home