[AccessD] Query difference between Access 97 and 2002

Thanks, Jim.... That was part of my problem.  The query is still not working
in Access 2002 --- it's an append query to a table in another database.  I
need to investigate some more!  .....Thanks, Barb



----- Original Message ----- 
From: "Jim Dettman" <jimdettman at earthlink.net>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, August 09, 2005 3:21 PM
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