User-Defined type not defined

  • Thread starter Thread starter cinnie
  • Start date Start date
C

cinnie

hello

I use ACCESS 2000. I'd like to run the following code borrowed from one of
the Access user sites, but compiling fails at the Dim statement.
("User-defined type not defined")

Private Sub ListAvailPrinters()
Dim prn As Printer
For Each prn In Application.Printers
Debug.Print prn.DeviceName & " on " & prn.Port
Next prn
End Sub

I suspect a Reference Library is not installed, but I'm not sure which one I
need. I currently have the following Reference Libraries:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsof DAO 3.6 Object Library
OLE Automation

Any suggestions?
Much thanks
 
That may be a much easier solution! I've never used it, but from what a
gather the PrtDevMode functions are quite a pain...

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)
 
hi Cinnie,

I use ACCESS 2000. I'd like to run the following code borrowed from one of
the Access user sites, but compiling fails at the Dim statement.
("User-defined type not defined")

Dim prn As Printer

I suspect a Reference Library is not installed, but I'm not sure which one I
need.
Click to expand...
No, your doomed. Oops, too theatrically.)

The Printer object was introduced to Access 2002, so it is not available
in Access 2000.

So the question is: What exactly do you like to do?



mfG
--> stefan <--
 
Stefan Hoffmann said:
hi Cinnie,


No, your doomed. Oops, too theatrically.)

The Printer object was introduced to Access 2002, so it is not available
in Access 2000.

So the question is: What exactly do you like to do?



mfG
--> stefan <--
Click to expand...


Hello mfG
I am experiencing the same problem with a Dim statement for a new ADODB
connection
I am using Access 2002
Please see my thread called
"adding to table from drop down box"
Any thoughts?
 
Hi Stefan. I'm actually not trying to do anything other than familiarize
myself with VBA. Thanks for the advice.
 
Back
Top