Posts by Paroxuno

    Hello,
    I have a form linked to a Sharepoint list which works great, the only problem I have is that if you close out of Access (using the X on Access itself), it submits any partial data that has been entered into the form. In the form itself I have submit and close buttons and the x for the form is disabled. The submit buttons within the form have code tied to them to validate that the needed fields have been entered.


    I have no code tied to any 'on close' event for the form. How do I prevent any data from being recorded when someone closes Access using the x button?
    I do not believe I am able to use an 'on close' event either, since one of my buttons submits the data, closes the form, and opens a new one.


    Thank you.

    Hello,


    Thank you for your help in advance. I have a Sharepoint list that I would rather use Access as my interface for instead of Sharepoint's forms. I have a simple list in Sharepoint, it's 7-8 columns and each form adds a new row to the list. In general I have the form created and everything works except for the attachment. In Sharepoint, the same form can hold attachments just fine and post them to the same new row without any issues, but when I try to do the same thing with Access, it gives me the 'Attachment cannot be added until a new row has been committed.' error. This error comes up as soon as you click to add an attachment, as if it is trying to add the attachment to the Sharepoint list right then. The Sharepoint form seems to hold the attachment and add it when it adds the rest of the information to the row, I need Access to do the same thing.


    Is there a way to tell Access just to hold on to the attachment until it commits the rest of the information to the row?


    Thank you.