Change Mediatype With Vba 追蹤

0
Avatar
Legacy Poster

Hi,

i have a problem with my Access. I would print a label from an Access Form.
My problem is that the paper, I print on Label paper which is much thicker then normal paper, so I must change the mediatype. Does anyone know how can I set the mediatype in VBA to the label?

I hope someone can help me

3 意見

0
Avatar
Ian Cummings
版主
評論操作 永久連結

Unfortunately, we don't support the manipulation of printing preferences via the automation interface. It is in our wish list, and has been asked for a number of times, but as yet this has not been implemented.

As a workaround I suggest you have two, near identical label formats with the only difference being in the print settings. Then you can have your VBA application open the appropriate label file depending on what label media is loaded into the printer. Not a pretty solution by comparison, but it will work and give the user the same experience.
0
Avatar
Legacy Poster
評論操作 永久連結

The problem is that I have 2 difference printer with the same labels. I have to change the mediatype at the first printer to label and on the other printer to label (thick). So the printer tell me everytime I should take in the label paper when I will the label (thick) paper. When I make different layouts, I must change over 200 layouts. Thats not what I want.
0
Avatar
Ian Cummings
版主
評論操作 永久連結

Unfortunately that is how it is at the moment until such time as we support the manipulation of printing preferences via automation.

Another workaround option is to enable the "Share settings between all documents" in the printer driver properties. This will tell BarTender to ignore the label format embedded print settings and instead use the default settings of the printer driver. This option is found in the driver properties, under the "Tools" tab, click the "Driver Options" button and then select the "Network Settings" tab. The idea here is that you create a few different instances of printers using the same driver pointing to the same physical printer. In each instance you would configure the different print settings as default and enable the "Share settings between all documents" option. In this way, having your label format print in the way that you want, is just a matter of selecting the appropriate printer instance. Of course this means that you will have more printer instanced than you had before (number of printers x variations in print settings), but if the number of printers isn't that great it might be a more manageable solution.

登入寫評論。