Queries fromm ACC97 to ACCXP

[Grzegorz Rozanski]

I have many queries like 'select foms!form1!datestart as Expr1, ...' which
worked fine in access97. When I do the same in AccessXP I can see nothing in
field Expr1. Or sometimes I can see 'Chinese' characters.
The problem is only when 'foms!form1!datestart' is datetime data.
Why it doesn't work in AccXP?
When I try to add 'foms!form1!datestart' to parameters it works only when
its datatype is string.


Any suggestions welcome

Thanks, Grzesiek

 

[John Nurick]

Hi Grzegorz,

I guess the first thing to do is to check the date/time formats and
regional settings on your computer to ensure that the string values
being displayed on the form are acceptable as date values.

Also or alternatively, try using expressions like

CDate([Forms]![Form1]![datestart])

to explicitly convert the string in the textbox to a date-time value.

 

[xubf123]

I have many queries like 'select foms!form1!datestart as Expr1, ...' which
worked fine in access97. When I do the same in AccessXP I can see nothing in
field Expr1. Or sometimes I can see 'Chinese' characters.
The problem is only when 'foms!form1!datestart' is datetime data.
Why it doesn't work in AccXP?
When I try to add 'foms!form1!datestart' to parameters it works only when
its datatype is string.


Any suggestions welcome

Thanks, Grzesiek