#Name? ?!?! 2

[shar]

I have a form with 8 child tables, all 1 to many relationship to partent table.&nbsp;&nbsp;Three of the child tables have a date field with today's date as defualt.&nbsp;&nbsp;These dates fields are showing #Name? instead of today's date.&nbsp;&nbsp;I can enter today's date and the form accepts it, but it does not show it as defualt.<br><br>Anyone has any idea why this is happening?

 

[rhicks]

You more than likely have a &quot;Library Reference&quot; problem on the machine giving you the error.<br>On the problem machine open a module in design view, click the Tools button in Access main tool bar, then choose References. In the References list you will see a checked reference that has &quot;Missing&quot; message attached to it. This is the one causing the error. Uncheck the culprit and the problem should be cleared up.<br><br>Most of the time the problem originates from the machine where the Access app is written on. I have found this is commonly caused by someone using non-standard activeX controls and other components that are not basic to Access. If you play with an activeX component then even if you delete it from your application the library reference will still be loaded in the current app unless you uncheck the reference. Thus when you install the app on another machine the result will be a library reference error. Unless you are doing something exotic there normally should be only three references checked. For Access 97 these are: <br><br>Visual Basic For Applications<br>Microsoft Access 8.0 Object Library<br>Microsoft DAO 3.51 Object Library (version can vary) <br><br>If you are doing some things with Excel through Access you will also have an Excel Library check also. If you have others checked they can very well cause a problem if the other machines do not have the libraries registered on them. I hope I have explained this clearly enough. I too have encountered this problem in the past.<br><br>Good Luck<br>RDH<br> <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[elizabeth]

Ricky, this question gets asked frequently. Maybe you'd like to write a FAQ for the FAQ page? There is already a category called &quot;version or Conversion related&quot; which I <i>think</i> this would belong under. Next time someone asks we can point them to the FAQ instead of rewriting the whole thing, and you might win dinner for 2!

 

[shar]

Ricky,<br><br>The culprit was calendar controls with different versions.&nbsp;&nbsp;The app was created on a machine with Calendar Control 8.0 and the troubled PC had Calendar Control 9.0 on it.&nbsp;&nbsp;After I went back to 8.0, then the Date() function worked fine.<br><br>Thanks for the guidance.<br><br>shar

 

[Guest_imported]

Thanks very much for showing me why the previously functioning refence to current date was delivering the <br>&quot;Name?&quot; error (after migration/conversion from 97 to 2000) without my being able to figure why!