Change a Picture in an Attachment

[ksmith]

Hey Guys,

Got a question, I haven't done any work where I had more than one picture in an attachment file. I know that you can have multiple pictures in the attachment. I was wondering if there is anything that you can do to change the view (picture) other than the built in control that 'comes up' when the picture area on your form has focus.

What I was thinking of is a big "Left' 'Right' arrow that you could put under the picture area on your form to help the user naviagate through the pictures. Or better yet, have small thumbnail size pictures that you click on to display a larger view in the main picture area.

Has anyone done anything like this is Access?

Thanks in advance for your help.

K Smith

[DaveT]

You can use the methods [AttachmentControlName].Forward and [AttachmentControlName].Back

See http://msdn.microsoft.com/en-us/libr...ffice.12).aspx

For example, I have a form with an attchment control named Photos

Put a command button with picture = Arrow Right and Photos.Forward in the OnClick event.

Put another command button with picture = Arrow Left and OnClick = Photos.Back

[ksmith]

Thanks for the reply. Thats looks like what I was needing!

Again, Many Thanks.

K Smith