#name? error is driving me insane

[Nibblet8]

In our office we have 5 users running a database off the server. This database has been up and running for approx. 2 years. However, I have just started with the company and have been asked to make some changes, so I did. BUT.... since I have made my minor additions and cosmetic changes there have been strange happenings. For example, on everyone else's systems where there used to be a subform showing a customers address it now shows only #name? Also, I have added a Date & Time formula to the main form, and again on everyone elses system they see #name?
I looked around in the FAQ section and saw something I thought was helpful (faq181-107), but it says to go to a module in design view and select Tools, References and make the changes. However... There are no modules in this database. What do I do!! Please help me.

Nibblet8

 

[cmmrfrds]

Do you have a back end / front end set up. That is, the forms are in one mdb and the tables are in another mdb and these tables are linked to the first mdb.

 

[Newposter]

I think you "broke" the reference between the table and the form field, which is what cmmfrds is getting at. Check the data source of the form field, be sure that the location and the name of the field exactly match that of the table field. You may have to refresh the connection. Under Tools and Database Utilities, use the Linked Table Manager to verify this.
Also, I found that form and table field names sometimes don't tolerate blank spaces, so you have to include a hyphen or underscore in the name to make the code work.

 

[WildHare]

If you changed any table or field names, the #NAME guy will pop up on all the forms and querys that used to refer to the old guys.

Yeah, I hate that too.. try something like SpeedFerret to do your cleanups. There was a thread about this a few weeks back here...

Your users see #NAME for your new date & time guy because their databases don't know about the new fields. You may need to refresh links, if that's the case.

Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:

http://www.forumco.com/jmhare

More Neat Access stuff at

http://www.jmhare.com/wildhare2.htm