VBA code needed to Talk to Access about getting the paper size number it assigned to a Dymo label (paper size)
Posted on 2007-03-28
(It was suggest I ask in the VBA section.. this appears to be the closest to VBA for Access)
I'm using Access 2003. I have different reports printing on different printers. One of those printers is a DYMO 400. I do not want to specify a printer for the report as this MDE will be going to many workstations and the printers could be on differnt ports etc. I have found the solution and now need to "automate it"
I use the following to print to the printer currently:
set application.printer = application.printers("DYMO LableWriter 400")
stDocNam = "PrintLabel"
docmd.openreport stDocName, acViewPreview (yes i know i can ,, hidden)
.papersize = 143
.leftmargin = .233 * 1440
.itemsizeheight = 2.2083 x 1440
OK so here is what I need to automate. ... I only found out that the Paper size for the DYMO Printer 400 is 143 because I had to make another report, choose specific printer...(Dymo 400)... select the label size (Shipping 20256)... then open the report, go to Alt-F11, CTRL-G and typed ?reports("printlabel").printer.papersize
This now gives me what THIS machine has for the Dymo 400 20256 Shipping address label .
I want to have some kind of a script that would find out what number access has asigned to a Dymo Printer Page (but it's really a label...30256 shipping lable). Because this number changes on differnt machines depending on what numbers have already been used by other printers, I want to find it dynamically.
Again my number ...143.... would only be for my system but deploying a MDE to other stations with different configs my method won't work unless I can "talk" to Access and ask it what number represents for the Dymo 400 a shipping lable #30256.
(Prdev won't work in MDE's)
Thank-you in advance.