I have an access database that I split this week. It was working perfectly until this morning. When I opened the database and attempted to update incoming raw materials, I received an error message. "The expression you entered has a function name that Microsoft Access can't find." The error is caused by the default value for Entry Date=now(). This is in the table for all incoming raw materials. The last record in the table is blank except for where the default date/time should be, but instead has the value #NAME.
Purpose is, when a user enters a vendor release into the database, the entry date and time are entered for tracking purposes. Format=General Date, Default Value= now()
I have restarted my computer, compacted and repaired the db, opened the table from the BE to check it out. It works OK when opening the table only from the BE, but when opening the database from the FE, it doesn't work.
We also have a query that filters the information from the table to show the user only the data that is scheduled to arrive with a value =now()-2. That query is also not working. If I remove the qualifier =now()-2, the query works fine.
If I remove the default value from the table =now(), the table works fine
We were going live on Monday 4/2, but until this can be resolved, we will delay.
thanks in advance for your help!