gcgcit
asked on
Unknown Date Function
I have a field in my database called "ActionDate", in the design of the table the default value I have set to "Date()" - I want the field to automatically populate with todays date when a record is created.
Words great on my computer but when I try to run the application on another computer in the office it comes up with this error: "Unknown function 'Date' in validation expression or default value on "tblActions.ActionDate"
What is the better way to assign today's date to a field upon record creation to avoid this issue?
Words great on my computer but when I try to run the application on another computer in the office it comes up with this error: "Unknown function 'Date' in validation expression or default value on "tblActions.ActionDate"
What is the better way to assign today's date to a field upon record creation to avoid this issue?
You need to go to menu References and resolve any reference marked MISSING.
/gustav
/gustav
ASKER
Actually, just spoke with tester when I went to check the references on their machine and it's when they are trying to access the software through Citrix not straight through their machine. All our machines seem fine.
What reference would hold the "Date" function? So I can get the Citrix administrator to look into it.
What reference would hold the "Date" function? So I can get the Citrix administrator to look into it.
None. But that's the sympthom. It's a classic.
/gustav
/gustav
ASKER
I just got the administrator to open access in Citrix. See attached photos for the references.
What should I do?
ee-references.jpg
What should I do?
ee-references.jpg
What version of Access?
All updates installed (Office, Widows, Citrix...)
I am running two db's over Citrix and have not had issues with this error...
<just spoke with tester when I went to check the references on their machine and...>
And..., It is still not clear if any were marked "MISSING"
All updates installed (Office, Widows, Citrix...)
I am running two db's over Citrix and have not had issues with this error...
<just spoke with tester when I went to check the references on their machine and...>
And..., It is still not clear if any were marked "MISSING"
never mind, you posted the References just now...
That seems OK.
Then remove one, press OK, add it back, press OK. That should do it.
/gustav
Then remove one, press OK, add it back, press OK. That should do it.
/gustav
ASKER
which reference should i remove and add back in?
Anyone except the two top references which are non-removable.
It is just to "stirr the pot" ...
/gustav
It is just to "stirr the pot" ...
/gustav
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In the end it wasn't a reference issue. I replaced default values at table level with form before insert as per DatabaseMX's suggestion and voila - it works now on citrix!
Thank you for the additional information on the hazards of table level default values etc.
Thank you for the additional information on the hazards of table level default values etc.
You are welcome ...
mx
mx
Please go to the VB Editor, and select Tools|References from the menu. Are any listed as missing?
The Date() function is standard; when you see that error with a standard function, it is often a symptom of a broken reference.
Patrick