=date() function not working

[robbydogg]

Hello,

I have created a database which multiple users are logged into and it works fine. Apart from 1 user.
Because of the way the system works, it requires a filed to be populate with a date.
This is automatically done using the =DATE() function.

This user has the message ?name in the box so obviously the function is not working, but does on everyone elses pc. I presume this is because the IT department didn;t set the pc up the same as all the other users, although we are all on the same version (2003)

Does anyone have any ideas as to wether it is part of teh installation or it can be switched to working?

thanks

 

[boblarson]

What it sounds like is that you have a field, or procedure, somewhere in the database which is therefore conflicting. Also, make sure your control name is not named DATE.

 

[ChrisO]

There is also the possibility that there is a file that the IT department did not install on that particular PC.

That could cause a Missing reference which can cause problems with functions like Date() and others.

 

[robbydogg]

Hi,
thanks for your help. I have double checked and there's nothign which conflicts on the database.
I also notice that i have a module which opens up a calendar function (which is the same as supplied on this forum) which doesn't do anything.

Researching on this, it seems that there's a reference which hasn;t been installed / checked but i have mirrored all the options checked on my machine and still no luck.

Could it be another setting which hasn't been selected doy ou think?

 

[robbydogg]

somehow i fixed it.
i deleted the textbox which was causing the problem. created a new one in exactly the same way as before - and hey presto - it worked.

not sure why it would make a difference, because it is exactly the same, but i suppose this is the wonderful world of illogical logics.

 

[missinglinq]

When you delete a control that doesn't work properly, then re-create it to find that it does work properly, chances are the original control was corrupted.

Corruption, like Dr. Lao, has many faces!

Glad you got it working!

Linq ;0)>