Reddit reviews Avery Durable White Cover up ID Labels for Laser Printers, 1.25" x 1.75", Pack of 1600 (6576)
We found 2 Reddit comments about Avery Durable White Cover up ID Labels for Laser Printers, 1.25" x 1.75", Pack of 1600 (6576). Here are the top ones, ranked by their Reddit score.
SUPER DURABLE Heavy duty label material is waterproof and resistant to scuffing tearing and smudging. Extra-strong adhesive ensures Durable ID labels stay permanently attached.COVER UP LABEL TrueBlock material completely covers everything underneath, so you don’t have to remove old labels. Easy to re-label food jar labels or warning labels without any marks showing through.IDENTIFICATION LABELS Ideal for barcode labels, safety labels, bin labels, food labels, water bottle labels, asset tags, pallet racks, containers and anything else that needs to be permanently labeledHIGH QUALITY Excellent print quality and permanent adhesive material means heavy duty weather resistant labels will always look like new. Compatible with laser printers.FREE DESIGNS AND TEMPLATES Design and Print software with barcode generator makes it easy to add text, graphics, serialized numbers or barcodes in a few simple steps to your id stickers (avery.com/print).
I think that you're making it more complicated than it needs to be. You don't mention whether the equipment is already barcoded, what kind of barcodes you want to use, or what barcode scanning hardware you have.
Assuming that you'll need to create the barcode labels for the equipment, you can start with some inexpensive polyester laser labels like this:
https://www.amazon.com/Avery-Permanent-Durable-Labels-Printers/dp/B0000AQNK4
If you don't already have a barcode reader, there are plenty of basic USB models that are under $100. Your computer recognizes the reader as a standard keyboard, so anything you scan behaves as if you're typing the data in. Just do a search on Amazon. Laser scanners are easier to use than CCD scanners.
The next component you need is a barcode font. There are plenty available for free. Code39 is a common, flexible, and easy to use barcode. This page has a free one for download, along with instructions on how to use it:
https://www.barcodesinc.com/free-barcode-font/
From your description, I don't see any compelling reason why the barcode would need to contain the part and serial numbers. It would be much more straightforward to add a field to your database that would contain a unique 5 digit ID. You could create a template in Word to generate a few thousand labels starting with 10000 and going as high as you need it to.
From there you would have to decide whether to undertake the tedious task of labeling everything at once, or waiting until a piece of equipment is going to be used. If you take the latter approach, you would just stick a label on the piece of equipment, manually find its record in the database, and scan the label into the new ID field. From that point forward when that piece of equipment is used you'd just scan the label into a lookup box to immediately jump to that record. The form and lookup box can be created through wizards, so no VBA knowledge or use would be necessary.
https://www.amazon.com/Avery-Permanent-Durable-Labels-Printers/dp/B0000AQNK4
These are as durable as any non stamped metal vendor supplied product I've ever used. They have other sizes too, just look for permanent durable. As for incremental counter, you can do a fill down in a spreadsheet and use a code 128 font with the proper trigger characters leading and trailing.