lost functions Date() and Format$

  • Thread starter Thread starter Ulf Aberg
  • Start date Start date
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
 
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
 
Back
Top