Change Mediatype With Vba

Legacy Poster

• 2012年07月12日 13:56

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

0

• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2012年07月12日 15:34
  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2012年07月13日 06:33
  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
• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2012年07月13日 09:51
  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.

  0

請登入寫評論。