Hi,
I have an Access 2000 database that contains a module that converts numbers into text (i.e. 123 = one two three). When I import this module into another database, it refuses to work. I get #NAME?. I have beat my head against the wall trying to figure out why and to no avail.

I have also just noticed that when I insert today's date into a report I also get #Name?. It has occured to me that maybe my Ofc. 2k install is fubared but at this point I just don't know.

I can live without the date but I really need this module to work.

Appreciate any help.

Thanks

Open the module in the new database, go to Tools, References and check to see if any references are missing. Compare the references in the old db and the new db.

Thanks a million fuzzygeek. The ccrp date picker control was missing. I added it and that fixed the problem. I don't have a clue what the date picker had to do with this particular module but I can live with that as long as it works.

Thanks again. :)