Restrict Deletion/Cutting of Sections

[StartekAP]

I have a form where I need people to be able insert sections but I need to
restrict them from deleting them.

I have gone in and removed the menu options for removing the section.
However, they can still click the top left icon and choose cut. You can also
highlight the section and hit your delete button to remove the data.

How do I keep them from doing this? Do I need to add some VBScript to the
form? Should this be done on the Access side? I am worried about doing this
in Access as the users are many and will change frequently and will not be
able to update Users in Access.

If there was a way to keep them from deleting existing records through
InfoPath 2003 that would be great.

I have tried to mess around with AllowDeletions = False but can not seem to
get it to work or perhaps putting it in the wrong place.

All help is welcome! Thanks!

 

[Rajitha]

Hi,
If you don’t want to delete all the records which were inserted then follow
below procedure.
1. Open form in design mode and go to the properties of Repeating Section.
2. Click on Modify button which is right side of ‘Sections that can be
inserted’ section.
3. Then Section Properties window will be opened and then click on Customize
Commands button.
4. Section Commands window will be opened.
5. Select Remove from Action drop down list box and uncheck the ‘Shortcut
Menu checkbox’.
6. Click on Ok until all the windows closed.

 

[StartekAP]

Thanks for the info. I have done this and there are no options on any menus
to delete a section.

However if you click in a section it highlights that section. If you then
click delete on the keyboard it removes the section and will delete the
record if submited. Cut is also available on the shortcut menu which still
gives the user the ability to CUT a section out.

Are there more tools in InfoPath to restrict this behavior or should I focus
on Access to build security in the database to keep certain users from being
able to delete records?

If so, is there a way to pass that user info to the database through
existing InfoPath 2003 data connection tools or must it be done through code?

Thanks for all of the help!