473,324 Members | 2,501 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Printing Labels - Specify Starting Position

2
Greetings,

I'm a Draftsman / IT at a thriving custom cabinet business. We use high dollar ($600 per 1000) labels (52 per sheet) as a means of keeping track of each piece of the cabinet during construction. Our database is set up to allow a user to pull up an order, generate the parts list, and then print the labels for that order. Unfortunately, not every order uses a complete sheet of labels. In fact, it is not uncommon for an order to have just one label, thus wasting 51 labels. Sure, we ask the shop to return as many sheets as possible with numerous labels remaining so that we can reuse these sheets. This is cumbersome and the sheets don't always come back in the best of shape to be laser printed again.

My question: Can the database be coded to allow the user to select the label position before the job prints? If so, sample code would be greatly appreciated. Also, is there a way to code the database to accumulate multiple label print jobs in some type of spooler and then later print the multiple job as one job??

Any ideas or suggestions... or am I dreaming :|
Nov 23 '06 #1
3 1974
ronverdonk
4,258 Expert 4TB
To start; the database has no programmable interface, it is just storage for data. Any programming handling the is done outside the database.

As you put it you don't even need a database for that. All you need to know (establishing that a sheet has 52 labels and the user always will use the first free label on a sheet) is the last used number in a (say) 13x4 matrix numberd 1 to 52. You can write that a a 'normal' flat file.

But some questions remain:
Why do you let the user choose the label number? Why not give the user the next label number in this system? Because, e.g. a user might not pick the first free label no 25, but 35.

You could 'spool' the print requests and store the print output in a file or database. But you'll need some user interaction to actually 'release' the spool and start the print.

If I talk gibberish, then I don't understand it and you'll have to explain a bit more.

Ronald :cool:
Nov 23 '06 #2
xnay
2
Thank you, Ronald, for your reply and better insight of the database. I recently came upon some code for an Access DB that pretty much did what I was looking for. It seemed that all one had to do was copy and paste his code somehow (I forget the details how) to an Access DB and a pop up box would appear before printing labels asking for a starting label position. I was hoping that something similar could be done with a MySQL DB. My reasoning behind this is to re-insert to the tray the label sheet from previous order and begin printing from the next available label on that sheet (instead of inserting a new sheet with every order). In this way, label waste is kept to a minimum. You mentioned that it's possible to 'spooI' the print requests to a file and then later realease the file for printing. In my opinion, this seems like a very nice way to get the desired result; that is, if after you released the file for printing, all of the print requests could be batched into one print request and print consecutive without having to start a new sheet with each job request spooled. If printing in this way is possible, please elaborate further. You're insight is very much appreciated.

And, BTW, You're not the one talking gibberish here, Ronald, my ignorance shows who really is :|
Nov 23 '06 #3
ronverdonk
4,258 Expert 4TB
Well, you can keep your data, such as the last label number, in a MySQL table.

But what I am curious about is the actual printing. What do you mean when you say "printing". Is that the process of actual putting the ink on the labels, or is that making some sort of print output file, that is stored on a stick and send to the printing dept. for the actual ink job.

And is this printing, as started by the user, done via a program on a PC?

You see, there are just more questions.

Ronald :cool:
Nov 23 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: r6uji7 | last post by:
hello, is it possible to print certain details on a fixed area of a paper using PHP? here's the scenario: i'm trying to print labels with names and addresses. the names and addresses are...
2
by: qumpus | last post by:
My program right now generates USPS style shipping label using System.Drawing.Graphics. It works fine except that the printer prints really slowly. I want to make my program take advantage of true...
2
by: DBQueen | last post by:
I have a database which will be printing out labels for SMALL test tubes (1/4" high). We have yet to find a reasonably-priced printer (labelwriter) which can effectively print this on ROLLS of...
3
by: Grim Reaper | last post by:
I print mailing labels out of Access 2000 databases about 3 to 4 times a week. I have been having problems with one thing since I have been printing mailing labels. I print mailing labels by...
4
by: Arif | last post by:
I C# code prints very slow as compared to a third party barcode printing software. That software prints approximately 10 labels in 2 seconds while my C# code prints 10 labels in 5 to 6 seconds. And...
5
by: Tom | last post by:
I am converting an old application that was printing directly to a specialized printer device (i.e. a special label printer). It was doing this by opening a file with the file path of 'LPT1:' and...
3
by: Mika M | last post by:
Hi all! I have made an application for printing simple barcode labels using PrintDocument object, and it's working fine. Barcode printer that I use is attached to the computer, and this...
5
by: micklee74 | last post by:
hi i have a list with contents like this alist = how can i "convert" this list into a dictionary such that dictionary = { '>QWER':'askfhs' , '>REWR' : 'sfsdf' , '>FGDG', 'sdfsdgffdgfdg' }
6
by: Ron | last post by:
Hi, I know Access allows for easy construction of a report setup to print labels from a table/query, etc. I've done that one. It works pretty well for what I need. However, is there an...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.