Image control, Access 2003...

[Dan1000]

Hi folks

Can anyone advise on image control in Acess 2003.

I have a database with about 200 entries each of which I would like to link to a unique image. Images are in a separate folder.

I would like to be able to pan and zoom in and out of the images from within Access.

Any help would be much appreciated


Regards

 

[Dan1000]

Link is fine...

Did not have Duplicates ok switch on but do not think this is an issue as I have now switched it on.

I have got a picture showing but when I back up database and reload it the picture does not appear again and also...

The first five picture names do not show in the text box whilst 'autonumber' is appearing in another text box and visa versa on the rest of the images - wierd - eh?

I know there are bugs in MS access 2003 as the form sometimes ignores the switch command between edit and non editing


Regards

 

[Norie]

So is this resolved?

 

[Dan1000]

Not sure - to be vague - sorry!

I think the set up you have explained is the correct method. I changed the code and its insertion point which may have helped.

The problems I still have are as mentioned....

1. Odd autonumber issue stopping first five image names appearing
2. Loss of link to images when database is backed up / shutdown / changed from edit to view mode?


Regards

 

[Norie]

How can you lost the 'link' to an image it's the image path/name that's stored in the table?

That wouldn't change if you backed up/shutdown etc.

How would an autonumber field affect anything?

How is it involved anyway?

 

[Dan1000]

Sorted the autonumber issue - I had deleted several numbers for a purpose which took a bit of figuring out!

I have reattached the image again. This sets the image into place so when you step through the process the image appears when the id appears.

The issue with the images not saving is still occurring. I note that the images also remain in the frame when I step past the id for the image, when it should in fact disappear as the id is no longer present!?

It may be something to do with my bad coding (can't think what though).

Is there a way to lock the images as they appear at their respective id's ie also lock the empty frame so it does not show an image if there is not one available - just shows a black area with the formatted background?

I need to find more time to look into this.


Regards

 

[choytw]

I had the same issue when making a DB for my wife (makes cakes). When current work had a picture, the picture was to load in the form. When going to the next record for work where a picture was not loaded, it carried over the image from the previous. In order to fix this, I added the following lines:

<CODE>
If IsNull(Me.imagePath) Then

Me.cakePicture.Picture = ""

End If
</CODE>