No match in recordset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cyberwolf - 30 Jun 2006 17:04 GMT

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?

Signature

James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

Reply to this Message

Marshall Barton - 30 Jun 2006 17:44 GMT

>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?

Signature

Marsh
MVP [MS Access]

Reply to this Message

Cyberwolf - 30 Jun 2006 17:55 GMT

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.

Signature

James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

> >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?

Reply to this Message

Marshall Barton - 30 Jun 2006 19:17 GMT

>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?

Signature

Marsh
MVP [MS Access]

Reply to this Message

Douglas J. Steele - 30 Jun 2006 19:12 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> 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?

Reply to this Message

Cyberwolf - 30 Jun 2006 19:21 GMT

THanks Doug,

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

Signature

James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

> 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
[quoted text clipped - 9 lines]
> > does not contain a matching record. What would be the equivalent in
> > Access2000?

Reply to this Message