468,307 Members | 1,324 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,307 developers. It's quick & easy.

Footnote on image report

Hi everyone,

I have spent several hours on this topic, and I still don't have the
right solution.

However, you guys can accomplish in 5 minutes much more then I can
accomplish in 5 hours. :-)

OK here is my issue,

The structure of my DB is like this, main table with several sub
tables. Each record on each table can have only one image. However,
each image can be one or multiple pages. (It can reach more then 40
pages per record)

All of the images are black and white. I don't need any special
features when viewing/Printing it.

Each record of the 10 tables has only one field called
"Image" that I would like to use for the link to the image.

I have a report that prints all data inputted into the main tables,
and form the sub tables.

I also would like to include into this report (or send as a separate
report, which ever will be easer to setup) a copy
all of related images.
At that point, I would like to add a footnote at the bottom of each

The footnote should be my company's name

The way I was thinking to prepare the images report. Is like this,
create a query that collects all links to the appropriate images, add
them to an image control, and add the annotation at the bottom of the
(This way I'm not modifying the scanned images)

NOW, if there is a way to scan all 40 pages at once and have the
computer take all 10 image files and export it to one big file, and
add the annotation at the bottom. That will be excellent.

(This might be done without using any MsAcess utilities)

If that's not possible and I have to scan each page separately, what
is the correct way to store the link to the images?

If possible I would also like to use one automation feature, that
will automatically name the scanned images (while scanning it) based
on a combination of some fields on the main record/table.
This can be very useful. However, this is only a plus, and can be
discussed latter.
I'm thanking all of you in advanced

Nov 13 '05 #1
0 1380

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

55 posts views Thread by James A. Donald | last post: by
4 posts views Thread by Ed Landau | last post: by
reply views Thread by BATISTA | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.