Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Import/Link Pictures into a table

    I am trying to import or link objects (specifically pictures) into a database table. I want to match up pictures of our parts with the part # so I can create a report that will contain both the part # and picture of the part. There are too many parts to go to each one in the table and link it to the file. Any ideas or suggestions would be appreciated as I am at a dead end. Thanks.

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Storing images in an Access db is usually a bad idea--it bloats the size of the MDB, and makes the file more prone to corruption.

    A typical solution is to store the images outside the mdb, and in the table to store a tring that is the path to the file where the image is stored.

  3. #3
    Join Date
    Mar 2006
    Posts
    2
    I was trying to import the path to the pictures into an object field. I still could not get it to work. I then tried to write a program to enter the path into the field which did not work either.

  4. #4
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Here is some code from a report I developed. In the report, there is a textbox, PictureURL, that holds the path to a stored image file, and an image control, Image7, where the picture goes:

    Code:
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    
        On Error Resume Next
        
        Me![Image7].Picture = Me![PictureURL]
        
        On Error GoTo 0
        
    End Sub

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

Similar Threads

  1. Link ComboBox to field in a table
    By DrDebate in forum Forms
    Replies: 0
    Last Post: 04-27-2007, 08:03 AM
  2. Link table using MAC PC file sharing problem
    By TaiYipStreet in forum Access
    Replies: 0
    Last Post: 07-19-2006, 08:02 AM
  3. link excel form to access table
    By data123 in forum Import/Export Data
    Replies: 6
    Last Post: 06-23-2006, 10:17 AM
  4. Import multiple dbf files into existing table?
    By sbg2 in forum Import/Export Data
    Replies: 0
    Last Post: 06-12-2006, 02:06 PM
  5. Unable to import or link tables through odbc in Access SP2
    By Dave Jenkins in forum Import/Export Data
    Replies: 3
    Last Post: 11-09-2005, 11:51 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