[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