Search results

Hi, Thank you vbaInet. After your help of looking at it another way I finally went back to my code and noticed that it was all working except when on printing giving me funny double/treble figures. I have finally worked out a coding error that was adding two values and not resetting the page...

Hi, Its all great except the "txtPgFootSum" which adds the page amount totals need to be adding the previous page totals also. Like a running sum of that page and previous page amounts. Other than that its great thanks. Regards, Jo

Hi, Does anyone have a simple way to sum an amount column in a text box within the report page footer and then in the next page (page2) have a text box in the page header that carries over the previous total (that is in the page footer of page 1)? Then on page 2 of the footer, the text box...

Ok to make things simple, does anyone have a simple way to sum an amount column in a text box within the report page footer and then in the next page (page2) have a text box in the page header that carries over the previous total (that is in the page footer of page 1)? Then on page 2 of the...

Not sure what you mean.?....! The db is quite large in itself and everything else works fine but basically this report is to print of a small piece of data and calculate each page and carried/bring forward amounts. The data is name, amount and date. I have gave you the VBA code behind the report...

Hi, No its a calculated field on the report. What I am trying to do is to get each printed page added up and then the amount brought forward and the page amounts to be added in the page footer and displayed and then that amount gets carried over to the bfAmount text box in the page header of the...

Hi, Thanks for the welcome and thanks for your reply. I have managed to get it working when in print preview its a treat but for some reason when I print the report off it keeps giving me huge figures instead of the ones that are actually shown in print preview?! Any ideas why? Here is the VBA...

Hi, I have created a report that does a running sum of the records per page and it limits the records to 31 per A4 page. The amounts per page is added up and displayed at the bottom of the page in [pgAmounts] the page footer and then carried over to [bfAmounts] the page header of page 2 of the...