Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 375
  • 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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