I am new to Base. In the past I have do some programming in other environments. I followed a narrative and got through creating a form.
I am not sure if a have a problem with my paradigm used by Base Forms or with the way I put the form together.
I am use to maintaince programs that come up blank. You then enter data in the key field which then accesses the database (Table). If the record exists you go into maintaince mode and can change or delete the record. If the record is not found you go into entry mode.
When I open the form, the last data I entered is there. If I overtype the key field the form does not attempt to read the data for that key.
Any help would be appreciated.
Dahn
Maintaining data using forms
-
- Posts: 2
- Joined: Sun Dec 14, 2008 12:03 am
Maintaining data using forms
OOo 3.0.X on Ms Windows XP
Re: Maintaining data using forms
Your English is hard to understand, but let me try to help.
Is/are the "maintaince programs" you refer to really OpenOffice forms?
Tell me more about your "key field" you refer to.
Are you using any macros or programming of any kind in this form?
When you "overtype the key field" what are you expecting to happen?
Is/are the "maintaince programs" you refer to really OpenOffice forms?
Tell me more about your "key field" you refer to.
Are you using any macros or programming of any kind in this form?
When you "overtype the key field" what are you expecting to happen?
If someone posts a fix for your question, then please post a quick thank you and then go to your first post, use the edit button to add [Solved] as the first word of the title so other people can rely on the fix as well.
LibreOffice 3.3.3 on Fedora
LibreOffice 3.3.3 on Fedora
-
- Posts: 2
- Joined: Sun Dec 14, 2008 12:03 am
Re: Maintaining data using forms
I was expecting the program to access the record connected with this key field.Safway wrote:
"Is/are the "maintaince programs" you refer to really OpenOffice forms?"
No. The maintenance programs I am referring to are programs constructed in a traditional computer language for maintaining a database.
"Tell me more about your "key field" you refer to."
What would you like to know about the key field.
"Are you using any macros or programming of any kind in this form?"
NO.
When you "overtype the key field" what are you expecting to happen?
If I type in Dog (key field) into a database of animals, I would expect the data that corresponds to a dog to come up. If the data for cat was currently showing, and I type in dog, I am not trying to change the data for cat to be keyed with dog.
Re: Maintaining data using forms
Does this help: http://openoffice.blogs.com/forms_fromscratch.pdf ? It was created by Solveig Haugland who is one of those that has helped a lot of people with OpenOffice. Her site is http://openoffice.blogs.com/about.html .
If someone posts a fix for your question, then please post a quick thank you and then go to your first post, use the edit button to add [Solved] as the first word of the title so other people can rely on the fix as well.
LibreOffice 3.3.3 on Fedora
LibreOffice 3.3.3 on Fedora
Re: Maintaining data using forms
Solveig's tutorial is is very useful since the wizard way to create forms hides too much of the form's structure and the more advanced options you have when you recombine the features to something new.Safway wrote:Does this help: http://openoffice.blogs.com/forms_fromscratch.pdf ? It was created by Solveig Haugland who is one of those that has helped a lot of people with OpenOffice. Her site is http://openoffice.blogs.com/about.html .
There is one built-in method which works with all types of databases.snowcranebooks wrote:If I type in Dog (key field) into a database of animals, I would expect the data that corresponds to a dog to come up. If the data for cat was currently showing, and I type in dog, I am not trying to change the data for cat to be keyed with dog.
Having a form which shows all records of a table or query respectively and the form contains a text box where the animal species is shown (e.g. "dog") you can set the boxe's property "Form Proposal" (Ctrl+Click box, context-menu:"Control...", tab:"Data").
When you open the form and turn on the form-based filter (toolbar "Form Navigation"), you see the box replaced by a listbox with all species. Pick your "dog" and possibly some other criteria and leave the form-based filter.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Maintaining data using forms
Another thought that came to my mind after rereading your comment "If I type in Dog (key field) into a database of animals, I would expect the data that corresponds to a dog to come up" then are you referring to the functionality that subforms provide?
A somewhat antiquated subform how to is located at http://documentation.openoffice.org/HOW ... meters.pdf . Also, here is another how to that might be of help: http://www.linux.com/articles/37087
A somewhat antiquated subform how to is located at http://documentation.openoffice.org/HOW ... meters.pdf . Also, here is another how to that might be of help: http://www.linux.com/articles/37087
If someone posts a fix for your question, then please post a quick thank you and then go to your first post, use the edit button to add [Solved] as the first word of the title so other people can rely on the fix as well.
LibreOffice 3.3.3 on Fedora
LibreOffice 3.3.3 on Fedora
Re: Maintaining data using forms
The problem with subforms is, that you change the value of the bound field when you pick "dog" from a list since the field needs to be bound to a table of data. 99% of all users want list boxes as filter proposals rather than bound fields and do not understand how this matter of course is implemented in Base.Safway wrote:Another thought that came to my mind after rereading your comment "If I type in Dog (key field) into a database of animals, I would expect the data that corresponds to a dog to come up" then are you referring to the functionality that subforms provide?
A somewhat antiquated subform how to is located at http://documentation.openoffice.org/HOW ... meters.pdf . Also, here is another how to that might be of help: http://www.linux.com/articles/37087
Alternatively, my quick and dirty example database http://user.services.openoffice.org/en/ ... hp?id=2954 binds one filtering box to a field in a helper table "Filter" where it filters the other form by means of a WHERE clause rather than a form filter. The stored filter value can be also used to show only the respective records in other forms or reports.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice