Re: Icon in stead of image
- From: Pete I <Pete I@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 23 Nov 2005 09:51:02 -0800
I am gettting the same problem since I "upgraded" to access 2003 from 97.
Bitmaps which were inserted when I was using 97 are fine - they are stored as
bitmaps and display correctly. However, any bitmaps added since are stored as
Packages and display as Icons with the filename. This occurs even if I copy
the bitmap into the table directly using copy/paste and open (actually the
menu option is now "activate") the Package from the table directly.
I don't have any fancy image packages installed, which might try to take
over responsibility for .bmps so bitmaps open with the Microsoft Office
Picture Manager.
In Hope
"lars" wrote:
> Thanks,
>
> The image is of course stored in an OLE Object datatype format in the table
> and it works fine using Access 2000, but not in Access 2002 and 2003. I also
> tried using an Access 2000 database instead of the SQL Server database. It's
> the same problem.
>
> If I open the table in the Access 2000 databas where it is stored and look
> in the OLE Field of the new record that I just stored it says 'Package'. If I
> look in older records previously stored in erlier versions of Access it says
> 'Paintbrush Pictures' or 'Bitmat Image'. If I then open my form the
> 'Paintbrush Pictures' or 'Bitmat Image' records show the image but the new
> 'Package' record only shows and icon.
>
> When inserting a new image I use the Action property of the Bound Object
> Fiels, i.e.
> Me!BildOLE.Action = acOLEInsertObjDlg
> and browse to a bmp-file on the disk.
>
> /Lars
>
>
> "Larry Linson" wrote:
>
> >
> > "lars" <cld@xxxxxxxxxx> wrote in message
> > news:365FB974-265C-42FF-BF94-38AFFDF4AFA1@xxxxxxxxxxxxxxxx
> > >I have stored a bmp image in a SQL Server 2000 image-field, but when I try
> > >to
> > > show it using a bound object frame (DisplayType=content) on a Access 2002
> > > Project Form it is shown as an icon in stead of an image.
> > >
> > > I understand that you don't need any special installed graphic filer for
> > > bmp-files.
> >
> > You shouldn't need any special filters for .BMP.
> >
> > Your image must be stored as an OLE Object in order to be displayed in a
> > Bound Object Frame... there's example code for doing so in Access (which
> > should probably work on a linked table in SQL Server, but may not work
> > without modification in an Access project) in the downloadable imaging
> > examples at http://accdevel.tripod.com.
> >
> > Your display of the image can also be affected by whatever software is
> > registered for the image type, and many image processing software suites
> > just arbitrarily reassign graphic file types to themselves.
> >
> > Larry Linson
> > Microsoft Access MVP
> >
> >
> >
.
- Prev by Date: Re: Adding multiple subform fields to a mail item in Access
- Next by Date: Re: Adding multiple subform fields to a mail item in Access
- Previous by thread: Field too small (linked table based on oracle view)
- Next by thread: Update Subforms/Popup
- Index(es):
Relevant Pages
|
