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

[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

 

[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.

 

[Guest]

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

 

[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

 

[Guest]

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

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

 

[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