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 / Database Design / July 2005

Tip: Looking for answers? Try searching our database.

How do I add a picture in a database for my staff ID Cards?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Be kind to help an Afghan boy!!! - 05 Jul 2005 12:44 GMT
I am creating a database for my office members.  I want to make a table to
store my office member information (contact details, fame, etc...) and I want
to make a form where I can easly walk around my staff and keep updating the
info, in this form (or another form) I also want to have the ID cards of my
staff automaticly created as I fill in the table (which OKAY to do this), I
did till here and it was good but, I want this database to store the pictures
of my staff so that the ID does not remaines without a photo.  What can I do
to add a picture in my staff ID card's form,  the picture to be stored in the
same database and if a change comes to the picture (some one leaves and the
other come) I want to delet the previous picture and add a new picture so two
command bottons are required as ADD PICTURE and DELET PICTURE.

As I am in a country where finding solution is not easy (Afghanistan) I
kindly ask an experts to help me with this question (problem) out.

Will thank you for any help, guidance, advice and wisdom,

Faheem,
Data tracker for a local demining agency
Lynn Trapp - 05 Jul 2005 13:13 GMT
Faheem,
It is not advisable to store your picture in the database, as this can cause
the database to grow significantly in size. Rather, simply store the path to
your pictures in some text field in the database. The Northwind database,
which ships with Access, has an example of how to display the pictures when
you need to.

Signature

Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

>I am creating a database for my office members.  I want to make a table to
> store my office member information (contact details, fame, etc...) and I
[quoted text clipped - 24 lines]
> Faheem,
> Data tracker for a local demining agency
 
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.