Split database error message "Function name that Microsoft Access can't find"

[RogerD]

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!

[ranman256]

that is a false error, because you know Now is a legal function...
when that happens its usu ALWAYS a bad reference:
in vbe (alt-F11), menu, tools, references,
in the checked list, there is a MISSING item. Uncheck that one and find the version that does exist.

date math is done with:
DAteAdd("d",#,date)
and
DateDiff()

[Gina Maylone]

Hi! Do you really want the entry date to include the time too? now() will give you that (3/30/2018 7:54:03 AM)

HTH

[RogerD]

Ranman256
Thanks for the quick response
When I do Alt F11, references comes up. Checked items are:
VBA for applications
MS Access 15.0 Object Library
OLE Automation
MS ActiveX Data Objects 2.1 Library
MSO 15.0Access Database engine OBject
MS ViBA for App
We are still using the original db, and I had already checked this, but both split and original database are the same.
Gina Malone
thanks for the quick response, yes, we do want and are/were receiving as per your response.

[RogerD]

Ranman256
OK I was checking the FE of the split db.
when I checked the BE of the split db, I found 3 unchecked items.
I checked them, will now reboot my pc, (didn't work when I tried without rebooting) and see what happens!
thanks

[RogerD]

this did not resolve the issue.
Unsure where to go now!?

[RogerD]

I restored from 3/28 and it is working properly. What could have happened to the database to cause it to quit working on 3/30 when it worked perfectly on 3/29?