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

 

[Norie]

The link between the parent and sub forms is established using code?

Why not use the relevant properties of the forms to do that?

 

[Dan1000]

No. The link between the parent and subform is with a Child/Master link/relationship as mentioned.

There is code in place to automate the image links. The relationship alone does not do this.

There is also code which automates text values in the subform. I wonder if more code will disrupt this process. I guess there is a way around this. Maybe use code directly with the image frame or use queries?


Regards

 

[Norie]

So what's the code to automate the image links?

 

[Dan1000]

Microsoft Article ID: 285820


Regards

 

[Norie]

Sorry for another question, but how are you using that function to load the image in the subform?

I'm sure the function works but perhaps you aren't using it quite right.

 

[Dan1000]

Trust me - it does work. The problem is associated with the record source conflict between the parent form and subform, not the code.

The code and setup work fine on a parental form setup (without any subforms).

...the problem I have is associated with accessing the parental reference from the subform.

Perhaps it is not possible to have two sets of links between a parental form and subform?


Regards

 

[Norie]

That's actually what I'm trying to find out really.

Where is the field with the image name/path and how are you trying to refer to it so that you can use the function?

 

[Dan1000]

What are you trying to find out - exactly?

I may be able to help...but can you help me? or...am I on a wild goose chase?

 

[Norie]

I just set up a form/subform where the subform had an image.

I used one line of code in the subform to load the images

Option Compare Database
Option Explicit
Private Sub Form_Current()
Dim strPath As String
 
    strPath ="C:\Images\"
 
    Me.Image9.Picture = strPath & Me.ImageName.Value
End Sub

ImageName was a field on the subform and the 2 forms were linked by the ID of the main form.

So when I moved between records the data in the subform changed, so the image changed.

Also, the ID from the subform was the same as the ID of the main form.

This was a very simple setup but worked fine.

If you used the function how did you pass the image control and the path/name of the image to be loaded?

If you have linked the form and subform you don't need to get the value from the subform.

Perhaps I'm missing something, and if I am I apologise.

 

[Norie]

Dan

Just reread your post.

I'm trying to help but need more information.

What I set up was to see if I could replicate your problem.