Missing hpqcc3.dll file

[mark909]

Ive been getting an error message popping up on my colleagues computers when
i try and run my database in them.

It occurs when i run a report which has been set up to open in print preview.

In the vba module ive selected tools--->references

I get the following missing reference:

MISSING: hpqcc3 1.0 Type Libary

The reference is obviously missing from my colleagues computers.

Ive narrowed down where it is found on mine and it relates to a printer that
my computer was once set up to which is no longer used and my colleagues
computers where never set up to it.

I think this has been selected as the default printer on my computer when
creating the print preview report.

I could try and copy the directory and hpqcc3.dll onto my colleagues
computers but id rather try and change the database at my end.

Any ideas? I fear if i delete the reference on my computer itll mess up my
database!!

 

[Tom van Stiphout]

On Thu, 23 Jul 2009 05:37:01 -0700, mark909

Remove the reference. Recompile the VBA code (code window > debug >
compile). If no complaints you have safely removed it.
Run the reports. If some ask for this printer, design the report, File

page setup > page > switch from 'use specific printer' to 'default

printer'.

-Tom.
Microsoft Access MVP