The client has an Access 2007 application with a form for creating tasks for upload to the Sharepoint task list. The user fills out a form (name, status, priority, start date, due date). Then the user places checkboxes next to the sharepoint user names to which this task should be assigned (one task for each user is selected). This data is bound to the TaskQueue table, and tasks are added to the Sharepoint list successfully (through the linked list - I think). The problem is that we need to include zero or more attachments for each element of the task. Is there a way to do this with a macro, VBA, or some other built-in functions that I haven't learned about yet?
My initial idea was to use the Windows C # service, which controls this task table, then use the List.asmx Shareopint web service and the AddAttachment method when the list item ID and NTFS path to the attached file are specified to add attachments to the list item tasks in Sharepoint.
After playing with Access and creating a related table in the Task List in Sharepoint, I found that you can add attachments through the Access 2007 datasheet view. The problem is that you can only select one user or SP group in the Assigned TO field. They have many repetitive tasks to assign a bunch of individuals. That is why they developed this form. If anyone has an idea on how to solve this problem, please let me know. Also does anyone know any good Access 2007 / Sharepoint integration resources?
Thanks in advance!
source
share