Barcode Generation Pls help!!

[andyrohith]

Hai All,

I am trying to create a barcode generator in Access. The table contains Item number and the quantity.My main aim to print the barcode for the item number with respect to the quantitiy.Like if there is an item number=1234 and quantity is 5,so the barcode for 123 should be printed 5 times in the report.My idea was to write the items with respect to the quantity in another table and run report from that temporary table.If there is a more better way pls share with me.And iam new to Vb.

Thanks,

Andrew..

 

[Scooterbug]

Are you having problems getting the barcode to print?

Also, is there a reason why you need to barcode to display itself 5 times?

 

[andyrohith]

Hai,
I wanna print the barcode the number of times equal to the quantity cos we have to print the barcodes in a sticker sheet and stick it on the item rack.So it'll be helpfull during stock taking and also for inventory maintenance.

Thanx,

Andrew.....

 

[Scooterbug]

Hmmm...well, off the top of my head, I would use the temp table idea. Would you be doing one item at a time, or doing a batch of items?

I would open a recordset, grab the quantity and use that for a For Next loop to add the Item number to the temp table. A bit busy here at work right now...but give me a bit and I should be able to come up with an example later.

 

[HiTechCoach]

What you want to do is very simple. While you could create a temp table with all the records. you can do it all with a query.

Here is a working example:
Print Multiple Labels

Here is the SQL from the example:

SELECT Contacts.FirstName, Contacts.LastName, Contacts.Address, Contacts.City, Contacts.StateOrProvince, Contacts.PostalCode, Contacts.ContactID, tblLabelQuantity.LabelQuantity, Contacts.LabelQuantity
FROM Contacts, tblLabelQuantity
WHERE [b](((tblLabelQuantity.LabelQuantity)<=[Contacts].[LabelQuantity]))[/b]
ORDER BY Contacts.LastName, Contacts.ContactID, tblLabelQuantity.LabelQuantity;

Hope this helps ...