Hi all I have an ADP which had a form that I put pictures in for the viewers to look at. It was basically a picture table that was linked to the master table so viewers can see employee pictues. But since we upgraded to Microsoft Office 2003 I cant see the picutes anymore just the file number.jpg and thats it, but when I had Microsoft 2000 I didnt have that problem. Can anyone help please this is driving me crazy and I need to get it resolved ASAP\
How is the data stored? Do you store the whole file location (eg, "C:\folder\picture.jpg"), or just the name of the picture file (eg, "picture.jpg")? It is the later, do you store all of them in a single folder?
Generally, I do not like to store OLE objects in the dB. I do a similar thing in a dB of mine, but I store the file location as a string in the table. Then, on the OnCurrent event, I use the code I posted earlier. Give this a try.
Check out the attached dB. Just unzip everything to some folder somewhere, and check out the only dB form.
EDIT: The only thing I do differently with mine is that I store all the pictures in a subfolder with the dB, then I name all the pictures with the ID# of each person. So when I need to update the picture, I just formulate where the file should be, do a check, and load it. That way you don't actually have to store anything for the file location.
in the dB, i just used application.currentdb.path (i think off the top of my head) to make sure it would find the pictures in the same folder as you put the dB (as I would have NO idea where you would choose to put it). You can replace this with a string indicating your folder (if it is constant).