Rocky Smolin
rockysmolin at bchacc.com
Tue Feb 15 10:34:09 CST 2011
-----Original Message----- From: Rocky Smolin [mailto:rockysmolin at bchacc.com] Sent: Tuesday, February 15, 2011 6:53 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Error 3709 The search key was not found in any record Jack: There is a memo field in that bound form. I'll forward to the client. If we can figure out how to duplicate the problem reliably (it's seemingly random at the moment) then I could delete all of the data in the memo fields and see if that solves it. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jack drawbridge Sent: Tuesday, February 15, 2011 5:27 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Error 3709 The search key was not found in any record Rocky, Haven't had the error, but did find this explanation via Google. May not apply but thought I'd send it on for review. http://support.microsoft.com/default.aspx?scid=kb;EN-US;302525 Jack On Tue, Feb 15, 2011 at 12:58 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > Dear List: > > Client gets this error: "Error 3709 The search key was not found in > any record" and the line of code triggering it is Me.Filter = strWhere. > strWhere has some valid filtering criteria. > > It seems to be random or at least not replicatable. Big variable is > that he's running an A2K3 mdb on A2K7 (boo!) and W7. > > Any clues? > > MTIA > > Rocky Smolin > > Beach Access Software > > 858-259-4334 > > Skype: rocky.smolin > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > www.bchacc.com <http://www.bchacc.com/> > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com