[AccessD] Query difference between Access 97 and 2002

Jim Dettman jimdettman at earthlink.net
Tue Aug 9 14:21:16 CDT 2005


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





More information about the AccessD mailing list