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 / New Users / October 2005

Tip: Looking for answers? Try searching our database.

Search a folder then add Image

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Daryl M - 06 Oct 2005 01:50 GMT
Hey folks,

I've read again and again NOT to add an image in an OLE field.  Not a problem.
I got it.

My JPEGS are on the same disk as the database.  This database is for a bunch
of comic books I acquired after an eviction.  I have a form that displays the
appropriate info for any particular comic and it has an image control that
displays the cover via the oncurrent event.  Works GREAT.  The underlaying
table has the fields: ImagePath, and ImageNam.  

Problem is, I need a form very similar to this one for data entry.  I would
like to double click or right click on the image control open the folder with
the images, choose an image by say double clicking and Viola, access will add
the name of the selected photo to tblComic.ImageNam.

Any suggestions greatly appreciated.
Wayne Morgan - 06 Oct 2005 07:00 GMT
You can use the code example found here
http://www.mvps.org/access/api/api0001.htm to browse for the picture file
and return its path and name so that you can store those in the database
field.

Signature

Wayne Morgan
MS Access MVP

> Hey folks,
>
[quoted text clipped - 19 lines]
>
> Any suggestions greatly appreciated.
 
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.