1

I have a database with a multiple fields 3 of which are: ID which is an autonumber IDtype which is text COMPANY which is text as well

with the variable: Dim rs As DAO.Recordset

when I do rs.FindFirst on the table I get the following results

rs.FindFirst "ID=367" -> code runs fine but this way only allows me to get that one specific record

rs.FindFirst "IDtype='71'" -> code runs fine

rs.FindFirst "COMPANY=XDRT" -> runtime error '3070': Access db engine does not recognize 'COMPANY' as a valid field name or expression (I also tried putting single quotes around XDRT and still same error)

The only difference between COMPANY field and IDtype field is the format is set to "@" for the COMPANY field

Any help on this would be much appreciated. Thanks in advance

Improve this question
1
  • The correct syntax is: rs.FindFirst "COMPANY='XDRT'", have you tried it? Commented Nov 4, 2013 at 22:52

3 Answers 3

Reset to default
1

As my comment noted, the correct syntax is: 

rs.FindFirst "COMPANY='XDRT'"

, have you tried it?

Moreover, you probably have error when creating DAO.Recordset.

Dim rs As DAO.Recordset
Set rs = CurrentDb.OpenRecordset("MyTable", dbOpenDynaset)

As such all the tree fields are selected: ID, IDtype and COMPANY.

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

1 Comment

I had tried the single quotes arround XDRT but I didn't put the field in the DAO.Recordset. Thanks very much
0

If Company has a datatype of Text, you need to use single quotes to search for a string in that case. Try this:

rs.FindFirst "COMPANY='XDRT'"
Improve this answer

Comments

0

In case someone else comes here for a different answer, I solved my issue by realizing that I hid the field I am using in the criteia from the SQL query for the Acccess Form! smart :)

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.