No match in recordset

[Guest]

In access 97, there is a nomatch method that allows you to handle a seek that
does not contain a matching record. What would be the equivalent in
Access2000?

 

[Marshall Barton]

In access 97, there is a nomatch method that allows you to handle a seek that
does not contain a matching record. What would be the equivalent in
Access2000?

That has not changed in any version of Access. What prompts
you to ask if it has changed?

 

[Guest]

I get the error msg "Method or Data Member not found" when Icompile my code.

I bet it has something to do with my references but I don't know which one
it is.

 

[Douglas J. Steele]

The default in Access 2000 is ADO. Unless you explicitly added a reference
to DAO, you're doubtlessly using ADO. The ADO Seek method positions the row
at EOF if a match isn't found.

See
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthseek.asp?frame=true
and http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthseek.asp for
details and an example.

 

[Marshall Barton]

I get the error msg "Method or Data Member not found" when Icompile my code.

I bet it has something to do with my references but I don't know which one
it is.

Hard to tell without seeing the code, but MoMatch is a DAO
property. Are you sure the recordset was declared as a DAO
recordset?

 

[Guest]

THanks Doug,

I will look at this more closely when I get back from Vacation.