lost functions Date() and Format$

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

References problem:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ulf Aberg" wrote in message
...

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


-----Original Message-----
References problem:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Ulf Aberg" wrote in
message
...

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


.