Using Default Date ()
Posted on 1998-09-03
I have a database used to track employee activity and enter their billing. All of a sudden people are having problems withdates in forms and tables. I have enter a default date in the table =Date() but all of a sudden it is only appearing on mine and another girls screen. So I went on the other's computers to try and fix it, I notice that their tables don't pick up the =Date() that I set as the default value in the table. I fixed it on their forms but then it appears as #Name? in the table, if I fix it in the table it appears as #Name? in the form. I also get the attached error message when I try and enter the default value in the default value of the date field on their computer. Time & Billing Synapse - The function you entered can't be used in this expression *You may have used a DoEvents, Lbound, Ubound, SPC, or Tab function in an expression
*You may have used a SQL aggregate function, such as Count, in a design grid or in a calculated control field.
Do you know what the message means, how can I fix this database?