Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Wed Dec 31 17:04:14 CST 2008
Good to know I'm not losing my mind. (Access can do that to you.) Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, December 31, 2008 2:40 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Error 3709 The search key was not found in any record Rocky, I've run into oddness with the orderby stuff in the property sheet many times in 2003 and 2002 as well. In fact, I learned a long time ago to always clear the orderby and set it to off before I tried changing it, just as you're doing. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Wednesday, December 31, 2008 2:35 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Error 3709 The search key was not found in any record I found a workaround that doesn't make any sense. But here goes. I went into design view of the form and deleted the Order By stuff in the property sheet. Re-ran the form and this time it blew on the next line: Me.OrderByOn = True So I added two lines before those: Me.OrderBy = "" Me.OrderByOn = False Now it works. But that's a very dissatisfying solution. Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Wednesday, December 31, 2008 2:15 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Error 3709 The search key was not found in any record Dear List: I'm getting an error in A2007 which does not occur in A2003. It is Error 3709: The search key was not found in any record. It happens in a line of code reading Me.OrderBy = strSort, where strSort contains the fields by which to sort the recordset. I found one reference to this on the web which said it was due to a corrupted record but since it works in 2003 and not 2007 I don't think that's it. In any event I went through the make table solution but no luck. Has anyone seen this before and have a solution or an insight into the problem? MTIA Rocky Smolin Beach Access Software 858-259-4334 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com