Results 1 to 5 of 5
  1. #1
    PWood is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    3

    Question Attachments to Forms

    Hi need some help. (Access 2007)



    I have form with field where I can upload attachments, however when i open it the "add" and "remove" functions are dimmed. In the related table I have no problem adding or removing attachments only in the form.
    What could be the problem?

    PWood

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Are you able to edit other data on the form? Could the form AllowEdits property be set to No?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    PWood is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    3
    Actually no, I can not but in the property sheet for the form " allow edits" is set to "yes"

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Is the form RecordSource just the table or a query?

    I just tested an attachment field on a form and worked fine. Would have to analyse your project if you want to provide it.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    PWood is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    3
    Hi June7,
    Problem solved. It was two fold, on one of the linked tables, the "index property" was set incorrectly (should be "yes(no duplicates)" and on the actual form the "data entry" property had to be set to "No".
    Thanks for your assistance, PWood.

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

Similar Threads

  1. Attachments
    By JayX in forum Access
    Replies: 5
    Last Post: 12-27-2011, 03:08 PM
  2. attachments
    By chiefmsb in forum Forms
    Replies: 3
    Last Post: 08-08-2011, 11:25 AM
  3. attachments
    By chiefmsb in forum Forms
    Replies: 0
    Last Post: 07-12-2011, 07:32 AM
  4. attachments
    By chiefmsb in forum Access
    Replies: 0
    Last Post: 07-08-2011, 03:56 PM
  5. Attachments
    By cjp78 in forum Access
    Replies: 4
    Last Post: 05-11-2010, 07:30 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