I am newbie to Vb as well as Crystal reports. I am creating an Inventory System which uses barcode. I am using vb6.0 ,MS Access 2007 and Crystal Reports 2008.
What i need help on is i need to print Barcode stickers using crystal report. I have designed a report which contains Barcode as OLE object, a code and MRP price. I am not going to scan the barcode at this time, so its just static labels to stick on product. I am using a form to enter the data into the access like code and mrp price.
I want to save the data in access as temporary data, for printing purpose only.
In my VB form i am using three text boxes, 1. Code 2.MRP Price 3.Number of columns.
Number of columns in the sense, when i enter 13 in the number of columns the database should be updated as columns and should reflect in the report.
Code : 00125469
MRP Price : 500.00
No of Columns : 13
The report should display barcode with code and mrp 65 times(5*13=65)
The report is designed in such a way that it contains 5 rows(barcode,code,mrp)
When i hit the print button the data from the text boxes should be temporarily saved in Access file for printing, and report should be viewed.
Pls help me to make this happen,
Thanks in Advance.