473,327 Members | 2,094 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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
image.

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
report.
(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

Thanks
Joe
Nov 13 '05 #1
0 1603

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

55
by: James A. Donald | last post by:
In a book, a footnote is presented at the bottom of the page, in a slightly smaller type. converting a book to html, pages are bottomless, so we can put the footnote in a separate link, or...
4
by: Ed Landau | last post by:
In VB6.0, I can put an image on a form and assign it's .picture property at run-time. In VBA (within MS Access), when I put down an image control on a form, it asks me for the source to the image...
1
by: Veetold | last post by:
The solution you suggested works very good - thanks again. I encountered a new problem related to this topic. According to your advise I put the following line to print and format event: ...
6
by: Roger | last post by:
I have a report with a image displaying our company logo if I create an snapshot of this report, it appears to create an 'snp' file, but nothing is stored in the folder I tried both linked and...
0
by: BATISTA | last post by:
Hi , I am working in c# with crystal report XI. I read an example about dynamic image location .. 1) In that we have a xml xchema file with two fields n amed country--datatype is string,...
0
by: BATISTA | last post by:
Hi I have to program in C# such that I have to add a button to the form , and create a crystal report, by getting source from the xml schema file(.xsd file) with two fields namely...
4
by: NASAdude | last post by:
I'm working on distributing a database using VS Tools for Office, and am having trouble with linked images on forms/reports. The image objects have a default path\file set on the .Picture property,...
0
by: Byomokesh | last post by:
Hi, I have problem facing in Linking Tags. Linking are 3 types. <!-- Just remark Id --> :( 1. Pref02fn1 <!-- This footnote text move to paragraph in place of link tags. --> 2....
0
by: Saaima | last post by:
Hi All when I store a picture of size 800*600 pixels in database (SqlServer) field Photo (Image) and load it into crystal report through query by dragging and dropping the field on report it...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.