Charlotte Foust
cfoust at infostatsystems.com
Wed Dec 31 16:39:36 CST 2008
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