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

Hi :)
Can Base directly connect to a Lotus Approach database and use it as
the back-end?

@Ernest, Have you still got access to the old Windows and thus the
Lotus Approach directly or was this an upgrade (or a machine exchange
or some sort)?  I take it you exported the data as a ".csv" file and
that is what is looking like a flat spreadsheet?

Alan B's way of making a form sounds like the best as it should allow
easy data-entry.  If you need people to be able to access it in only
read mode then it might be good to make a form in Writer so that they
have all the tools they are familiar with

Regards from
Tom :)

On 19 January 2014 13:31, Alan B <> wrote:
On Sun, Jan 19, 2014 at 6:15 AM, Ernest Dale <>wrote:

... I appear to have succeeded but the result
is what looks like a spreadsheet and I cannot find a way to display one
record at a time.

As already suggested filtering can limit the number of rows that are
displayed. If you prefer to see the data in a form (which shows only one
record at a time regardless of filtering) rather than what appears to be a
row in a spreadsheet...

1. Open your LO Base database.
2. Select "Forms" from the column of icons on the left side of the window
3. In Tasks, near the center top of the window, select either option. I
suggest selecting "Use Wizard to Create Form..."
4. Use the options in the Wizard to create a form that displays one record
at a time.
    -- Form arrangement options are in step 5 of the form wizard. Chose any
"Arrangement of the main form" options *except* "As Data Sheet"

... I could do with
a simpler manual than the one I have found on the web which is hundreds of
pages long and I cannot copy the sections which look as thought they might
be helpful. Can you help?
Ernest Dale


If you haven't already found this link
it connects to several varieties of documentation. A full manual which you
apparently found and several smaller guides as well.

I don't have any idea what is causing your problem "...I cannot copy the
sections..." The link provided above goes to user guides in both PDF and
ODT format. Individual pages can be printed from any of these documents.
And, anything in those documents can be copied using the usual method
- select with mouse
- right click selection
- click copy
- go to destination
- paste copied text/image into destination


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.