If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using OpenRecordset
I have a button on a form called "command9". When this is clicked I want to go through all the entries of a table called, "Device Table". I using the following code:
Private Sub Command9_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("Device Table") With rs Do Until .EOF I am getting the following error, "Runtime error '13': Type Mismatch". Have I declared rs wrong? How can I over come the problem? Can this be run on queries as well as on tables? Any help would be much appreciated. |
Thread Tools | |
Display Modes | |
|
|