Don't know how to LINK PICTURES

[buee04]

Hi,

This is my first database and I've only been using Access for 2 months now. But I'd like to be able to link pictures to my report from a table, according to the record.

I've been gathering what I could by reading older posts on the topic and this is what I have done: I have a table, tblImages, with a primary key of ContractNumber and another field called ExternalFileLocation, which stores the path of the pictures.

But I don't know where to go from there. I know in the report design area, I'm supposed to have an image control and another textbox whose recordsource is ExternalFileLocation. But I don't know how to get an image control. I tried adding it by using the IMAGE button on the toolbar but that makes me direct the path to the picture directly, but I want to link different pictures for different records.

PLEASE HELP. Thanks in advance!

 

[nberryman]

Do you want a copy of a pictures database that does just that?

If so e mail me with Photo Database in the subject and I will send you a copy

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[buee04]

Hey Neil,

Could you send the Photo Database my way? Our email server is down, as usual, so I can't email you. Hopefully you have email notification and you'll get this. If not, I'll email you when the server's back up.

jonathan.mau@york.com

Thanks,

Jon

 

[RSi2]

check your mail