#Name?

[peterbowles]

I have a txt box on a form with the following code

=Date(), This use to work, But I have recently re-built my PC and now I get the following error #Name? is this to do with references?


Cheers

 

[Mile-O]

Have you checked your references yet? It looks like a reference problem.

 

[peterbowles]

I cant remember which ones need to be checked

 

[The_Doc_Man]

I cant remember which ones need to be checked

Doesn't matter, Access remembers.

Open a module (any module) for editing. Follow menu path

Tools >> References.

Look in the list for the dialog box. Any that were checked originally will still be checked in the list. Look for the ones that have (all caps) MISSING in front of them. For each one, uncheck and then re-check the boxes. When you do that, a part of the dialog box will show you the name of the thing you are looking for as a file. The path might not be right, so the file will still be MISSING. However, I don't think the references box is modal, so you can click your START button and do a Find >> Files or Folders to search for a file of that name. Access might have moved it or someone might have done a non-standard install.

If it is not there, you need to re-install Office or Access (depending on what is missing.)

BTW, it is typical that a standard function like Date() will give you the problem even though the reference to the module containing the Date() entry point is probably OK. ANY module and ANY entry point can and will report an error when the address tables are screwed up. (I've gotta say that Bill Gates screwed the pooch on this design. Other systems screw up when things are missing, too, but at least they report the right error!)