Printable View
Im developing Point of Sale application. In that i want to print barcode tags for inventory items. for an example if i have 12 items under item code 10001 and 12 items under item code 10002 both 24 item should be included in the report. can anyone explain me how to do this please
BarCodes are nothing more then a font applied to a textbox control. So when you bind your numbers to the textbox it will be viewable in a barcode format. ;)
For the report you would need your db table and recors in it. Then create a query to select the transaction id and its related records for the purchase.
I know about barcodes buddy. but i wanted to know how to retriew all 24 items..when i tried only 2 barcode appeared releating to the product 10001 and 10002!!!!!
Well you didnt give any info on your db structure and related tables so until then I cant be more specific. ;)
Also, how are you connecting to your db via your report (ADO, ODBC, etc) and how are you viewing you report (VB6, VB.NET, ???)?
First Thanks, for the respond.....
Let me tell you about the table structure.
I retrive data from just one table called stock which contains item_code, price, description, quantity. Item code is the one which i'll be needing barcode. but thats not the problem. I want to print inventory tags which will be attached to garment. So i need to print the tags according to the quantity in the inventory for each item. also i want to print them in a A4 sheet. I guess each A4 sheet shoud at least contain 4 columns. furthermore im using ODBC with SQL SERVER
So basically your sql query will be calling the stock table and retrieving the quantity. This quantity will be the number of barcode prints.
You may be able to write your query so it takes the inventory quantity and dynamically create multiple records for whatever quantity. It would probably be a self join but I'm not 100% sure I know how to write that part.