lost functions Date() and Format$

U

Ulf Aberg

Hi,

I am trying to transfer an access 2000 database from a pc
running Windows 98SE to another one running Windows ME. I
removed office 2000 pro from the old machine and installed
it on the new one and copied the database straight over by
burning a cd. However, many things just stopped working. I
managed to get the charts in reports going by using office
update (OLE server problem), but I still get an error
message every time I try to run a query, form or report
containing the functions Date(), Format or Format$. The
very majority of my queries and reports use those
functions!

I have manually fixed some of them by replacing every
instance of Date() with Now() or DateValue(Now()), but
haven't found even a manual solution to the format error.

Grateful for any help!
Ulf Aberg
 
G

Guest

Many thanks Allen, this solved my problem! In fact it was
the old Compaq machine who had registered some hard button
stuff as a reference. I just deselected that reference and
it works again! Now I just need to tell Access that Format$
is not a parameter by removing the aquare brackets it added ...
Ulf Aberg
 
Top