Form Error/No Recovery Mode

Creating and using forms
Post Reply
jpowerw
Posts: 1
Joined: Mon May 12, 2008 7:09 am

Form Error/No Recovery Mode

Post by jpowerw »

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
User avatar
DrewJensen
Volunteer
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Form Error/No Recovery Mode

Post by DrewJensen »

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.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
Post Reply