rs!my_record not in recordset collection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Has anyone else encountered this problem? I've created a recordset from a
table. Some of the fields in the table are numeric. After creating the
recordset with an SQL I try to retrieve the values of the columns by

rs!Metrics & ""
rs![Date_ID]

The error occurs on the rs![Date_ID] because it cannot find this in the
recordset. However, Date_ID evaluates to 200445. Substituting in
rs![200445] gives the correct value with no error.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table names in recordsets? 2
Opening a recordset in a function 3
Find record using recordsets 1
MS Access setting outlook reminders from a DAO recordset 0
Creating ADODB recordset in code 8
Getting the autonumber value after adding new record when dao points to SQL rather than JET 3
Access 2003 - select query with 2 parameters 3
Recordset Error 1

Back
Top