Need advice/help in preparing a report
I am working on a project. I want to print out idcards for staff from my VB6 program. I want my report to have 2 columns with 4 idcards each for the columns making 8 idcards of different staff on a page. I have tries Datareport in vb6 to no avail, i was only able to display a single photo on the report.
1. What reporting tool can I use to get this type of report
2. How do I go about using this report
I am working on VB6 as my front end and Ms-Access as my back end. I dont want to use Access report.
Please prompt reply will be highly appreciated.
Thanks
Re: Need advice/help in preparing a report
We print images and labels by simply using the PRINTER object - gives you a very fine control over X/Y placement of text and images...
Re: Need advice/help in preparing a report
But, How?
Can you provide an example?
Re: Need advice/help in preparing a report
Moved to reporting section.
Re: Need advice/help in preparing a report
I do this to print a barcode label on a DYMO label writer:
VB Code:
Printer.Orientation = vbPRORLandscape
Printer.Font = "Code39XS"
Printer.FontBold = False
Printer.FontSize = 18
Printer.Print "*" & strDate & "*"
Printer.CurrentY = Printer.CurrentY + 180
Printer.Print "*"; strMasId & "#" & strProcessor & "*"
Printer.CurrentY = Printer.CurrentY + 180
Printer.Font = "Courier new"
Printer.FontSize = 8
Printer.Print strName
Printer.EndDoc
We print pictures like this:
VB Code:
Dim picOut As IPictureDisp
Dim imgResizeW As Double, imgResizeH As Double
Set picOut = LoadPicture(strPicFile)
Printer.PaintPicture picOut, prtItems(i, 2), prtItems(i, 3), imgResizeW, imgResizeH
' the arguments are picture, x, y, width, height - last two are optional