help me or I am doomed

Hi there, I need some help with some difficult(for me, may be easy for u) formatting for printing. I have a database of employees with fields like name, age, sex, address, city etc. each record is linked to the photo of that person which is stored in a different directory. Now I have to use this data along with photo to print I-cards such that on each A4 size paper (landscape(lateral)) we are able to print 4 I-cards. please reply as fast as u can. Please see attached file and u will understand better. this is dead urgent. no jokes intended.

Are you using an Access database,

If yes then the following is a quick solution..

Create a table (tblRptIdCards) with the relevent fields.


Use the New Report option and the Label Wizard.

Select customise label. Put in the dimensions of your Id card ie 4 per page.

Go through the rest of the steps. Do not include the photo field.

When wizard has finished go to design of new report, add an unbound picture box.

In Print_Detail event for report load relevent picture.


The above just came of the top of my head, but it should work (in principle at least). if you need more details re-post.

If your data is in a non Access Db then create an Access Db, create a linked table to your source and away you go.