Prevent users from deleting rows in repeating table, but OK to rows. - InfoPath Dev Sign in | Join | Help in Microsoft Access InfoPath (Entire Site) InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads InfoPath Dev » InfoPath » Microsoft Access » Prevent users from deleting rows in repeating table, but OK to rows. Prevent users from deleting rows in repeating table, but OK to rows. Last post 10-21-2009 03:02 PM by Greg Collins. 1 replies. Page 1 of 1 (2 items) Sort Posts: Oldest to newest Newest to oldest Previous Next 10-16-2009 09:56 AM Unreal1998 Joined on 08-18-2009 Posts 13 Prevent users from deleting rows in repeating table, but OK to rows. Reply Contact I have an infopath form connected to an access db and I have a repeating table in infopath. How do I prevent the users from accidently hitting the delete key and submitting to the database and deleting the record? Of course I want them to be able to add new records. Another dilema: And what is the user inserts a row by mistake, shouldn't there by a delete option or a perhaps a field with a void checkbox and some rules. 10-21-2009 03:02 PM In reply to Greg Collins Joined on 08-07-2006 Posts 2,126 Re: Prevent users from deleting rows in repeating table, but OK to rows. Mark as Not AnswerMark as Answer... Reply Contact To prevent the deletion, you can do one of two things: 1. Manually edit the myschema.xsd file and set minOccurs="1" for the specific table row node. 2. Write code which determins whether the row can be deleted and not allow the deletion if it can't. Please Visit:BraintroveGreg's Paintings Page 1 of 1 (2 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.
I have an infopath form connected to an access db and I have a repeating table in infopath. How do I prevent the users from accidently hitting the delete key and submitting to the database and deleting the record? Of course I want them to be able to add new records.
Another dilema: And what is the user inserts a row by mistake, shouldn't there by a delete option or a perhaps a field with a void checkbox and some rules.
To prevent the deletion, you can do one of two things:
1. Manually edit the myschema.xsd file and set minOccurs="1" for the specific table row node.
2. Write code which determins whether the row can be deleted and not allow the deletion if it can't.