Inserting Page Code in a Report's Page

[Guest]

Hi,

I am designing a report it will show the monthly statement for a customer
the spec's are:

1- On Each Page of the statement report the client wants to implement the
barcode vertically to the left of each page.

2- The barcode is string of concatenated data contains: user type, userID,
statement No, Page Number

3- the Barcode is going to be an image on the statement


The Problem is Access does not allow the content of image control in a page
to be modified before formatting the page.

I have created a VBA program obtain all the data in the barcode string but
the problem appears with obtaining the Page No and attached to the barcode,
even I have managed to obtain programmatically ... but I still can not change
the image control to get the barcode for each page before Access formats it.

If any body has a Solution please Help


Thanks

 

[Sylvain L.]

Don't know about the image control but the last time that I wanted to make a
sophisticated printout on an Access report, I used the OnFormat and the
OnPrint event of the Detail section and not the OnPrint event of the form.

Another possibility would be to use a bound object frame control instead of
the picture control; however, I don't know how well this would integrate
with your current procedure. There is also the DBPix control from Anmara
that maybe would be useful for you.