• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 391
  • Last Modified:

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?
0
DAPAA
Asked:
DAPAA
1 Solution
 
david251Commented:
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)
    Application.CommandBars(strToolbarName).Controls(intToolbarButtonIndex).Execute
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.

-David251
0
 
DAPAAAuthor Commented:
David,
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,
Don
0
 
david251Commented:
Have you tried using a mail merge file in word instead of Avery?

-David251
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
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
0
 
shanesuebsahakarnCommented:
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.
0
 
DAPAAAuthor Commented:
This question is being withdrawn.  the client is using a standard printer with flat label stock.  

Thanks for all who replied.
0
 
Steve BinkCommented:
DOH!  That's supposed to be PAQ/Refund.  
0
 
moduloCommented:
PAQed with points refunded (500)

modulo
Community Support Moderator
0
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.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now