Click to See Complete Forum and Search --> : Need advice/help in preparing a report
csKanna
May 30th, 2006, 08:07 PM
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
szlamany
May 30th, 2006, 08:08 PM
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...
csKanna
May 30th, 2006, 09:22 PM
But, How?
Can you provide an example?
Hack
May 31st, 2006, 06:02 AM
Moved to reporting section.
szlamany
May 31st, 2006, 08:51 AM
I do this to print a barcode label on a DYMO label writer:
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.EndDocWe print pictures like this:
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
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.