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 / Forms / February 2008

Tip: Looking for answers? Try searching our database.

Step by Step approach to Adding an Image to Forms in 2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rogerscmg@gmail.com - 01 Feb 2008 16:09 GMT
I really need to learn how to add images into individual records in
access 2003 forms, i have tried a few sites regarding this topic but
cannot seem to find one that outlines the process for beginners.  Can
anyone post a link or perhaps help with a walk through?  I would
appreciate a walk through from start to finish if there is such an
article
fredg - 01 Feb 2008 17:54 GMT
> I really need to learn how to add images into individual records in
> access 2003 forms, i have tried a few sites regarding this topic but
> cannot seem to find one that outlines the process for beginners.  Can
> anyone post a link or perhaps help with a walk through?  I would
> appreciate a walk through from start to finish if there is such an
> article

Store all your pictures in a folder on your hard drive.
In your table, store just the picture name and it's extension (i.e.
AuntTillie.jpg)  in a regular text field named [PictureName].

Add an Image control to the form (in the Detail Section?)
Note: You'll need to select any image picture to get the control to
'stick'. Then delete the control's picture property. When prompted
click OK. When done the Image Picture property should read (none).

Code the Form's Current event:
If Not IsNull([PictureName]) Then
      Me!ImageName.Picture = "c:\folderpath\" & [PictureName]
      Me![ImageName].Visible = True
Else
    Me!ImageName].Visible = False
End If

If the pictures are stored in various different folders, then include
the path to the folder in with the [PictureName] field in the table.
Change the above code from:
Me!ImageName.Picture = "c:\folderpath\" & [PictureName]
to
Me!ImageName.Picture =  [PictureName]
Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

 
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.