Copying Images from a Report

[oblivion86]

Hi,

I have a report that is generated from a search form, the report displays images and a few fields such as employee ID, address, etc.

However, when I right click on the image in the report, the option of copying the image is greyed out.

How do I "enable" the copying option if there is such a thing?

Thanks in advance!

 

[Trevor G]

What version of MS Office are you using? You can't copy an image in a report by using right mouse button, if you are using MS Office 2010 you get a screen clipping which will allow you to draw around the image into another document, other than that you need a third party software option.

I use Quick Screen Capture which you can download from this link http://www.etrusoft.com/

 

[oblivion86]

i'm using version 2007.

Wow, that is rather inconvenient, i am compiling this database for office use, and would require administrator rights to install any 3rd party software.

Would Microsoft really make it that difficult to copy an image from a report?

Thanks for your reply anyways.

 

[Trevor G]

If you have MS Office 2007 do you have OneNote installed as you get the Screen Clipping there, other than that it must be press screen print and paste into something like Paint or Word and crop around the image.

 

[oblivion86]

ok, think I will stick to the print screen method then.

Thanks Trev.

 

[Trevor G]

Sad you can't get a better solution!!!!!!!!!! Have a good weekend

 

[vbaInet]

Hmmm... I know this has been dealt with but where are the images coming from? From a table?

 

[oblivion86]

Yes, the images are from a table.
Data is keyed into the table through a form and as for the image, I have inserted a picture and added the directory where the image can be found in the report.
e.g. C:\Users\File\Pictures\image1.jpg

The report generates the images when a query has been made.

Able to help with a more user friendly(straightforward) method of copying the images from the report vba?

 

[vbaInet]

So Access isn't copying the image, it's just displaying the image by following the link. You will do the same thing in your report by setting the Control Source to the path of the image.

 

[oblivion86]

Vba, i dont get what you are saying? Is terr a way i can solve the problem preventkng me from directly copying the inagw from the report itself?

Thanks

 

[oblivion86]

Anyway do any of you know how to attach an image through a more user friendly method? Maybe browse: then look for the image you want to attach rather than input the directory which the image is at?

Maybe another method of attaching image will allow the direct copying of the image?

Thanks

 

[vbaInet]

Vba, i dont get what you are saying? Is terr a way i can solve the problem preventkng me from directly copying the inagw from the report itself?

Thanks

The intention of using a path to to display an image on a form or report is so as to avoid your database from bloating. Your current method is the preferred method.

Anyway do any of you know how to attach an image through a more user friendly method? Maybe browse: then look for the image you want to attach rather than input the directory which the image is at?

Maybe another method of attaching image will allow the direct copying of the image?

Thanks

If you just want a one off image then drop an Image control on your report and you will get the dialog box for you to select the image you want to display. This way the image will become part of the form. Of course this can only be done in design view. Again the more you do this the more bloat.

And if you're still interested in other techniques, see the following site from LPurvis:

http://www.databasedevelopment.co.uk/examples.htm

See the sections: Storing Picture Data and Storing BLOB Data.

 

[oblivion86]

Thanks vba, so what you mean is that the image size won't be taken into account as the database size?

i.e. database size = any other information I have included (excluding the image size?)

 

[vbaInet]

If you use the path it won't be. But if you start embedding images in your forms then yes your db will start to increase in size tremendously.

 

[oblivion86]

Ok then i'd rather have a smaller sized database and use screenshot than have a big database.

Thanks all. : )

 

[vbaInet]

I don't think you've fully understood. What will you do with the screenshots?

 

[oblivion86]

It's for the users to retrieve the images from the report.

 

[vbaInet]

Ok, what would they do with the image after copying? Or they can do whatever?

 

[oblivion86]

yes anything they want with it. But usually it is just for attaching to email etc.