Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


Well, I write lots of notes for /myself/, as I don't like to trod the same jungle path more than once (and there's a lot of jungle out there!).

I'm headed over to the website right now to get involved formally.

Thanks for the encouragement.

t.

On 06/17/2011 12:20 PM, planas wrote:
Tom

On Fri, 2011-06-17 at 02:22 -0600, Tom Cloyd wrote:

Just found the answer. I may be misleading myself at times due to [a]
prior experience of several years duration with MS Access, and [b] my
being very new to LO base.

What doesn't work is to add text box control to a form and specify their
data, in their properties, as a field in the main table. Do that and you
get the problem I outlined below.

What does work is, in design mode, to select the grid control, then
click the "add field" icon in the toolbar at page bottom, THEN select
from this list desired fields.

NOW I have data showing up in ALL text boxes on the form. Lovely!

Tom

  On 06/17/2011 01:06 AM, Tom Cloyd wrote:

I'm new to LO base (I'm using the default HSQLDB), and having a pretty
good time with it so far, but have run into something I don't
understand, and cannot find documentation about.

I have a form with a main db displayed in a grid control. Linked to it
is a detail db displayed in a subform. So far, so good.

I want to pull out some fields from each db for display in text boxes.

With the subform, this is a necessity, if I am to have full access to
the data in a memo field.

With the main form, pulling out data into a text field (two of them,
actually) is more a matter of giving visual emphasis to the contents
of the fields involved.

So...two dbs, two forms, and I want data from each db shown in text
boxes.

The problem: When I specify the record data to be shown in one db's
text boxes, then do the same with the other, the settings in the first
disappear. Either, alone, work fine. When both are specified, only the
last one I specify "sticks" and actually shows up in the displayed
form. The problem is entirely consistent. After many tried to get
things to work, the problem remains.

This seems nuts to me, but it occurs to me that it may be a limitation
of LO or HSQLDB.

Can anyone shed some light on my problem, or perhaps suggest a solution.

Thanks in advance for any help you can give!

Tom Cloyd

Thanks for the notes, they are very useful for documentation of Base for other users.




--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.