Pergunte aqui

Perfil de John99 - atividade

2019-04-19 15:39:42 +0200 Medalha recebida  Pergunta famosa (fonte)
2018-12-10 23:33:24 +0200 Resposta comentada How to reset table of contents settings for individual document

Thanks for the revised reply. I will look again at how my problem document was set up. Thanks for the tip about Index

2018-12-09 12:56:48 +0200 Medalha recebida  Pergunta notável (fonte)
2018-12-09 10:23:51 +0200 Pergunta comentada LO .odt won't open Panic!

Have you got any backups ? My Libre Office makes its own backups by default they are stored in a hidden folder, but mine

2018-12-08 19:33:58 +0200 Medalha recebida  Pergunta popular (fonte)
2018-12-08 19:17:41 +0200 Respondeu uma pergunta Export base queries to .sql

Not a batch export method but I wonder if this is any less labour intensive: "You copy a table from Base to a new Calc

2018-12-08 18:58:14 +0200 Pergunta comentada Why can't I open LO ver 6.0?

Probably will help to know your OS including the version, AND whether it is a 32 bit or 64 bit OS, and which JRE you act

2018-12-08 18:48:16 +0200 Pergunta editada How to reset table of contents settings for individual document

How to reset table of contents settings for individual document I am trying to fully reset the Table Of Contents settin

2018-12-08 17:42:44 +0200 Pergunta editada How to reset table of contents settings for individual document

How to reset table of contents settings for individual document I am trying to fully reset the Table Of Contents settin

2018-12-08 16:10:37 +0200 Perguntou How to reset table of contents settings for individual document

How to reset table of contents settings for individual document I am trying to fully reset the Table Of Contents settin

2017-01-07 15:05:07 +0200 Medalha recebida  Pergunta famosa (fonte)
2015-01-08 23:23:03 +0200 Medalha recebida  Entusiasta
2015-01-02 10:52:19 +0200 Medalha recebida  Professor (fonte)
2015-01-02 04:01:34 +0200 Medalha recebida  Pergunta notável (fonte)
2015-01-02 03:41:04 +0200 Respondeu uma pergunta Base - How to open a record from a table form?

Forms are used mainly to enter data. Tables are where the records exist.

I am not aware of a method of moving directly from a record in table to that record in a form. Of course I may be wrong I am a newbie with Base. Presumably you have discovered that you may directly edit records in tables, you do not need to go to a form to do that. If you are in a form and have a lot of records another tip is to key in record numbers, instead of using the navigation arrows, as it can be much quicker if the record required is not at the start or end.

2015-01-02 03:05:58 +0200 Respondeu uma pergunta How can I recover accidentally deleted document?

This does not sound good. I am not sure there is too much you can do other than learn form the experience.

If you have actually deleted it then act as quickly as possible and try not to use the computer until you attempt a recovery with some sort of suitable utility. Do a web search for suitable software. (One I have heard of success with is recuva )

I am not sure what exactly you did LibO Writer file menu does not include a delete option. Windows deletions unless you explicitly use a delete option often go to the Recycle bin.

( I have made the presumption you are using Windows - Mac s & Unix often have Trash icons not Recycle icons ) It is also worth searching the computer for the document in case you mis named it or put it in the wrong location.
If you need tips on how to search look at this and the advanced tips

A different subject, but maybe you should review your backup procedures. I guess you do not have any regular backup policy for your documents. If you knew it was going to be 12 hours work you could have used LibO file -> save copy option to make a backup every 1/2 hour or so. Another method would have been to set LibO to always make bacup copies, Tools -> Options -> Load/Save -> General [] Always create backup copy

2015-01-01 16:45:14 +0200 Medalha recebida  Pergunta popular (fonte)
2015-01-01 14:15:36 +0200 Medalha recebida  Editor (fonte)
2015-01-01 14:11:24 +0200 Respondeu uma pergunta Explained: Incomprehensible base tutorial (Automobile fuel)

I also asked this question on another forum so for an explanation and links to other tutorials about Base & sql see those answers

The tutorial example file I used is as suspected rather incomplete and the query I referred to is not finished.

2014-12-31 17:03:00 +0200 Perguntou Explained: Incomprehensible base tutorial (Automobile fuel)

Edit Update Corrected some typos I will if possible add "explained" as a prefix to the thread title.

I must be missing something that should be obvious. I seem to be seeing way more records in the query than I expect. The guides & file are all sourced from or linked directly from the Document Foundation site. It might help if I knew I had database file that definitely matched the tutorial.

I am a complete newbie to Base but I have previously used other database programs without issues. This is slightly dated, as I note the v4.2 guide only covers flat not relational databases. I have briefly read the LibO & Base guides but am still rather baffled by the tutorial. The tutorial may well have diverged and been modified over time, that hardly helps, but I seem unable to locate any better copy.

If I open the tutorial database and use tables I see tables including "Vacations", "Payment type" & "Fuel" with no filter applied I look at the data and the first two tables have only 2 or 3 records. The Fuel Table has 8. (These may not agree with the tutorial figures and oddly have identical odometer readings, unrealistic & unexpected but no matter ) Using Tools -> Relationships I discover a 1:n relationship on Date between Vacations:Fuel Tables

Now is where I start to have a problem following what is happening. I look at Queries Queries -> End-Readings This has 8 records as expected. Queries -> Fuel Economy This has 56 records I do not understand that.

I wonder if anyone is able to help by explaining what is going on here, and maybe even has the correct file that matches the tutorial.

I am using Base 4.2, looking at Chapter 8 of the Libre Office Getting Started Guide for LibO v4.0 and the tutorial file linked from the Document Foundation

I an using Windows 7 at the moment. I also have Ubuntu 12.04 & 14.04 on this machine, not sure which LibO versions they currently use.