Displaing Images to Match a Record Value

[Tracy2]

Hi

I would like to be able to display an image on a report that is linked to the record. For example, I have a table called room that has many records of different rooms. What I would like to do is to display a picture that is associated wit each room? i have searched the forum for a solution and while there is lots of advice - none of the replies seem to fit my needs.
I have also tried the Access help files and do not find the help practical

can anyone help???

Many thanks

Tracy2

 

[maxmangion]

are you saving your images as an OLE object in your table record ?

 

[Tracy2]

Hi

I have looked at that but to be honest I do not understand how to go about coding this...

Thanks for your reply

 

[maxmangion]

you should create a field in your table and set it's datatype to Ole. Then you should create the control on your form/report and bind it to the OLE field which you create in your table.

Also in the properties of your Ole field you should select "linked" the images and not "embedded".

 

[Tracy2]

Hi

I have created a bound object frame and linked this to the ole field using the control source in the properties of the bound object frame - please excuse my ignorance - I have nver done this before - the thing is that when I open the report - i now get a pop up box expecting input??

many thanks for your help

 

[maxmangion]

did you put your images in your database i.e. in your newly created OLE field do you have any images there for any of your records ?

 

[maxmangion]

by the way if you search these forums, there are several threads covering this issue and some of them, they even have a sample database. here is one link

 

[Tracy2]

yes I did - but when i open the report to view - i still get a dialogue box asking me to enter a parameter value???

 

[Tracy2]

many thanks for that - i will have a look at the example - i think i get how this works now

thank you very much for your time
Tracy2

 

[maxmangion]

you're welcome . I hope that the sample example of OldSoftBoss will help you out.

 

[Tracy2]

i think that it will - i have done something similar to display a selected report from a list box so it looks hopeful........

have a good weekend

Tracy2