Results 1 to 6 of 6
  1. #1
    agernada is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    3

    Image Attachment links breaking after restart

    Hi all,

    I've searched the forums for this problem but can't find it so apologies if it appears somewhere.

    I've created a basic access table/form/report and inserted some image attachments into a field within the table.

    These are linked to an image frame on the form (and also report) and when I am within Access they all flow through fine.

    However, when I close and reopen access, the images don't appear - I have to re-add only one of the ~50 image links in the table view (even though it already appears in the attachments window) and then all of them start showing again.



    Any help appreciated.

    Cheers
    A

  2. #2
    atuhacek is offline New
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Location
    Michigan
    Posts
    61
    Might be able to help but I would need to see how you have it set up.

  3. #3
    agernada is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    3
    Thanks!

    Ok so I have these fields in my table set up as attachments:

    Click image for larger version. 

Name:	saved in fields.jpg 
Views:	5 
Size:	21.7 KB 
ID:	16953

    Within them, I add images:
    Click image for larger version. 

Name:	sources.jpg 
Views:	5 
Size:	38.5 KB 
ID:	16954
    In my form, I have 3 image frames that are linked to one of the image fields (in the below case, field 1) with the following properties:
    Click image for larger version. 

Name:	field properties.jpg 
Views:	5 
Size:	108.3 KB 
ID:	16955

  4. #4
    atuhacek is offline New
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Location
    Michigan
    Posts
    61
    How is your firm getting the data. Is it going through a query, connected to the table, or vba. Is the form. What are the form settings. Single form, continuous, data entry. Are you importing then into access or linking them?

  5. #5
    agernada is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2014
    Posts
    3
    The form is getting the information directly from the table - it's linked.

    The form is a single form.

    All data was entered into the table initially but now it's just entered directly into the form and new information is saved every time.

    THe only information entered into the table still are the pictures in the form of attachments.

  6. #6
    atuhacek is offline New
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Location
    Michigan
    Posts
    61
    Without a sample of the database I'm not sure I can help you. Maybe check your form properties and make sure you don't have it set for data entry.

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

Similar Threads

  1. Form Attachment Default Image Cut Off
    By breakingme10 in forum Forms
    Replies: 2
    Last Post: 06-06-2014, 12:45 PM
  2. Replies: 2
    Last Post: 01-29-2014, 11:55 AM
  3. Replies: 5
    Last Post: 04-29-2013, 04:23 PM
  4. Replies: 0
    Last Post: 01-11-2011, 06:12 PM
  5. Restart auto number after deleting records
    By P5C768 in forum Database Design
    Replies: 1
    Last Post: 09-11-2009, 02:07 PM

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