Just Updated PC NowGetting Error Help!!!

[hullstorage]

i have just upgraded pc and copied files from disc to new pc
installed office etc... but now i am getting error message

id automation error and a problem with my date() functions

i have changed date() to now() which seems to have got rid of error
but have lost date() function

any help please

thanks
simon

 

[pbaldy]

First thing that comes to mind is a reference problem:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html