Toolbars grayed out in forms

[paulaha]

Hi,

After creating a table and a form Im now trying to add information in my form but the form Navigation toolbar and the form design toolbar are grayed out.
Can write data in the fields but cant save it. After entering all the data in the fields the cursor goes back to field number one?? What did I do wrong?

paula

[r4zoli]

It can not be that, Form navigation toolbar active when you in data input mode, and Form design Toolbar in Edit mode.
After data input click on Save record icon on form navuigation toolbar, or next record icon.

[paulaha]

Thanks for reply,
The problem is that the save record icon on form navuigation toolbar, or next record icon is grayed out. Cant press them???

[r4zoli]

Possibly your table not has a primary key.
Open your table in edit mode, and check it one of the fields needs to be marked with small key, before field name.
If you not have it, add key to one of the fields which will contain data not repeating, or add new field ID with integer type and set Autovalue to yes.

[paulaha]

Have three different forms and with one of them it worked with what you said about putting a primary key.. The others two dont??!!
The icon "new record" and "save record" in the forms are grayed out. Can enter data in the forms but cant save it? Can i have done something wrong when creating the forms?
Really appreciate your help!

[r4zoli]

Can you upload your database, here, to look into?

[paulaha]

How do I upload the database?

[r4zoli]

[Forum] How to attach a document here

[paulaha]

Hi,

Wanted to send you the table and form in sql so that you can run it but i dont know how to do?

[r4zoli]

Please make a copy of your odb file, delete all data from it and upload odb file.

[paulaha]

Hi,

The two ones that I have problem saving data is "contracts" and "potentiel suppliers"

Thanks for your time to help me!

[r4zoli]

"Contracts" table not has a primary key. Second needs to be investigated.

[paulaha]

Hi,

Cant add a primary key to "contracts". See attachment of the error message..
Have tried to add a primary key to the different fields but still the same message..

[r4zoli]

Memo field can not be set as primary key, add ID and set as Integer, Autovalue=Yes .

Another problem is similar bug described in issue 111295.

How you created this database, on what OS and in OOo version?

Can I add your file as example?

[paulaha]

Hi,

When I try to set ID, integer and autovalue I get an error message. See attachment. What did I do wrong there?

I have Windows Vista and OOo version is 3.2.
Yes, its ok, you can add my file as an example!
Thanks for all your help!

[r4zoli]

Update to OOo 3.2.1, I can add it with this version.

[paulaha]

Should I download (http://download.openoffice.org/) 3.2.1? Cant find anywhere to update OOo. Doesnt my data disappear if I download the new version?

[r4zoli]

Should I download (http://download.openoffice.org/) 3.2.1?
Cant find anywhere to update OOo.

Yes.

Doesnt my data disappear if I download the new version?

Your data folder will not hurt during download and installation.

Best to unistall 3.2 first and after that install 3.2.1