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

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

Re: Showing picture in a form.

Show all headers | View raw

On Mon, 29 Jun 2015 22:45:39 +0100, "Phil" <phil@stantonfamily.co.uk>
wrote:

>On 29/06/2015 22:09:50, Dave W wrote:
>> On Mon, 29 Jun 2015 15:53:55 +0100, "Phil" <phil@stantonfamily.co.uk>
>> wrote:
>> 
>>>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
>> 
>> Thanks for the info. I should not have said "copy and paste" because
>> the result would be a large bitmap. I fell into this trap when I added
>> pictures to a Word document.  Better to insert the picture from the
>> picture file. It would make the database larger, but then the picture
>> file could be deleted could it not?
>> 
>> I tried using the Image Control on my form instead of the OLE Object,
>> but when I typed the dot after it on the codepage, picture was not on
>> the list of possibles (Access 2003). Is there some Reference I have to
>> select?
>
>Very odd. Have checked and the Image Control was certainly in Access 2000 and
>2003. Are you sure you have inserted an image control?
>What methods were displayed after you typed the dot?
>Have you tried typing MyImageName.Picture and seeing if it compiles?
>
>Phil
>
>---
>This email has been checked for viruses by Avast antivirus software.
>https://www.avast.com/antivirus

When you say "Image Control", do you mean "Image" on the Toolbox, or
do you mean "Image Control Class" under "More Controls" on the
Toolbox? I used the latter, and it says "ActiveX Control:
ImageControl9" on Properties.  "Image" alone does indeed have a
Picture attribute.

"Image" needs an initial image to put it on the form, but I found I
could then delete the path to the image in Properties, making the box
invisible. I guess I could give it a default blank picture, but change
the path in code as discussed.

The Object Browser says that ImageControl is a class in
IMAGEVIEWERLib, which I have added to my References. The class has 28
members in its list and Picture is not one of them.
-- 
Dave W

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