#NAME? in field

H

Heather Fabries

Access 2003. I have a field in a form that should automatically show today's
date when I add a new record. It is set up as Date$() in the table the form
is drawing from. When I add a new record, I get #NAME? in the field until I
enter data into the form. Then it changes the date field to today's date.

I compared the setup to another database that is set up exactly the same
that is working correctly (it shows today's date when I add a new record).

What is even more bizarre is that I do not have this issue on my computer,
and the rest of the staff has the issue. We are pulling from the same
database.

Any ideas?

Heather Fabries
 
J

Jeff Boyce

Heather

Just a possibility...

Go to one of the PCs that is doing this.

Open the application and go to the Modules ... open any one of them.

Check the Tools | Relationships menu choices ... are any of the checked
relationships prefixed with MISSING?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return the current date in a field on a form 5
Auto Saving a Record in VBA 2
Insert Date into Field2, the first Time Field1 is Populated with Dataon Form 2
how to update all fields in table in one go? 2
Carry over date from previous record 1
=Date() Not working - help ? 1
auto enter the date in a form 4
Access Property sheet data missing also syntax 0

Top