PDA

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