On 15/02/12 15:51, Fernand Vanrie wrote:
Many thanks to all who replied so quickly to this. The resources you
pointed me at soon provided answers or clues. By using the "Wizard" to
create a form, I got things working very quickly (I usually avoid
wizards) and by studying the form that was generated I worked out what I
needed to do to create the same sort of form in Design view.
On 15/02/2012 15:47, email@example.com wrote:
when creating a form, you must "connect" to a datasource and then use
a table, query or a sql statement to feed the form with data. When
using the form as a data-entry tool then you must have a datasource
who accept this
I apologise, because this feels like something that should be very
but I have not been able to find the answer for myself.
I can create a form in the LO database application and put fields
either through Insert>Field or by opening the Data Sources pane (F4) and
dragging and dropping fields from there to the form.
The only way I seem to be able to see actual data from the relevant
in my form is to select a row in the F4 pane and then press a button
it's called "Data to Fields". This puts the data from that row into the
What I would like to do though is link the form to the table and provide
the form with navigation widgets that allow the user to see teh data
any record by naviagting through the records. I see there is a toolbar
called "Form Navigation" which I can get to appear, but all the icons on
it are greyed out.
I guess my question is - how do I get this toolbar to work with my form
and table the way I expect it to?
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy