Storing Image Names in db and displaying in acees form

[loveday]

Hello Dear experts,

I have only done what I am about to ask in asp, not in access as front end tool.

We have a bunch of images stored on our server (folder).

We have built an access application which allows the display of images per record.

For instance, if you open an access form or reports, and you select all records pertaining to John Doe, eg., his name, address, profession,and a picture of him.

The way we are inserting this into an access database is like following:

Name , Address, Phone, Profession, cImage
John Doe addrss1 303-333-3093 Programmer image.jpg

I would like a vba code or function that allows to display a record of John, along with his picture.

In ASP, I would have done something like this to pick up the image from image directory and display it:

<img src="img/<%=rs("cImageurl")%>

As you can see, the image is in a folder called img which is in the same directory as the rest of the files.

Can someone, please help?

 

[PHV]

Take a look at the Northwind database.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[loveday]

That's exactly what I am looking for but I *can't* find the code for the images.

Any clue?