Access Reports, Multi Page Tif's, and Stephen Leban's Method

[R.T.]

I have sql database that stores links to images of invoices in
multipage tiff's in the filesystem. I am using Stephen Leban's
wonderful code to display the multipage tiffs in access 2003
forms/reports.

A user has the ability to select a range of invoices (no pictures) by
multiple different criteria. The result is displayed in a continuous
form. A link from each record line will put up an associated form
with the image displayed.

What I need to do is provide a method for the user to print the entire
list of selected invoice images complete with multiple pages, each
invoice page on it's own sheet. I can currently get the first page of
each Tiff to print on its own page, but I am not having any luck
getting the 2nd through x pages to print.

To further clarify:

A user creates a list of 5 invoices, (two have a single page scanned
and stored, two have two pages scanned, and one has 3 pages scanned)

I want the user to be able to click a button, and a 9 page report
print that has each page of it's parent invoice on it's own page.

Final clarification;

I have a query which returns information and an invoice (date, number,
amount, etc) along with a link to a multipage tiff stored in the
filesystem. Using this query for a reports recordsource, how can I
print each page of the tiffs?

 

[Stephen Lebans]

The code you are referring to does not support multipage TIFF documents. Two
methods come to mind. One is very straightforward requiring very little VBA
programming. The other method would take a couple of hours to create from
scratch but I would bet you could find a ready made sample in VB that could
quickly be ported over.

Method #1: ***Requires Office 2003***)
Use the MODI(Microsoft Office Document Imaging) ActiveX control. It exposes
methods that would easily allow you to create and modify multipage TIFF
files.

the MS MODI doc URL.
http://support.microsoft.com/default.aspx?scid=kb;en-us;311765

For detailed info on the control and sample source code see:
http://www.ilixis.com/developer.html


Method #2:
Modify the GDI+ sample MDB on my site that allows you to view single
page TIF files on an Access form without requiring the standard
Microsoft Office Graphics filter for TIF files(no longer included with
Access2003).
http://www.lebans.com/loadjpeggif.htm



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[R.T.]

Thank you on the quick reply, Stephen. Let me also thank you 'in
person' for all the help your code/website/usenet replies have been to
me over the years.

I fear that perhaps I am missing something. Using the MODI ActiveX
control, and get load the image into the control, and even display the
assocation information about the file. What I am NOT able to do,
however is to make the image appear in any way. This of course leads
to a blank printed page.

I haven't even approaced the multipage issue yet, with this method,
becuase I can't even get the image to display.

FYI, this is the same issue I'm having with my orignal 3rd party
control - I can't get it to display the image in the report. I can
display them on forms, and they work as expected. I can use your code
from loadjpeggif and the first page of the image displays.

I would once again greatly apprecate any pointers provided.

 

[Stephen Lebans]

Is the issue is that the MODI ActiveX control will not display on a report
but will display properly on a form?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[R.T.]

Yes, that is correct.

 

[Stephen Lebans]

I think in this case you will need to print the pages directly from the MODI
control on a form which can be hidden if required. I'm sure one of the MODI
URL's I pointed you to contains sample code demonstrating how to render the
contents of the control.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Bilbo]

I think in this case you will need to print the pages directly from the MODI
control on a form which can be hidden if required. I'm sure one of the MODI
URL's I pointed you to contains sample code demonstrating how to render the
contents of the control.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Stephen Lebans]

I'm positive you could find sample code demonstrating how to use the GDI+
libraries to load/manipulate multi page TIFF documents.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.