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

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

Re: Showing picture in a form.

Show all headers | View raw

On 01/07/2015 10:01:12, Dave W wrote:
> 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.

Hi Dave

I mean the Image on the Design toolbar, not the ActiveX. 
I have never used Access 2003 but with Access 2010 there is a Design Toolbar
which has things like TextBox, ComboBox, Option group etc. 
There is a down arrow at the right hand side of the toolbar, with the Image
Control (& Bound object Frame) The default picture for the image is (none) -
lower case and inside brackets.

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