Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing a series of labels in Label MAtrix

Status
Not open for further replies.

jasonmac

Programmer
Nov 14, 2002
175
US
Hi everyone.
I created a label that accesses a query in a microsoft access database. The label brings in the job number and part number from access. I have also created a counter (in label matrix) in order to trace carton numbers. I have the database connection set to "keyed access" and the key is entered by the user at print time. Here's my question.
After the user selects the number of labels and enters the job number to be printed he/she has to click on the "Print labels" button once for each label. That means if I was to print 20 labels I have to click 20 times! How can I get around this???
Thanks in advance,
Jason
 
There are a couple of ways to accomplish this.
1. Is to have Access print an ASCII text file with the pertinent info. and Label matrix is in command mode reading the file. It also allows you to do it in Access and the labels just start printing out No human intervention required at all.
Access can keep track of the Serial number for you too. So you don't have to key that in either.

Email me direct if you need more info
dposton@barcodeone.com
DougP, MCP
 
Thanks DougP I got around the multiple clicking. My problem now has to do with selecting my part number at print time. Label Matrix pulls all the part numbers contained within my query into a list box. then I have the option to scroll through the list and select an individual part number or enter the number into a text box and click on the seek button. When performing the latter, Label matrix does not recognize several of my part numbers. I I scroll to these part numbers everything works fine. When I search for them, however, I am told they are not in the list. I have a suspicion that this has to do with the data type assigned to my part numbers by label matrix. Some typical part numbers are: 01123; 1-232978; 1-48239-M.
These should all be considered text. Do you know what is going on?

Keep in mind that I am using an old version of label matrix for Windows. v4.8
Thanks in advance
Jason

 
try re-linking to the datasource
If you made a change to the data Label Martix does not automatically see the change.
This is done by double clicking or right click (not sure which) on the label in design view.

Then look for database or datasource tab
Answer each question again double checking it.

Also you can call them if you have a legal copy.

888-629-4444
Strandware and Teklynx merged BTW
DougP, MCP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top