Re: Updating Picture on main form from subform - 2nd try

From: MacDermott (macdermott_at_NoSpam.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 06:56:23 -0400

Here's something you could try:
Put a small bound object frame (DetailPicture) in the Detail section of your
subform.
    set its controlsource to your OLE field, and its visible property to
False.
Put an unbound object frame (MainPicture) on the main form.
    Set its Locked property to False and its Enabled to True.
In your subform's OnCurrent event, put code like this: (WARNING: AIR CODE)
    Me.Parent!MainPicture.PictureData=Me!DetailPicture.PictureData

Be advised, though, that storing OLE images directly in your database like
this will bloat your database significantly.

HTH
    - Turtle

"John Rischmiller" <john@rischmiller.com> wrote in message
news:OdJaD%23XPEHA.2444@TK2MSFTNGP12.phx.gbl...
> Second attempt to resolve this problem.
>
> I have two tables, a master table and a detail table with multiple detail
> records for each master. They are connected via a one-to-many
relationship.
>
> The detail record includes an ole field that is used to contain pictures.
>
> I've a query to select all records.
>
> I've used the form wizard to start off the data entry form and specified a
> master form with a subform. The subform is tabular. The subform generated
> included the picture in a bound object frame and works. However I want
> multiple detail records displayed in the subform without the picture, with
> the ability to click on or select a detail record and have the picture
for
> that record display in a control on the main form.
>
> Jason suggested using a picturebox but the Toolbox doesn't have a
picturebox
> unlike VB, it has image, unbound object frame and bound object frame. I've
> tried the bound object frame specified as per the detail record but it
shows
> nothing.
>
> I hope I've made it clearer this time.
>
> Regards - John
>
>
>

Relevant Pages

  • Updating Picture on main form from subform - 2nd try
    ... a master table and a detail table with multiple detail ... The subform is tabular. ... included the picture in a bound object frame and works. ... unlike VB, it has image, unbound object frame and bound object frame. ...
    (microsoft.public.access.formscoding)
  • Re: Always limited by this!
    ... If the picture is the same for all record, then a possible solution would be ... to use a bound object frame, set the picture in a separate table with two ... lot of memory when used on an Access' continuous form. ...
    (microsoft.public.access.formscoding)
  • Filename displaying with image
    ... I have downloaded a tutorial database, which has a form containing a bound ... object frame to display a picture. ... The picture field in the underlying ... path is not included) in the bound object frame. ...
    (microsoft.public.access.forms)
  • Re: How can I insert a a new (blank) ms word object into Access OL
    ... The object frame knows how to "package" the Word ... >> You can do this by putting a bound object frame control on a form and ... >> Please respond in the newgroup and not by email. ... John Nurick [Microsoft Access MVP] ...
    (microsoft.public.access.modulesdaovba)
  • RE: pictures embeded in forms are shown as icon.
    ... Is the control on the Form an Image Frame, an Unbound Object Frame, or a ... Bound Object Frame? ... Are the images being stored in the Access file as Linked/Embedded objects ...
    (microsoft.public.access.forms)