Hello,
I have a problem with inserting pictures as objects in the database:
I am able to insert these pictures if working on XP/MSOffice2007 if the
format of the picture is only PSD.
when using Vista/MSOffice 2007 the picture is inserted but if the format is
just bmp.
When using Vista Home premium/MSOffice2007 (the office is French version) I
always have the icon not the content of the picture. I tried all the possible
formats but I always had the icon (I have set in the field properties that I
want it to inset the content not the icon). The database that I am conceiving
is dedicated for the system using Vista Home premium/MSOffice2007 (the office
is French version).
Thanks for your cooperation
zayan
strive4peace - 23 May 2008 19:02 GMT
Hi zayan,
instead of using an OLE control, try this:
make a field to hold the file path and name as text data type
on your form, use an Image control (mountains with sun icon) and specify
its ControlSource to be the field containing the file path and name
Image controls handle a wider variety of file types
Warm Regards,
Crystal
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
(: have an awesome day :)
*
> Hello,
> I have a problem with inserting pictures as objects in the database:
[quoted text clipped - 12 lines]
>
> zayan
Fred - 23 May 2008 20:08 GMT
Until this situation possibly changed with Access 2007, storing the file/path
(as Chrystal described) rather than embedding/OLE link was the ONLY viable
way. And I'd still consider it to be the best way.
Sounds like you can also fix your problem by upgrading your Vista to SP.
Personally, I'd do both.
> Hello,
> I have a problem with inserting pictures as objects in the database:
[quoted text clipped - 12 lines]
>
> zayan
Tony Cottle - 24 May 2008 10:37 GMT
> Hello,
> I have a problem with inserting pictures as objects in the database:
[quoted text clipped - 18 lines]
>
> zayan