Continuous Forms - Setting picture by ID

[xhonzi]

So,
I've successfully been using this in a ton of single forms:

me.pictureBox.picture="C:\pictures\" & id & ".jpg"

Now I'm trying to use it in a continuous form and I'm having that old chestnut of a problem where if I update the .picture value of the box, I change it for every record on the form and not just the one I want.

I've been poking around and haven't come up with a solution. I'm sure if there is one, someone here has it.

Thanks,
xhonzi

 

[TheAceMan1]

How are ya xhonzi . . .

Not so with continuous forms . . . Sorry

You'll have to use a bound object frame and a field in the appropriate table (for the path & filename) to bind the object to.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[TheAceMan1]

xhonzi . . .

The following quote is incorrect:
[blue]You'll have to use a bound object frame and a field in the appropriate table (for the path & filename) to bind the object to.[/blue]

it should read:
[blue]You'll have to use a bound object frame and change graphics thru the frame. When you set graphics, be sure to link instead of embedding![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[xhonzi]

I did find a little more after I posted last night and it seems that Access 2007 has gotten rid of the "bloating" issue that prevented linking images from working before.

Does anyone know if you "link" vs "embed" does it still put the file in the DB? I didn't really care about the .bmp VS .jpg problem as much as the fact that it still tried to store it in the .mdb file when you told it just to link.

Thanks,
xhonzi

 

[TheAceMan1]

xhonzi . . .

Linking uses less resources.

Embedding stores the entire graphic file in the Db. With this, the Db will grow by the size of each graphic. This is great for portability, but if you have alot of graphics initial loading of the Db will slow down.

[blue]I did find a little more after I posted last night and it seems that Access [purple]2007 has gotten rid of the "bloating" issue[/purple] that prevented linking images from working before.[/blue]

The bloating issue involves [blue]embedding![/blue] Could you post the resource for this issue? I'd love to critique the info . . .

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886