A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I add jpegs to my Access Reports in Access 2003



 
 
Thread Tools Display Modes
  #1  
Old August 7th, 2006, 09:31 AM posted to microsoft.public.access.reports
ART
external usenet poster
 
Posts: 432
Default How do I add jpegs to my Access Reports in Access 2003

I am currently building a bibliography of books, and would like to a photo of
the book cover in my report, how do I acheive this?
  #2  
Old August 7th, 2006, 01:46 PM posted to microsoft.public.access.reports
freakazeud
external usenet poster
 
Posts: 67
Default How do I add jpegs to my Access Reports in Access 2003

Hi,
a simple solution would be to add a text datatype field to your records
table.
In that you can hold all the full string path values to the external image
files. It is not advised to store images within access because of a known
bloating problem.
You can then use this string path at runtime to display your images on forms
and reports.
A good tutorial of this can be found he
http://www.databasedev.co.uk/bound_image_form.html
http://www.databasedev.co.uk/bound_image_report.html
--
Oli-S
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de


"Art" wrote:

I am currently building a bibliography of books, and would like to a photo of
the book cover in my report, how do I acheive this?

  #3  
Old August 7th, 2006, 06:22 PM posted to microsoft.public.access.reports
ART
external usenet poster
 
Posts: 432
Default How do I add jpegs to my Access Reports in Access 2003

Hi Oli
Thank you for your help I'll give them a try
Best Regards
Art

"freakazeud" wrote:

Hi,
a simple solution would be to add a text datatype field to your records
table.
In that you can hold all the full string path values to the external image
files. It is not advised to store images within access because of a known
bloating problem.
You can then use this string path at runtime to display your images on forms
and reports.
A good tutorial of this can be found he
http://www.databasedev.co.uk/bound_image_form.html
http://www.databasedev.co.uk/bound_image_report.html
--
Oli-S
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de


"Art" wrote:

I am currently building a bibliography of books, and would like to a photo of
the book cover in my report, how do I acheive this?

  #4  
Old August 7th, 2006, 06:26 PM posted to microsoft.public.access.reports
Bill
external usenet poster
 
Posts: 191
Default How do I add jpegs to my Access Reports in Access 2003

Just add an image control to your report. Size the image
control to suit your needs and set the properties to "Link"
and "Stretch". If you don't want to hard-code the path to
the image, you can do that in the OnLoad event when the
report runs, i.e., Me.imgMyImage.Picture = "fully qualified
path of your image."

Post back if you still have difficulties.

Bill



"Art" wrote in message
...
I am currently building a bibliography of books, and would like to a photo
of
the book cover in my report, how do I acheive this?



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.