Arthur Fuller
artful at rogers.com
Sat Aug 13 21:07:52 CDT 2005
You could also use a static function to put this problem in a nice little package and forget about it forever. Check the archives for my previous rants on static functions. If you can't find one, I'll send you the sample code off-list. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: August 9, 2005 4:32 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Query difference between Access 97 and 2002 In addition to Jin's suggestion, check the query parameter for that reference and make sure all the square brackets are in the right places. In 97 you could leave them out entirely or put them around a single element of the reference. In 2000 and later, the query engine will insert a pair of square brackets around the entire reference if any of the brackets around the individual elements were skipped. I've run into this repeatedly. Charlotte Foust -----Original Message----- From: Jim Dettman [mailto:jimdettman at earthlink.net] Sent: Tuesday, August 09, 2005 12:21 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Query difference between Access 97 and 2002 Barb, Make sure you explicitly type (text, date, integer) the data expected in the control (in query design, goto query/parameters). Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan Sent: Tuesday, August 09, 2005 3:20 PM To: Access List Subject: [AccessD] Query difference between Access 97 and 2002 I have converted an Access 97 application to Access 2002 (XP). A query that works in 97 will no longer work in XP. The field in the query causing the problem is referencing an unbound text box on an open form, i.e., the field name in the query is "PeriodEndDate:[Forms]![frmPerDiemEntry]![txtPeriodEndDate]". When I execute the query in 97, I see the contents of txtPeriodEndDate; however, in XP, it is blank/null. Any ideas? Thanks, Barb Ryan -- 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