Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old May 9th, 2005, 06:14 AM
Authorized User
Join Date: Jan 2005
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Find and noMatch ADO

Can someone tell me how to implement find methods containing nomatch in ADO. your ideas would be very helpful for me.

Old May 9th, 2005, 03:01 PM
Friend of Wrox
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts

They are implemented exactly as in DAO.

You invoke the .Find method of a recordset (I believe only one condition can be specified), and if the record is not found, .NoMatch will be True, as will .EOF.

Is this not how it is working for you?
What Access behavior has brought you to ask this question?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Find Method of ADO martinaccess Access 3 November 21st, 2007 07:35 AM
.NoMatch ggiibboo Access 8 January 23rd, 2006 11:34 PM
Using .Find with ADO phi kyo VB Databases Basics 2 January 16th, 2006 07:11 AM
ADO Find using wildcard on an integer dfbosse VB How-To 2 June 26th, 2003 02:14 AM
ADO could ADO counot find the specified provider. Rob Collie Classic ASP Databases 2 June 9th, 2003 04:12 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.