Function Not Found

[4321z]

Hi,

I've made a database that incorportates the Date() function in serveral queries and vba coding and it all works fine on my machine. I copy the database over to someone else's machine and when they try and use it an error message keeps popping up saying the Date() function cannot be found. Which is strange as i thought this was a standard function.

Any ideas anybody?

 

[PHV]

Double check the references in the someone else's machine:
when in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[4321z]

Already checked the references, all seems fine

 

[PHV]

And does the DB compile properly ?
menu Debug -> Compile ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886