Print label from VBA to Avery 9100 label printer

I have an Avery 9100 lable printer.  I can print to it by linking to a table with the data that is needed on the label then clicking the print icon on the avery tool bar.  I need to print to it using the on click event of a command button.  I have found some examples using labelpro but the printer came with designpro.
Has anyone done this?
Who is Participating?
moduloConnect With a Mentor Commented:
PAQed with points refunded (500)

Community Support Moderator
I have not used Avery before but if it is a standard toolbar you could try this code to simulate the button press
Sub subPressButton(strToolbarName As String, intToolbarButtonIndex As Integer)
End Sub

This is the usage:
subPressButton "Database",2

remember to substitue your avery toolbar name and the button index

If you need more info let me know.

DAPAAAuthor Commented:
Thanks for the suggestion but I want to create and send the label without using the avery toolbar.  The reasons for this is Avery, to my knowledge,  requires you link to the table each time a label is sent.  

I would be OK with an OCX or an API call but have been instructed to not use toolbar.

thanks for the reply,
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Have you tried using a mail merge file in word instead of Avery?

DAPAAAuthor Commented:
That is the example desing pro gives so i know it would work.  The issue with that is Access is the only product installed on the computers that will be running the application.

The client is OK with using a different low end label printer if you know of one that would print direct from VBA.

thanks again
I take it that the printer cannot handle standard documents being sent to it as if it was a normal printer? Most label printers I have seen can do this.
DAPAAAuthor Commented:
This question is being withdrawn.  the client is using a standard printer with flat label stock.  

Thanks for all who replied.
Steve BinkCommented:
DOH!  That's supposed to be PAQ/Refund.  
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.