If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inserting Page Code in a Report's Page
Hi,
I am designing a report it will show the monthly statement for a customer the spec's a 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 |
#2
|
|||
|
|||
Inserting Page Code in a Report's Page
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. -- Sylvain Lafontaine, ing. "Zaff" wrote in message ... Hi, I am designing a report it will show the monthly statement for a customer the spec's a 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 |
Thread Tools | |
Display Modes | |
|
|