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 <abo...@gmail.com> wrote: > On Sun, Jan 19, 2014 at 6:15 AM, Ernest Dale <ernest.dal...@gmail.com>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 >> >> <ernest.dal...@gmail.com> > > > If you haven't already found this link > https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide > 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 > > -- > Alan > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > 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 > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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