missing date and time after converting

[David]

Hello All,

I made a database using Access 2003, all the querys and reports worked
fine (on home computer) showing all the information drawn from the query
and dates and times using built in functions. I converted the database
to Access 97 and tried previewing a report (on work computer thin client
setup) and everything shows with the exception of the date and time
which is a very important part of the report. Is there something I'm
missing?

Thanks,
David

 

[Joseph Meehan]

Hello All,

I made a database using Access 2003, all the querys and reports worked
fine (on home computer) showing all the information drawn from the
query and dates and times using built in functions. I converted the
database to Access 97 and tried previewing a report (on work computer
thin client setup) and everything shows with the exception of the
date and time which is a very important part of the report. Is there
something I'm missing?

Thanks,
David

Compare the setting for "Date" in the "Regional Settings" found in the
Control Panel. I suspect you will find a different setting. like sort date
on your home computer and long date on your office computer. You can change
the date style or maybe just increase the size of the control on the report
displaying the date.

 

[Van T. Dinh]

Did you make sure that you are not using any new features / functions that
were introduced in Access2000 or later and not available in Access97.

 

[Tom Wickerath]

In addition to Van's answer, have you checked the target computer for any references marked as
MISSING?

Access Reference Problems (Doug Steele)
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Solving Problems with Library References (Allen Browne)
http://members.iinet.net.au/~allenbrowne/ser-38.html


Tom
_________________________________


Did you make sure that you are not using any new features / functions that
were introduced in Access2000 or later and not available in Access97.

--
HTH
Van T. Dinh
MVP (Access)

_________________________________


Hello All,

I made a database using Access 2003, all the querys and reports worked fine (on home computer)
showing all the information drawn from the query and dates and times using built in functions. I
converted the database to Access 97 and tried previewing a report (on work computer thin client
setup) and everything shows with the exception of the date and time which is a very important
part of the report. Is there something I'm missing?

Thanks,
David