Results 1 to 4 of 4
  1. #1
    eninen7 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    2

    How to set an image for a photo directory

    I am developing a photo directory for my company so we can have a picture beside the employee's names. I downloaded an online templete known as 'Contact List' and I have inserted the infor I want to show, however, under my "picture" column I am unable to set the field to Image. (actually, I can set any of the columns to image)



    So, how can I have my picture column display as an image for my contacy directory?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    I wouldn't store the pictures in the database. I would have a folder to store all of the pictures.
    Then, in your database Contact table, I would have a column that shows the picture id. Then on the form to show then contact I would have a button that, when clicked
    would open the photo.
    You can do that with a FollowHyperlink, or you have an image list.

    I don't have access2007, but I have used these techniques with Acc2003.
    Good luck

  3. #3
    eninen7 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    2

    id is set. need to print with pictures showing.

    I can set the pictures as you said, however, when I go to print the database, the photos do not show up, which is the whole point of the database. We went to make copies of the company directory that includes each persons photo. So, how does set up work?

    Quote Originally Posted by orange View Post
    I wouldn't store the pictures in the database. I would have a folder to store all of the pictures.
    Then, in your database Contact table, I would have a column that shows the picture id. Then on the form to show then contact I would have a button that, when clicked
    would open the photo.
    You can do that with a FollowHyperlink, or you have an image list.

    I don't have access2007, but I have used these techniques with Acc2003.
    Good luck

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    How do you "print the database"?

    You could check this from M$oft

    http://support.microsoft.com/kb/285820

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Directory Database
    By bwaters in forum Access
    Replies: 1
    Last Post: 10-29-2010, 05:51 AM
  2. Active Directory coding
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-28-2010, 08:33 PM
  3. Change image directory
    By amer in forum Access
    Replies: 3
    Last Post: 06-09-2010, 07:01 AM
  4. Make directory or folder
    By thart21 in forum Programming
    Replies: 1
    Last Post: 04-07-2010, 05:37 PM
  5. New directory with the name from field
    By np1111 in forum Programming
    Replies: 14
    Last Post: 02-25-2010, 07:06 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums