Access Report - inserting object after each page.

[bhsbj]

I am trying to print an access report that does the following.

HEADER (prints page header on each page)
DETAIL (prints the detail line which occurs 9 times)
FOOTER (prints the footer on each page)

After the above scenario prints on 1 page, I want to insert an Object (Word Doc) then for the next page. After that prints go back to the above scenario and print it followed by this object.

Basically, print a page from my database table followed by a page from a word doc and repeat that sequence until the end of the database. I tried to place the object after the page footer, but I get an error about my margins and nothing happens. Any help would be very much appreciated. Thank you...

 

[GingerR]

I don't know the exact answer, but some ideas to try:

1) If your 'word doc' is always on even pages, you can make the header and footer not visible on even pages. In the header and footer ON FORMAT events, put something like

if page/2 = int(page/2) then
me.pageheader.visible = false
else
me.pageheader.visible = true
end if

change 'pageheader' to whatever your page header section is named (check PROPERTIES). Then do similar for Footer.

2) put the word object in your detail section with a page break above it. or otherwise fiddle around with the detail section to get it to print how you want. see if that works.

g

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244