Can't Open Reports

[Brian]

I have an Access database that I placed on the compnay
server. All of the users in my part of the building have
no problem accessing any of the reports, however, all of
the users in another area of the building get the error
box Enter Parameter Value - Format $ when trying to open
a report. Below is a response I received stating what
the problem might be but no info on how I might correct
it. Can somebody help with this? Thanks.

Brian

You have an external library reference problem. The
library exists (and is in the proper location) on the PCs
where the reports work. It is missing from the ones that
can't open the reports. BTW this will affect more than
reports. That's just the first place you've noticed it.

 

[Rick Brandt]

I have an Access database that I placed on the compnay
server. All of the users in my part of the building have
no problem accessing any of the reports, however, all of
the users in another area of the building get the error
box Enter Parameter Value - Format $ when trying to open
a report. Below is a response I received stating what
the problem might be but no info on how I might correct
it. Can somebody help with this? Thanks.

Brian

You have an external library reference problem. The
library exists (and is in the proper location) on the PCs
where the reports work. It is missing from the ones that
can't open the reports. BTW this will affect more than
reports. That's just the first place you've noticed it.

On a PC that exhibits the problem open a code module window and then go to Tools -
References. Of the listed references that are "checked" see if any have the word
"Missing" after them. In many cases these references can simply be removed to clear
up the problem. If by chance your application is using the reference then you will
get a compile error after clearing it. Sometimes you can then go back in and recheck
the reference and everything will start working.

If the app won't compile and you can't recheck the reference because when you go back
into Tools - References it is not listed among the choices, then that particular
library simply doesn't exist on that particular PC. You will need to install
whatever software provides and registers the library in question (or redesign your
app so the reference is not needed).

A good idea is to open a blank new file and check the references on that. This will
tell you what the core libraries are for your particular version of Access. In most
cases you won't need any others besides these unless you are using an alternate
object library (DAO instead of ADO) or are making use of non-native ActiveX controls
in your program.