Results 1 to 3 of 3
  1. #1
    adornis is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    2

    Exclamation Complex Problem with Access 2007, Pls help.

    I've used access to do some simple things and know my way around a bit, but I need help from the experts now because the task I'm currently working on will require some code...

    I have a single table containing 10,000 rows of user data. The table headers are PersonID, Surname, FirstName, and MiddleName. However, there is a current need to add a column in which I intend to attach a passport photo to each of these 10,000 names.

    I currently have all 10,000 passport photographs (saved using each person's Surname, Firstname, Middlename, and PersonID in jpeg format) in a folder, but it is going to take forever to attach pictures one after the other. I know it is possible to write a script or module or something which would instruct MS Access to read the user data from the table, locate the picture folder, open the folder, search for the corresponding Surname, FirstName, MiddleName, and PersonID picture file, and attach this jpeg file to the correct row in the table.

    I would more than grateful for any assistance i can get.

  2. #2
    dblife's Avatar
    dblife is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Nov 2011
    Location
    South Shields, UK
    Posts
    88
    there is a small amount of code required.
    in the new column (field) record the pathway to the image for each person.. such as c:/image/person00023.jpg
    on the form where you want to show the image, create an unbound image box, called 'imgPictureBox' and put the following code inside the forms 'OnCurrent' event,

    me!imgPictureBox.picture=me!txtImagePath

    where txtImagePath is the path to the image for that record.

  3. #3
    adornis is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Dec 2011
    Posts
    2
    Quote Originally Posted by dblife View Post
    there is a small amount of code required.
    in the new column (field) record the pathway to the image for each person.. such as c:/image/person00023.jpg
    on the form where you want to show the image, create an unbound image box, called 'imgPictureBox' and put the following code inside the forms 'OnCurrent' event,

    me!imgPictureBox.picture=me!txtImagePath

    where txtImagePath is the path to the image for that record.
    The main problem here is that there are 10,000 different people, and i need to attach each person's picture to their record... It would take forever to do this for 10,000 records. Is there no easier and faster way of doing this?

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

Similar Threads

  1. Replies: 2
    Last Post: 06-18-2011, 09:55 AM
  2. Problem with Access 2007
    By HatterasSolutions in forum Access
    Replies: 2
    Last Post: 11-03-2010, 05:00 PM
  3. Dlookup Problem in Access 2007
    By doquan0 in forum Programming
    Replies: 1
    Last Post: 08-27-2010, 05:41 AM
  4. Problem with label in Access 2007
    By Madraykin in forum Forms
    Replies: 4
    Last Post: 02-04-2010, 10:41 AM
  5. Problem using the combo box Access 2007
    By PATATE in forum Access
    Replies: 11
    Last Post: 05-23-2009, 06:26 AM

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 - Senior Forums