Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Exclamation Unanswered: Report Footer JPEG Display (1 unique JPEG for each page)

    Hello...

    I have an Access Report that needs to have a different JPEG displayed at the bottom of each page (3 different JPEG's). An example would be:

    Page #1 has A.jpg displayed at Page footer
    Page #2 has B.jpg displayed at Page footer
    Page #3 has C.jpg displayed at Page footer
    Page #4 has A.jpg displayed at Page footer
    Page #5 has B.jpg displayed as Page footer
    Page #6 has C.jpg displayed as Page footer
    Page #7 has A.jpg displayed as Page footer

    The report has approximately 140 pages.

    I am thinking to input an event procedure that would have a counter that starts at 0 and increases 1 each time a page is generated. The counter would have to be reset when it = a value of 3 to go back to the first picture.

    I have limited VBA coding skills... Any help is greatly appreciated...

    Matthew Vestervelt
    416.480.8197
    Last edited by AutoDB; 10-28-04 at 12:01. Reason: Subject heading was inaccurate

  2. #2
    Join Date
    Sep 2003
    Posts
    228
    A report has an 'OnPage' event where you could increment a variable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •