Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2008

Tip: Looking for answers? Try searching our database.

problem with linking pictures

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
zayan Kab - 23 May 2008 11:45 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.