Picture Control (1 Viewer)

[sajarac]

Good Morning All,
I have this issue with pictures in reports, in my table I have my pictures stored as a OLE Object, an if i want to show those in my reports seems like the only option is to use a third party software "AccessImagine", and I have to pay for it. is there any way to see my pictures without add this Active X control?

thanks in advance for any response

Regards

 

[Ranman256]

if you have the path of the photo in a field, and an imageFrame on the report
(imageframe is the icon that has the sun over the mountains )

load the image in report detail ON PRINT event
imageFrame.Picture = [FilePath]

 

[sajarac]

Hi, thanks for your reply, unfortunately doesn't work, because I don't have the pictures stored in my PC or network, the pictures came from the users when they submit a new record.

 

[arnelgp]

you can use Bound Object Frame control and bound your ole field to the control.

 

[sajarac]

Hello Sir, and thanks for your reply, doesn't work, only using this active x control works, any other suggestion?

Many thanks!!

 

[arnelgp]

can you post stripped down version of your db.

 

[sajarac]

Hello there, this is the table and the users submit the pictures, is an OLe object, and the third party active X control seems like is the only one that can handle the pictures.

Any advice?

 

[Simon_MT]

What version of version of Access are you running. I have had to use an ActiveX component on pre Access 2007. The (25,000) images used COULD NOT be stored and were held on a server and NOT locally.

Simon

 

[sajarac]

Hello, thanks for your interest, I am using Office 365, 2016.

 

[Simon_MT]

Above 2007 will handle jpeg images so I have used the picture element and referential logical to the images. I did have to rewrite the Image Management Scripts.

Simon

 

[sajarac]

Hi, thanks for your prompt reply, but it's mean?
That I don't need the active X control? this is a third party and it cost around $65. if so could you please explain how can I achieve this?

Many thanks

Regards

 

[arnelgp]

can you post a sample of your db, maybe 2 or thee records.

 

[sajarac]

Hi Sir, and thanks for your interest, I am using an application named "Cellica Database", if you can see the PDF file, you get the idea, in the page 8 they suggest to use two different controls to allow user see the pictures in the database, but you have to pay for that, that is why I would like to use any Microsoft control that can do the same.

Many thanks

http://www.cellica.com/kb/Cellica_KB_2013_EE_231.pdf

 

[arnelgp]

i see, can you post at least 1 record of your table, so i/we can test.

 

[Simon_MT]

I used to used dbpix for Access 97 but NEVER stored a single image within the database. With about a GB of images I could access these images with no footprint. I didn't realise there still products advocating storing images in databases.

Simon

 

[sajarac]

Is this what you are looking for?

 

[arnelgp]

hello sir, i need a database not picture.
import your table with OLE field to new database and delete some records.
just leave 1 or 2 for test.
if my test fail or succeed, i will inform you.

 

[sajarac]

Hello, please apologize, hope this help!

Many many thanks

Regards

 

[arnelgp]

here's your picture report.
some picture (if it is a picture) cannot be shown.http://www.4shared.com/file/h9aKORruba/Picture_Test.html

 

[sajarac]

Thank you very much Sir, I cannot open the file, but if you don't mind could you please let me know if you could see the pictures? at least one, without using the third party active x control?