Printer declaration not working

[Al]

I had this working in Access 2000 prior to my PC crashing. Now it errors
when it tries to declare objPrinter as printer (User-defined type not
defined). When I change the declaration to a String or to nothing, it passes
by the declaration and errors on the ActivePrinter part of "objPrinter =
ActivePrinter" (variable not defined)... Am I missing a Reference or what is
happening here?

Dim objPrinter As printer
Dim pdfDist As PdfDistiller
Const PDFENGINE_DISTILLER = 2

Set pdfDist = New PdfDistiller
objPrinter = ActivePrinter

Thanks in advance,
Al

 

[Brendan Reynolds]

You must have had a later version of Access prior to the crash. The Printer
object and Printers collection did not exist in Access 2000. They were new
in Access 2002. See the URL below ...

http://msdn.microsoft.com/library/d.../en-us/vbaac10/html/acconNewAccessObjects.asp

 

[Al]

That's interesting because I got it to work in Access 2000 again since I
posted this. I found an old copy of my original database with user-level
security on it. I was asked to remove the user-level security and after
transferring everything into a new db, I ran into the printer object problem.
I went back and found the references in my original db and started replacing
references one by one until I got the printer object to work. The reference
that enabled the print object was from my ArcGIS software named "Data
Dynamics ActiveReports" and the file name is ActRpt.dll.

Thank you for the information, I greatly appreciate your response.
Al