I get an "entry required" error when entering a record into my form after tabing the last field. It's the same error that the gentleman on the website ShowMeDo gets on the OpenOffice video #6 "Creating a listbox". The major differences is that his goes into recovery mode and recovers whatever it is that it needs. He says not to worry about it and just keep clicking OK or Yes until you are back in the form section. In my case OpenOffice does not try to recover anything. The error keeps coming up after tabing the last field, and the only way out of the form is to click No on the Save dialog box. Clicking Save does not save the record; it also brings up the same error.
Can anyone help?
Thank you,
Wayne
Form Error/No Recovery Mode
- DrewJensen
- Volunteer
- Posts: 1734
- Joined: Sat Oct 06, 2007 9:01 pm
- Location: Cumberland, MD - USA
Re: Form Error/No Recovery Mode
Hi
The situation comes up if you have a required field in a table, base the form on the entire table but do not display the actual field in question. ( at least that is one way it comes up )
Under OO.o 2.4 you will find a new property for Base files that allow you to turn off the check for required fields on forms.
With the Base file open select Edit>Database>Advanced Settings.
You will see the property: Form data input checks for required fields.
Remove the tick mark. The error should go away.
Now - this setting is database wide ( just this Base file ) and may not be what you really want. The other way to address this is to use a query to get only the fields you need for the form, not a full table when it is not needed.
Let us know if that helps, OK.
The situation comes up if you have a required field in a table, base the form on the entire table but do not display the actual field in question. ( at least that is one way it comes up )
Under OO.o 2.4 you will find a new property for Base files that allow you to turn off the check for required fields on forms.
With the Base file open select Edit>Database>Advanced Settings.
You will see the property: Form data input checks for required fields.
Remove the tick mark. The error should go away.
Now - this setting is database wide ( just this Base file ) and may not be what you really want. The other way to address this is to use a query to get only the fields you need for the form, not a full table when it is not needed.
Let us know if that helps, OK.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04