How to add linked jpeg image per record on form

[Pedigreeman]

I have read that Access requires additional software or coding to do this. If you know how to do this without the need to install additional software, please let me know - and I am new to Access so would appreciate it if you broke it down into steps (particularly if it involved coding)

I have a table with a text field 'Pictures' full of paths and file names (jpegs) which I know needs to be the control source for my imagecontrol frame which I have created in the form design.

 

[DCrake]

So what is your problem?

 

[Pedigreeman]

So what is your problem?

My text field entitled 'Picture' contains the paths for each record (e.g. C:\Pictures\pic1.jpg, C:\Pictures\pic2.jpg etc.)

My image control, entitled 'ImageFrame' has a control source, set to 'Picture' and in its properties, Picturetype is 'linked' and Picture is 'none'.

On saving the form, and entering it in form view, no picture in any record is being displayed.

I do not know what I am doing wrong, but thought it may be because I am trying to use .jpgs instead of .bmps

 

[DCrake]

The Picture property is where the path to the file should be.

Me.ImageControl.Picture = "C:\..."

 

[Pedigreeman]

The Picture property is where the path to the file should be.

Me.ImageControl.Picture = "C:\..."

Thank you David for taking the time to respond. You will have to forgive me, as your simple explaination went right over my head - yes my understanding of Access is that bad. I am not familiar with VBA or coding of any sort.

I tried converting the images from .jpg to .bmp files and then everything worked perfectly, but all of my images are stored as Jpegs and I do not want to convert them all before adding them to the MS database. I would appreciate any light you can shed on this, baring in mind that my understanding of coding is extremely limited. Many thanks

 

[Pedigreeman]

ok it seems to be working now - thanks for your help

 

[DCrake]

Take a look at the northwind template provided by MS

 

[Pedigreeman]

Take a look at the northwind template provided by MS

I have. It just seems to show what Access can do if you are an expert - no instruction/explanations. I like my dinner served in small digestible pieces.