Images in access forms

  • Thread starter Thread starter Robert Raley
  • Start date Start date
R

Robert Raley

I thought that what I want to do is simple.

I am using access 2003.

I have employee records. I want to add a photo of theirs to the form.

I have created a field in the table which is [image] The type is OLE
package.

I created a bound text box on the form with the control source as [image]

I can not copy the image into the form I can not copy the file into the
form. If I copy the file into the table [image] all I get is something that
says package. I looked it up and am being told that this means that the
image format is not supported the only format that is supported is BMP. The
image in bmp.

I tried following the instructions for put the links in but is very
complicated for something so simple.

Thanks all help will be appreciated.

Bob
 
Hi Bob-


It sounds like the problem is that you are trying to display an image in a
Text Box control. What you need to use on your Form or Report is a _Bound
Object Frame_ and designate your OLE (image) field as it's control source.

HTH |:>)

I thought that what I want to do is simple.

I am using access 2003.

I have employee records. I want to add a photo of theirs to the form.

I have created a field in the table which is [image] The type is OLE
package.

I created a bound text box on the form with the control source as [image]

I can not copy the image into the form I can not copy the file into the
form. If I copy the file into the table [image] all I get is something that
says package. I looked it up and am being told that this means that the
image format is not supported the only format that is supported is BMP. The
image in bmp.

I tried following the instructions for put the links in but is very
complicated for something so simple.

Thanks all help will be appreciated.

Bob
Click to expand...

-- (e-mail address removed)
 
That works great. The photo shoes up but as a little image of about 30 x 30
pixels with the file name below. It should be 90 x 90 with no file name. I
look for an adjustment but did not see one.

Thanks for the greet tip.

Bob


CyberTaz said:
Hi Bob-


It sounds like the problem is that you are trying to display an image in a
Text Box control. What you need to use on your Form or Report is a _Bound
Object Frame_ and designate your OLE (image) field as it's control source.

HTH |:>)

I thought that what I want to do is simple.

I am using access 2003.

I have employee records. I want to add a photo of theirs to the form.

I have created a field in the table which is [image] The type is OLE
package.

I created a bound text box on the form with the control source as [image]

I can not copy the image into the form I can not copy the file into the
form. If I copy the file into the table [image] all I get is something that
says package. I looked it up and am being told that this means that the
image format is not supported the only format that is supported is BMP. The
image in bmp.

I tried following the instructions for put the links in but is very
complicated for something so simple.

Thanks all help will be appreciated.

Bob
Click to expand...

-- (e-mail address removed)
Click to expand...
 
Robert said:
That works great. The photo shoes up but as a little image of about
30 x 30 pixels with the file name below. It should be 90 x 90 with
no file name. I look for an adjustment but did not see one.

Thanks for the greet tip.
Click to expand...

I use an Image box with type embedded and size mode set to zoom.

I have a field [PictureLoc] which contains the location of the actual image.
In the OnCurrent event for the form I have:

If Nz(Me!pictureloc, 0) = 0 Then
Me!pictureloc = "d:\volpics\cross.gif"
End If
Me![VolPic].Picture = Me![pictureloc]

The if statement was added because if there is nothing in PictureLoc or if
the file does not exist the last picture displayed stays on the form

I also have code which will run through d:\volpic\ and add new pictures.
 
Hi Bob,

I've come across the problem you've got with the image showing as a
thumbnail, with the filename below it. I asked about that in the
comp.database.ms-access newsgroup, but with little success. The only
response I got suggested a problem with an OLE provider.

Details of my post, and the reply (from Darryl Kerkeslager) are as follows:
=====
Using Access 2002:
I have downloaded a tutorial database, which has a form containing a
bound object frame to display a picture. The picture field in the
underlying table has an OLE Object datatype, and when a picture is
inserted (either directly into the table, or via the form), the table
entry contains the term "Package". The pictures which are available
to be inserted into the database (as steps in the tutorial) are .bmp
files. My problem is that the form displays both the picture (in a
small "thumbnail" format) and its filename (only the filename - the
path is not included) in the bound object frame. I've never seen this
behaviour before (I've got several databases which display pictures,
via several different methods), and I can't find any obvious property
which is causing this behaviour. BTW, the supplied .bmp files contain
only a picture - the text is not part of the image!
Click to expand...

The problem is related to OLE providers. I saw this once before I stopped
using any type of OLE picture placement with bound object frames. As I
recall, I fixed the problem by repairing the MS Image Editor in Office,
which had gotten flakey on one PC. After determining that I did no want
my app to be hostage to quirks caused by image-editing products trying to
steal file associations from each other, I searched this newsgroup and
decided to use unbound image controls instead. Of course, this also
solved the whole database bloat issue associated with storing images in
the database.
=====

I didn't bother following this up any further, since placing images in an
Access database itself is an extremely bad idea - it leads to horrendous
"bloating" (increase in file-size). You are much better off simply storing
a link to an external image file, along the lines suggested in Mike
Painter's response. For further discussion and alternative techniques, see
http://www.mvps.org/access/forms/frm0030.htm

HTH,

Rob


Robert Raley said:
That works great. The photo shoes up but as a little image of about 30 x 30
pixels with the file name below. It should be 90 x 90 with no file name. I
look for an adjustment but did not see one.

Thanks for the greet tip.

Bob


Hi Bob-


It sounds like the problem is that you are trying to display an image in a
Text Box control. What you need to use on your Form or Report is a _Bound
Object Frame_ and designate your OLE (image) field as it's control source.

HTH |:>)

I thought that what I want to do is simple.

I am using access 2003.

I have employee records. I want to add a photo of theirs to the form.

I have created a field in the table which is [image] The type is OLE
package.

I created a bound text box on the form with the control source as [image]

I can not copy the image into the form I can not copy the file into the
form. If I copy the file into the table [image] all I get is
Click to expand...
Click to expand...
something
that
Click to expand...
BMP.
The

-- (e-mail address removed)
Click to expand...
Click to expand...
 
Back
Top