Print linked pdfs within an Access Report II

[cjwagner]

I have a table with 180 records.



In this table is a field that is a hyperlink
that hyperlink is to a PDF file on the hard drive.

Each record printed is 2 pages long (8x11)

At the end of each record that is printed I want to print the PDF that is hyperlinked in that record.

This will print to a printer and be a hard copy NOT a .pdf file.

What I want to happen is
Record 1 prints to paper.
.pdf hyperlinked to record 1 prints to paper.

Record 2 prints to paper.
.pdf that is hyperlinked to record 2 prints to paper
........
record 180 prints to paper.
.pdf that is hyperlinked to record 180 prints to paper.

or as I would have done it in basic programing
10 for x=1 to 180
20 print record x
30 print hyperkink in record x
40 next x
50 end

It seem like it would be so easy but boy I'm just not clicking on this one. or maybe I'm just getting old.

Thanks for your help

[cjwagner]

I'm thinking that there may be some way to do an event at the end of each record, but don't know where to start on that.

[ajetrumpet]

didnt I help you on this just last week!?

I thought we solved this thing. I read your post AGAIN today and I still don't get it. Personally, I dont think the explanation is very good.

can you offer it again, another way perhaps?? what about a picture showing what you want?? this didnt seem so complicated when I helped you with it the last time...

[cjwagner]

Adam,

Same number of letters in our user name but I am a different person with the same 'type' of question.


I had read your post from the other day and thought this would solve my needs... But it appears that I was wrong.

The other post appeared to me to be creating a PDF File on each report. Maybe I was wrong. I've looked at at a couple of times already....

I have a table
it contains records that have 45 items, mostly text , but a few dates, numbers and a hyperlink.

In this example we will call the hyperlink field FX.

The report that needs to be generated is not a problem. I can print out the reports fine.

What I want to do is, in addition to printing the report, is to print the file listed in the field FX
I have 180 records that contain information that is contained within .pdf files. Things like Material, color, texture, Liquid, Solid..... and so on.

Also in each record there is a hyperlink field that references that particular .pdf file. (FX)


I need to print out a hard copy of all the information ... all 180 reports and all 180 .pdf files.

I would like to create a report that would print out the first report record and then print the .pdf that is associated in the FX field.

Go to record 2, print out the report for the second record and then print out the .pdf that is associated to in FX record 2... and so on through the 180
records.

Each Access report consists of 2 pages. The .pdf's range from 4 to 18 pages each.

I understand that this will use up a lot of paper but a hard copy is what they want.

Another way to think if it might be...

I have 180 .pdf files that I need to print (Sandwiches)
I need a report to go with each sandwich (Cheese)

I have Roast beef, Turkey, Chicken, Ham, Turkey and ham, Roast beef and ham, Roast Beef and turkey .... (The .pdf files)



Every sandwich HAS to have 'Cheese' on top (The Access Report)


Or


___________________ 2 page
___________________ Access Report record 1

___________________| 4
___________________| Page
___________________| .pdf
___________________| File
___________________ 2 page
___________________ Access Report Record 2

___________________|
___________________| 6
___________________| Page
___________________| .PDF
___________________| file
___________________|
___________________ 2 Page
___________________ Access Report Record 3

___________________|

___________________| 18

___________________| Page
......

It always looks so simple to the one who is doing it... trying to explain it, well that's something different.

Is there an event that could happen at the end of the second page that would automatically kick in the print FX (hyperlink) to the printer?
Thanks