Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2006

    Unanswered: Postinge Name and Image from MS Access 2000 Database on Vb Form.

    I am creating a database in MSAccess for my Payroll Program I am writing. I want to save an image representing an employee in the record of each employee. I then want to post the name of each employee and the image I have save in each record of each employee on Visual Basic Form.

    How do I do this?

    I need your help.


  2. #2
    Join Date
    Sep 2003
    1 of 2 ways: Either embed the image itself as an Ole Object in the table and retrieve and reconstruct it on the fly and put in an image control or save a file link in the table and load the image from that file ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jul 2006
    M Owen,
    I am a newbie. Honestly I dont know how to save a file link in the table and load the image from that file.
    Kindly give me insight on this.


  4. #4
    Join Date
    Jun 2004
    Arizona, USA
    add a picturebox to a vb form.

    add code

    Set picture1.Picture = loadpicture ("c:\Test.Bmp")

    Now, double-click loadpicture, and press F1

    The second option takes quite a bit less code, BTW. (And, it avoids a lot os datafile bloat issues associated with storing images in Access database files.)

    By "file link," M_Owen means the path name of the file. "C:\Test.Jpg" is a file reference. It describes the entire pathname, so that you could retrieve the file and display it.
    Last edited by loquin; 02-19-07 at 15:44.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts