Customizing report footers

[cwhite23]

Good afternoon.

I have been working on a project that has me stumped. I have set up what amounts to a multi-part Report. The report prints multiple times without any problem. What I'm stumped on is how to change the footer on each page automatically.

This is a pick ticket that I'm generating, so page one would have 'Pick Ticket' as the footer, page two would have 'Packing List', etc.

Any help would be appreciated.

 

[PWise]

Create a table PagesLists
field type
Pagenum ,number
Pagetype,text

in the controlsource of the control on the footer that you want to change

=dlookup("Pagetype","PagesLists","Pagenum =" &[page])

 

[cwhite23]

Unfortunately this is a one page report that prints six times per order, so the page number is always 1. Great idea though!

 

[PWise]

how do you print the report

try this put this table in the record source of the report

without any joins

SELECT orders.*, PagesLists.*
FROM orders, PagesLists;

now it will print the amount of records you have in PagesLists
in the control source on the footer put Pagetype

 

[cwhite23]

Basically, the report prints one page per order. I then have a macro set up to print this report six times. I know this may sound sloppy, but I haven't figured out a better way as yet.

 

[PWise]

forget the macro

just use this record source that i posted

 

[cwhite23]

How do I get Access to print the report multiple times without the macro? Remeber - this is a one page report.

 

[PWise]

From where do you run the macro?
Is it from a button on a from?

Then change the code to

docmd.OpenReport "reportname",acViewNormal

and it will print the report three time

try it and let me know what happens

 

[mp9]

If you're using a fairly recent version of Access, why not use the OpenArgs property to pass a different string in to the report each time you run it?
e.g.

DoCmd.OpenReport "reportname", , , , , "Pick Ticket"

Then you could use the footer's OnFormat event to populate a text box with the contents of the OpenArgs proeprty... job done.

http://www22.brinkster.com/accessory/

 

[PWise]

sorry

and it will print the report three time


should read

and it will print the report six time

 

[cwhite23]

pwise / mp9 - No luck. I've tried all of the methods above without success. Thanks for the ideas though.