Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Adding Images to a form - I realy need help with this

Discussion in 'Information Technology' started by Pizza, Jul 28, 2006.

  1. Pizza

    Pizza
    Expand Collapse
    Guest

    when i insert a image into the OLE objest the picture and its name appear in
    the box i only wnt the picture. Please help
     
  2. Loading...

    Similar Threads Forum Date
    1984 Images Revisited - YouTube History of Sikhism Nov 2, 2016
    He’s The World’s Best Water Photographer… And He’s Just Released These Haunting Images. Sikh Sikhi Sikhism Aug 30, 2015
    Nature Caterpillars Morph into Butterflies in Amazing 3D Images Breaking News May 15, 2013
    SciTech Rare images beyond the naked eye Breaking News Oct 23, 2010
    Heritage Old Paintings and Images of Lahore (British Library Collection) History of Sikhism Sep 29, 2010

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi

    If your picture is "bound" you "don't" add the picture to the OLE directly
    on the form. You load (or link) into the table.

    Let me / us know
    Where the picture is stored (if you know it the path would be a help)
    The name of the table and field where the path is stored
    The name of the form
    The name of the OLE field

    Off to lunch now so someone else will prob answer you as it's a common
    request - if not I will check again in a hour.

    In the meantime do a search on this forum on Picture or JPEG, OLE and you
    will find loads of answers.


    --
    Wayne
    Manchester, England.



    "Pizza" wrote:

    > when i insert a image into the OLE objest the picture and its name appear in
    > the box i only wnt the picture. Please help
     
  4. Pizza

    Pizza
    Expand Collapse
    Guest

    Thank you very much. i am presenting this DB tomorow to Management :-}

    "Wayne-I-M" wrote:

    > Hi
    >
    > If your picture is "bound" you "don't" add the picture to the OLE directly
    > on the form. You load (or link) into the table.
    >
    > Let me / us know
    > Where the picture is stored (if you know it the path would be a help)
    > The name of the table and field where the path is stored
    > The name of the form
    > The name of the OLE field
    >
    > Off to lunch now so someone else will prob answer you as it's a common
    > request - if not I will check again in a hour.
    >
    > In the meantime do a search on this forum on Picture or JPEG, OLE and you
    > will find loads of answers.
    >
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "Pizza" wrote:
    >
    > > when i insert a image into the OLE objest the picture and its name appear in
    > > the box i only wnt the picture. Please help
     
  5. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Here is a cut-and-past which I hope you find useful – cut and paste as this
    question gets asked quite a lot.
    _________________________________________________
    To display photos on a form you may use a number of different methods to
    produce the pictures and there are two options for how the pictures are
    stored. (well 3 actually if you count sticking the picture to your screen)
    Also there are a number of ways that you can view your picture (these are
    normally either as an OLE object on a form or as an image within a report).

    You will need first to have a picture file in a format or type that Access
    will accept these are: bmp, gif and jpg. They are others but these are the
    most common. If you are able to scan or take your own photos then the
    easiest format to use would be bmp (bitmap).

    To link to the pictures using a module and a bit see the detailed
    description on
    http://support.microsoft.com/kb/285820/en-us unusually for the MS site
    modules this one is quite straight forward to load and use.

    To embed the pictures

    Create a field called “picture†as an OLE type in your table. Right click
    [picture] and select Insert Object. You will have 2 choices – Create From
    File & Create New. To create from file simply click the button and then
    browse to your file (If you wish to embed the picture in the D Base select
    leave the Link option empty. If you wish to leave the picture where it is
    and simply be able to view the picture (Thumbnail) on a form or report (this
    will obviously reduce the size of the D Base) then click the Link Option.
    Assuming that you want to embed a NEW picture - this way if you transfer the
    file (by CD, Disk, Stick, E Mail, etc) then elect BMP as the file type. This
    will normally open the Windows Picture Manager. Select Paste From (on the
    Edit menu) and browse to your picture. Select Update Details (on the File
    menu) and then close the page. You picture will now be stored in the table.

    Step – by - step

    Make copies of the pictures you want to link to your records - that why if
    you get it wrong you don't mess up the pictures ?? (on C Drive / hard disk)
    and save them as
    ThumbnailPicture1,
    ThumbnailPicture2,
    ThumbnailPicture3,
    etc, (or use the ID of the record in the table)

    If you have a picture processing programme such as Photoshop or Photopaint
    then use that to resample and convert. If you don’t have one of these
    programmes:

    1 Click start
    2 Click My Pictures (if that’s where they are)
    3 Right click the picture and select “Open Withâ€
    4 Select Windows Office Picture Manager
    5 After the picture is open click the Picture Menu then select Resize
    6 Resize your picture to the correct size
    NOTE. You will need to know the pixel size of your OLE box - see below
    7 SaveAS a copy of the original (DON’T JUST SAVE or you will ruin the
    original picture)

    BMP Windows Bitmap this is best option
    GIFF CompuServe Bitmap is also OK
    JPEG’s “will†work but they are not really meant for this type of
    application REMEMBER that JPEG’s are reducing formats – so each time you
    change and save you will lose some resolution.

    Create an OLE field in the table (use this OLE field on your form if you
    wish to display the picture on a form with a particular record)


    To link your picture thumbnail with the OLE
    8 Open the Table that will hold the data /picture (not the form)
    9 navigate to the OLE field on the correct record and Right Click
    10 Select Insert Object
    11 Select Create From File and then Bitmap and then check the Link option
    12 Browse to your picture and select it
    13 Click OK
    14 “Package†will appear in the field. Save and close the table.
    15 View your image on the form


    Some notes on the size of your OLE object – regardless of what anyone will
    tell you there is no way of converting pixels to cm’s – which your OLE object
    will be sized in, UNLESS you know the size of each pixel or even the screen
    resolution and as screens are all different sizes and resolutions this simply
    isn’t possible here, so I have given the APPROXIMATE conversions here you
    will have to gig about with your thumbnail until it fits your OLE. Better
    still save all the thumbnails as size that you’re happy with and resize your
    OLE to fit this. On a screen resolution of 1024 Pixels X 768 (this is
    standard High Res for a lap top)
    5mm = 118 Pixels or 14.173 Points
    1cm = 236 Pixels or 28.346 Points
    So you can work out that say 3.5cm would be 827 Pixels or 99.213 Points


    Hope this helps and points you in the right direction

    --
    Wayne
    Manchester, England.



    "Pizza" wrote:

    > Thank you very much. i am presenting this DB tomorow to Management :-}
    >
    > "Wayne-I-M" wrote:
    >
    > > Hi
    > >
    > > If your picture is "bound" you "don't" add the picture to the OLE directly
    > > on the form. You load (or link) into the table.
    > >
    > > Let me / us know
    > > Where the picture is stored (if you know it the path would be a help)
    > > The name of the table and field where the path is stored
    > > The name of the form
    > > The name of the OLE field
    > >
    > > Off to lunch now so someone else will prob answer you as it's a common
    > > request - if not I will check again in a hour.
    > >
    > > In the meantime do a search on this forum on Picture or JPEG, OLE and you
    > > will find loads of answers.
    > >
    > >
    > > --
    > > Wayne
    > > Manchester, England.
    > >
    > >
    > >
    > > "Pizza" wrote:
    > >
    > > > when i insert a image into the OLE objest the picture and its name appear in
    > > > the box i only wnt the picture. Please help
     
  6. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Check this link on "How to include a bound picture on form"

    http://www.databasedev.co.uk/bound_image_form.html

    --
    Good Luck
    BS"D


    "Pizza" wrote:

    > Thank you very much. i am presenting this DB tomorow to Management :-}
    >
    > "Wayne-I-M" wrote:
    >
    > > Hi
    > >
    > > If your picture is "bound" you "don't" add the picture to the OLE directly
    > > on the form. You load (or link) into the table.
    > >
    > > Let me / us know
    > > Where the picture is stored (if you know it the path would be a help)
    > > The name of the table and field where the path is stored
    > > The name of the form
    > > The name of the OLE field
    > >
    > > Off to lunch now so someone else will prob answer you as it's a common
    > > request - if not I will check again in a hour.
    > >
    > > In the meantime do a search on this forum on Picture or JPEG, OLE and you
    > > will find loads of answers.
    > >
    > >
    > > --
    > > Wayne
    > > Manchester, England.
    > >
    > >
    > >
    > > "Pizza" wrote:
    > >
    > > > when i insert a image into the OLE objest the picture and its name appear in
    > > > the box i only wnt the picture. Please help
     
  7. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Offer

    Thanks for the link. I just set up a small trial and it works really well.
    Good call.

    Most of the db's I work with use the standard ms module and it's quite
    glitch free . A few of the smaller db's that I have made for my mates use
    the embedd method but I'll but I'll keep that link for future reference

    --
    Wayne
    Manchester, England.



    "Ofer Cohen" wrote:

    > Check this link on "How to include a bound picture on form"
    >
    > http://www.databasedev.co.uk/bound_image_form.html
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Pizza" wrote:
    >
    > > Thank you very much. i am presenting this DB tomorow to Management :-}
    > >
    > > "Wayne-I-M" wrote:
    > >
    > > > Hi
    > > >
    > > > If your picture is "bound" you "don't" add the picture to the OLE directly
    > > > on the form. You load (or link) into the table.
    > > >
    > > > Let me / us know
    > > > Where the picture is stored (if you know it the path would be a help)
    > > > The name of the table and field where the path is stored
    > > > The name of the form
    > > > The name of the OLE field
    > > >
    > > > Off to lunch now so someone else will prob answer you as it's a common
    > > > request - if not I will check again in a hour.
    > > >
    > > > In the meantime do a search on this forum on Picture or JPEG, OLE and you
    > > > will find loads of answers.
    > > >
    > > >
    > > > --
    > > > Wayne
    > > > Manchester, England.
    > > >
    > > >
    > > >
    > > > "Pizza" wrote:
    > > >
    > > > > when i insert a image into the OLE objest the picture and its name appear in
    > > > > the box i only wnt the picture. Please help
     

Share This Page