Select a record and display an image

[Chris G]

To start off with my project i'd like to simply display an image from a UNC path in a form after selecting a record.

The database will have 2 columns, 1 for a name of the image and one for a path to the image.

I've been trying to create a dropdown list that lets you select a record (image name) and will display an image based on the UNC path in column 2.

So far i've had no luck! =(

Any help would be greatly appriciated

[maximus]

Check this link

http://www.ammara.com/access_image_f...ive_paths.html

[June7]

Nice article Max.

Chris, I don't think Access can recognize UNC pathing (I will do some testing to verify) although VBA can. However, that doesn't help if you are trying to set ControlSource property of Image control.

[June7]

UNC pathing does work in Image control ControlSource. Just couldn't get it to work on home computer but it does work at the office.

Why 'no luck' - what happens - error message, wrong results nothing?

[Chris G]

Why 'no luck' - what happens - error message, wrong results nothing?

No luck because i'm terrible with Access. I'm not able to get even the most basic thing working which likely would solve my problem.

A drop-down list that lets me select an entry from my database. The image control then displays the UNC path based on which record is selected. The complete "noob" problem I have is I can't pass just the UNC path of the active/selected record to the image control.

[June7]

Why is there need to 'pass' the path. Set the Image control ControlSource property to the values in the fields, go to that record and the image should display. Concatenate "\" if needed:

=[UNC path field] & "\" & [image name field]