Re: Updating Picture on Main Form from Sub Form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Rischmiller (john_at_rischmiller.com)
Date: 05/17/04


Date: Mon, 17 May 2004 13:28:05 +0100

Thanks, Jason, sorry if the question was unclear, I'll try and be more
explicit.

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.

You suggest 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.

Regards - John

"Jason" <anonymous@discussions.microsoft.com> wrote in message
news:C13B4FE8-B643-41E9-B47D-A5EA88FD9EBB@microsoft.com...
> You don't have to add code for this. Add a picture box control to the
form, bind it to the field that corresponds to the image needed. Your
message was a little confusing. In either case, if your many side table has
a different image (possibly) for each record, then that will be your
datasource.



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: ANN: Special kbmMW timelimited offer!
    ... On each master change, get a new matching detail record from the database. ... > What about Master-Detail support? ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: OTHER BIG BUG : deleting detail master delete
    ... database and i want to delete 'simple' a detail record in a table, ADO ... In a master detail relation with transaction and batchoptimistic ...
    (borland.public.delphi.database.ado)
  • Re: Master/Detail + cachedUpdates
    ... > When inserting a new detail record, the linking data is not automatically ... Please be aware that cachedupdates is problematic with linked Master Detail ... dataset situations. ... circumvent this is to apply both master and detail updates in the master ...
    (comp.lang.pascal.delphi.misc)
  • Need example of sophisticated master/detail GUI
    ... good visual context as they drill down from the master to a detail ... and then to a detail record of the detail record.... ...
    (comp.lang.java.gui)