MS Access and functions

[fredElliotRules]

Hello,

I have developed a MS Access database which uses several functions such as DateDiff and inStr. When I use these function on my machine the database runs fines and the values are calculated.

However the database I have developed is not for my computer and when run on this one computer produce some errors (The date function is mentioned). I believe this is some sort of security issue but I cannot be sure.

Both computers run the same version of Office. Does anyone have any ideas.

 

[KenHigg]

I don't think it could be a native Access function causing the problem (But I could be wrong). I would do a simple, new database with nothing in it but a routine to run each of the functions and try it on the suspect workstation and see if it errors. Make sense?

Edit: Or what Col suggested may work

 

[Rickster57]

Date

I have seen this on a client's computer. Only one of the computers was giving the Date error in a report. Turned out it was a missing reference.
Go into any of your vba code. Then go up to the menu and click on Tools>References. See if any are marked MISSING. If so, check that reference. Hopefully that is the issue.

OOps... didn't see the duplicate post.