Project or Library Missing Error Message

[mincefish]

Some folks in my office have just had new PCs, which are running windows 2000, with Access 97 professional installed (that is what the rest of the office are using). When they open the database up, one of the first calls is

format(dteDate, "DD-MMM-YY")

VBA highlights

format

and comes up with an error message saying "Project or Library not found", and the code goes into debug mode. I'm assuming that they are missing a .dll, but I'm damned if I can work out what it is.
Basically what I want to know is- what is this .dll?!

 

[Databaseguy]

Go into the VBE in a module, go to tools/references and uncheck any library that has "missing" next to it. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[Guest_imported]

Make sure Comctl32.ocx and Mscomctl.ocx are in the C:\Windows\System directory, then check the "Microsoft Windows Common Controls" 5 and 6 options are checked in Tools/References on the toolbar in a module. I had the same problem when building a database for my company. I found I had these files, then when distributed and users started to use it they got the "Project or Library Missing" error. I copied these files from my computer and inserted to the aforementioned directory on their computers and the problem rectified itself. Hope this helps.