Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.ms-access > #10883

Re: Showing picture in a form.

From "Phil" <phil@stantonfamily.co.uk>
Newsgroups comp.databases.ms-access
Subject Re: Showing picture in a form.
Date 2015-06-29 15:53 +0100
Organization Aioe.org NNTP Server
Message-ID <mmrm62$pm6$1@speranza.aioe.org> (permalink)
References <jm51pa569j0lvevd0jasdale1b2l706vlb@4ax.com> <t4b2patgkjkuthr2p31sakfqmksn3er9j4@4ax.com>

Show all headers | View raw


On 29/06/2015 12:42:28, Dave W wrote:
> On Mon, 29 Jun 2015 10:56:03 +1000, Peter Jason <pj@jostle.com> wrote:
> 
>>Win7 ult.  Access10
>>
>>I have a database with a "Products" form included.
>>I want to display a picture of a product item when this item is
>>selected.
>>What is the best way to do this?  Do I have a folder in Windows
>>Explorer dedicated to the Product pictures, and will JPEGS be good
>>enough?
>>Peter
> 
> I have a database that shows a picture as part of a form. I have a
> table that holds the pictures in an OLE Object field. To get a picture
> into this field, I display the picture in an external program, then
> copy and paste it into the field. The picture can't be seen at this
> stage. The form contains an OLE Bound control with the table as its
> source, and shows the picture when the form is displayed. The picture
> table is of course suitably lnked with the other tables.

Dave,
Your method works perfectly well, but the reason that is not to be
recommended is that the file size, depending on the number of pictures, can
get very large. It certainly used to be the only way of showing a picture
until the Image Control came out, I believe in Access 2000.

Phil

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Showing picture in a form. Peter Jason <pj@jostle.com> - 2015-06-29 10:56 +1000
  Re: Showing picture in a form. "Phil" <phil@stantonfamily.co.uk> - 2015-06-29 09:00 +0100
  Re: Showing picture in a form. Dave W <davewi11@yahoo.co.uk> - 2015-06-29 12:42 +0100
    Re: Showing picture in a form. "Phil" <phil@stantonfamily.co.uk> - 2015-06-29 15:53 +0100
      Re: Showing picture in a form. Dave W <davewi11@yahoo.co.uk> - 2015-06-29 22:09 +0100
        Re: Showing picture in a form. "Phil" <phil@stantonfamily.co.uk> - 2015-06-29 22:45 +0100
          Re: Showing picture in a form. Dave W <davewi11@yahoo.co.uk> - 2015-07-01 10:01 +0100
            Re: Showing picture in a form. "Phil" <phil@stantonfamily.co.uk> - 2015-07-01 16:30 +0100
              Re: Showing picture in a form. Dave W <davewi11@yahoo.co.uk> - 2015-07-01 21:14 +0100
  Re: Showing picture in a form. "Ron Paii" <None@none.com> - 2015-07-01 16:09 -0500

csiph-web