How to reference a variable-named field in an ADODB recordset

Question

I'm currently working on a project which looks like this:

set rs15 = new adodb.recordset
dim course1 as string
course1=label1

rs15.open " select * from  CourseYear where Surname like' " & text12 & " ' ", con1, 3, 3

rs15!(course1)=text1.text
rs15.update


msgbox "success"

course1 is a string contains the label1 which corresponds to the field name on my database. I was trying to call that label in rs15!(course1), but it says type-declaration character does not match the datatype.

pinkfloydx33 · Accepted Answer · 2017-02-20 00:49:18Z

1

You can access a variable named field by using the Fields property directly. Instead of the recordset!fieldname notation use recordset.Fields(fieldname).

In your case this would be: rs15.Fields(course1)=text1.Text

See here for more information

answered Feb 20, 2017 at 0:49

pinkfloydx33

12.9k3 gold badges54 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to reference a variable-named field in an ADODB recordset

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related