Image in Access

[SF]

Hi,

I have a Contract database that are able to print contract for grantees.
This database is working OK except that its size increase from 5Mb to 20MB
after I add two logo at the top of the contract report. I know that Access
is not good with images so instead I wish to LINK these pictures to the
reports.

My question is:

1 - What control should I use (I found there are Image, Bound and Unbound
Object Frame)
2 - How Can I link these images to the above control?

I must address this issue before hand as there are more standard reports
(above 40) that will have Logos on the top of each report.


Regards

 

[Damian S]

Hi SF,

In my systems, I create a single small JPG copy of a logo and create a
report that just has that logo in it. I then insert that report into every
other report created as a subreport to display the company logo.

This will dramatically reduce the space required, as you only need a single
copy of the image stored in your system. Of course, you could use the same
method for forms if required also.

Hope this helps.

Damian.

 

[Arvin Meyer [MVP]]

Linking won't help a lot. The next version of Access (A2007) will handle
images better. If you're good at coding, you can store BLOBs and avoid the
extra overhead of storing a bitmap. You can also just store the path to your
file and load it as needed. That is, by far, the most economical use of
space. A demo of that with evrything that you can import into your own
database is at my website:

http://www.datastrat.com/Download/Picture2K.zip

 

[Tom Wickerath]

Hi Damian,

Of course, you could use the same method for forms if required also.

This is exactly what I do. You can use an unbound subform in forms and
reports. Thus, you don't need to have two objects (a form and a report) that
each contain the same logo image.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Tom Wickerath]

Clairification: I didn't mean to imply that one can only use an unbound
subform in a report. You can use bound subforms in reports as well, but
having a bound form is not required for a form that displays an embedded logo.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Damian S]

There ya go - learn something new (or someone points out something blatantly
obvious that you have just overlooked) every day!!

Thanks Tom...

D.

 

[Tom Wickerath]

You're welcome.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[SF]

Thank you all for valuable time to help solving problem in this group. I
appreciate it.

SF

 

[Tom Wickerath]

Hi SF,

You're very welcome. I'm glad to read that you find this forum a useful
source of information. Good luck on all of your Access projects!


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________