Date missing when using a runtime version of my Database

[CarysW]

I have packaged my DB so it can be used on any computer in the company. I have then tested it on a few computers. It works fine on two but on one of them my main switchboard form does not pick up the autodate. Is this an issue with the DB or with the computer?

It's running XP Professional.

 

[RossWindows]

If you're referring to the Date() function;
Does it work when you use the Now() function? or vis-versa?

 

[CarysW]

If you're referring to the Date() function;
Does it work when you use the Now() function? or vis-versa?

It is the Date() function. I use the Now() function for the time to get a 'real-time' clock and this does work. Could this be the problem and why is it happening?

 

[namliam]

missing reference most likely... Search for "missing reference" on the forum and see if that will help you fix your problem.

 

[RossWindows]

Make sure you have not declared any variables or named any Fields "Date"
"Date" is a reserved word.

If all else fails, use something like:

MyDate = Format(Now(),"mm/dd/yyyy")
'or whatever format you need your date to be

 

[CarysW]

Make sure you have not declared any variables or named any Fields "Date"
"Date" is a reserved word.

If all else fails, use something like:

MyDate = Format(Now(),"mm/dd/yyyy")
'or whatever format you need your date to be

As I said it works on every other computer I've tried - it's just this one. I now have the problem that i'm unable to get back into my form to edit it.....I can't open it in Design View(see my other post:http://www.access-programmers.co.uk/forums/showthread.php?t=179659 )

 

[gemma-the-husky]

based on other posts about similar functions going missing (left/right etc)- this seems to be connected to outlook not being installed on the target computer. Is that the case?


maybe not quite that - outloook seems to install a common dll that access uses - so if that dll isnt there, then access has to find the functions in another dll, and its probably just a matter of refreshing the references, or changing the priority of the references. there was a thread a couple of days ago with this explanation in respect of left() and right() suddenly being not recognised, and i thought maybe this was similar.

 

[RossWindows]

That's rediculous Microsoft! j/k

 

[namliam]

based on other posts about similar functions going missing (left/right etc)- this seems to be connected to outlook not being installed on the target computer. Is that the case?


maybe not quite that - outloook seems to install a common dll that access uses - so if that dll isnt there, then access has to find the functions in another dll, and its probably just a matter of refreshing the references, or changing the priority of the references. there was a thread a couple of days ago with this explanation in respect of left() and right() suddenly being not recognised, and i thought maybe this was similar.

At the risk of repeating my self

missing reference most likely... Search for "missing reference" on the forum and see if that will help you fix your problem.

So let me repeat myself

missing reference most likely... Search for "missing reference" on the forum and see if that will help you fix your problem.

Let me put it differently, if it works on one machine not on another. AND you know some MS app is missing one the ones where it is failing AND it is failing on "common" functions like Date, Left, Right etc. Then IT IS a missing reference

So once more...

missing reference most likely... Search for "missing reference" on the forum and see if that will help you fix your problem.