[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Robert Großkopf wrote > here the macro for saving data while opening or running Base: Thanks Robert, that's fantastic. I'll try it out later this week. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to:

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Thanks Robert, that's fantastic. I'll try it out later this week. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Hi Peter, here the macro for saving data while opening or running Base: SUB DatabaseBackup(inMax AS INTEGER) REM A copy of the databasefile *.odb would be created in the Backup-folder. REM The amount is limited to 5 copies. After it has reached 5 copies, the

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Robert Großkopf wrote > You could use the macro for copying the file to the backup-folder of LO > when opening the file. It's published in the Base-Handbook. I could post > it here also. That would be very useful Robert. I've found that the corruption is happening when I close LO. So saving when

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Thanks, but at the moment I'm making manual backups. Unfortunately (?) it hasn't happened again. Very frustrating. - Peter -- Sent from: http://nabble.documentfoundation.org/Users-f1639498.html -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

hi peter. if you are sure that your file is corrupted, just right click on it and find properties. in the security tab, find and select previous versions. then press okay button. it restores previous version (that worked properly for you). God bless you all. On 1/8/18, ptoye

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

I think that the first thing to do is to work out if the corruption's happening on loading or saving. It's easy to see what's happening as the corrupted file is of a very different size, so I can see it in Explorer. That at least will give me a handle on the problem. Then I can work out whether to

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Hi Remy, seems you haven't read the first mail of this thread: "If I try opening it in a Zip file reader I'm told it's not a valid Zip file." The way to repair a *.odb-file is described in the Base-Handbook in detail. But if you can't extract anything there you couldn't get data out of a

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Hi, This problem seems to have been observed not so long ago: https://ask.libreoffice.org/en/question/63369/repair-corrupt-odb-file/ The fix that is mentioned in that post is there: https://forum.openoffice.org/en/forum/viewtopic.php?f=83=17567 Not sure if the proposed solution will help, but it

Re: [libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Hi Peter, > > Both LO and Java are 64-bit versions. Is it a good idea to revert to 32-bit > versions? I'm not sure how LO decides which Java to use if given the choice; > I assume it picks up the same bit-version. Bugzilla doesn't show any obvious > connection between 64-bit and database

[libreoffice-users] Re: Database corruption since LO 5.7.3 installed

Thanks Robert. Restoring from a backup is exactly what I've been doing. But it's odd. It's a database I use about once or twice a week (depending on how much wine I've been drinking), and it's failed to open 4 times since then: the saved dates were 26 November, 24 December, 27 December and 5 Jan.

Re: [libreoffice-users] Re: Database help please

On Fri, Mar 4, 2016 at 3:13 PM, John Montgomery wrote: > Thank you to everyone who replied to my query, A01, A02 etc works, I am > very thankful for that. Now the problem to prevent duplication, I have > tried several ways but obviously what I am doing is incorrect as it

Re: [libreoffice-users] Re: Database help please

Thank you to everyone who replied to my query, A01, A02 etc works, I am very thankful for that. Now the problem to prevent duplication, I have tried several ways but obviously what I am doing is incorrect as it doesn't work. Could someone please do a very small database to show how this problem

[libreoffice-users] Re: Database help please

Le 02/03/2016 20:07, John Montgomery a écrit : Hi, > My problem arises when I enter double numbers eg A11, A20 etc, these should > follow in sequence but do not follow the sequence I want but A10 follows A1 > etc. > How can I ensure correct sequencing. As others have mentioned, you could try

[libreoffice-users] Re: Database Design

Le 17/11/2013 22:20, James E Lang a écrit : Hi James, I want to construct a database that will permit me to use eMail to send him a PDF file for a day's delivery list including instructions for driving the route. On a bad day I must be able to quickly apply as many as ~25 of these

[libreoffice-users] Re: Database error

Le 29/08/13 11:04, Andreas Kloss a écrit : Hi Andreas, I use Mac and have Libreoffice 4 download 2 day a go from your Server. Then I like to use the Database I get this error : SQL Status: 42000 Error code: 105 [Actual][SQL Server] Unclosed quotation mark after the character string

[libreoffice-users] Re: Database field on top of PDF document

Using the form with a transparent background a table with lots of rows columns to place the fields approximately where I wanted them in writer worked for me. It was a bear putting the fields where I wanted them and the long names writer generates make it difficult to see and place fields where

[libreoffice-users] Re: Database field on top of PDF document

Le 21/06/2013 20:46, howellsilverman a écrit : That is correct. These are forms that are available to me as pdf's without fillable fields. Even if the fields were fillable - I want to fill them from a database. I'm not the creator of these forms so I have to work backward from what I receive.

Re: [libreoffice-users] Re: Database field on top of PDF document

Alex Thurgood wrote: Le 21/06/2013 20:46, howellsilverman a écrit : That is correct. These are forms that are available to me as pdf's without fillable fields. Even if the fields were fillable - I want to fill them from a database. I'm not the creator of these forms so I have to work

[libreoffice-users] Re: Database field on top of PDF document

Le 21/06/2013 05:23, howellsilverman a écrit : Hi, When I try to move a database field on top of an image (or PDF object), writer won't let me place it on top of the image. Is there a way to put a database field on top of an image? If you try to insert the fields by dragging and dropping

[libreoffice-users] Re: Database field on top of PDF document

Ok thanks. I tried that. It worked. You need a form with a transparent background which took a little work with gimp ( http://www.ehow.com/how_8422694_remove-white-gimp.html). Then I used a table to place the fields where I wanted them.. So I can see a method to get this handled. What would be

Re: [libreoffice-users] Re: Database field on top of PDF document

To: users@global.libreoffice.org Sent: Friday, 21 June 2013, 16:12 Subject: [libreoffice-users] Re: Database field on top of PDF document Ok thanks. I tried that. It worked.  You need a form with a transparent background which took a little work with gimp ( http://www.ehow.com/how_8422694_remove

[libreoffice-users] Re: Database field on top of PDF document

Le 21/06/13 17:12, howellsilverman a écrit : Hi Howell, Ok thanks. I tried that. It worked. You need a form with a transparent background which took a little work with gimp ( http://www.ehow.com/how_8422694_remove-white-gimp.html). Then I used a table to place the fields where I wanted

Re: [libreoffice-users] Re: Database field on top of PDF document

@global.libreoffice.org Sent: Friday, 21 June 2013, 17:58 Subject: [libreoffice-users] Re: Database field on top of PDF document Le 21/06/13 17:12, howellsilverman a écrit : Hi Howell, Ok thanks. I tried that. It worked.  You need a form with a transparent background which took a little work with gimp ( http

Re: [libreoffice-users] Re: Database field on top of PDF document

Tom :) From: Alexander Thurgood alex.thurg...@gmail.com To: users@global.libreoffice.org Sent: Friday, 21 June 2013, 17:58 Subject: [libreoffice-users] Re: Database field on top of PDF document Le 21/06/13 17:12, howellsilverman a écrit : Hi Howell

Re: [libreoffice-users] Re: Database field on top of PDF document

: users@global.libreoffice.org users@global.libreoffice.org Sent: Friday, 21 June 2013, 19:16 Subject: Re: [libreoffice-users] Re: Database field on top of PDF document Piece of cake with Draw.  I've done it.  Now if the OP wants automation, I can't help there. Girvin Tom Davies wrote: Hi :) I

[libreoffice-users] Re: Database field on top of PDF document

:) From: Alexander Thurgood [hidden email]http://user/SendEmail.jtp?type=nodenode=4062498i=0 To: [hidden email] http://user/SendEmail.jtp?type=nodenode=4062498i=1 Sent: Friday, 21 June 2013, 17:58 Subject: [libreoffice-users] Re: Database field on top of PDF document Le 21/06/13 17:12

Re: [libreoffice-users] Re: Database field on top of PDF document

@global.libreoffice.org users@global.libreoffice.org *Sent:* Friday, 21 June 2013, 19:16 *Subject:* Re: [libreoffice-users] Re: Database field on top of PDF document Piece of cake with Draw. I've done it. Now if the OP wants automation, I can't help there. Girvin Tom Davies wrote

[libreoffice-users] Re: Database sort problem

Le 19/01/13 17:59, Ian Whitfield a écrit : Hi Ian, Message No Date 14901/01/13 58 02/01/13 15002/01/13 22502/01/13 26107/01/13 307

[libreoffice-users] Re: Database sort problem

On 01/19/2013 05:59 PM, Ian Whitfield wrote: Hi Ian, Message No Date 14901/01/13 58 02/01/13 15002/01/13 22502/01/13 26107/01/13 307

[libreoffice-users] Re: database

to Andreas Säger ville...@t-online.de Hallo Andreas, thank you for your short practical guide how to use a .dbf for serial letters. I spent a lot of time fiddling around reading books etc. and couldnt come up with a result. With your advice LO did what I want within some minutes. I never

[libreoffice-users] Re: database

Walther Koehler wrote to Andreas Säger lt;villeroy@gt; Hallo Andreas, thank you for your short practical guide how to use a .dbf for serial letters. I spent a lot of time fiddling around reading books etc. and couldnt come up with a result. With your advice LO did what I want

[libreoffice-users] Re: database

Le 20/04/12 23:01, Tom Davies a écrit : Hi Tom, The 3.5.x branch prefers java 1.7 and apparently that preference has been back-ported to 3.4.5 and also gone into the 3.4.6. For a Mac it's quite important to remove java 6_29 or was it 6_30 asap. Regards from Tom :) Please do not

[libreoffice-users] Re: database

Le 20/04/12 22:07, Elizabeth Lawrence a écrit : Hi again Elizabeth, I'm using Mac OS X 10.5.8. I am trying to start a new database and OK, I have Mac OSX 10.6.8, Snow Leopard. For me, the basic LibreOffice Base functionality works (within the confines of known issues, bugs, etc). Can you

[libreoffice-users] Re: database

On 2012-04-20 2:22 PM Steve Edmonds wrote: My mac tried to update my java the other day to V7 (1.7), I stopped it.. I think there were issues with this version and LO. Possibly someone can advise the state of compatibility with the different LO versions and Java. The update is to Java for

[libreoffice-users] Re: database

On 2012-04-20 3:01 PM Tom Davies wrote: The 3.5.x branch prefers java 1.7 and apparently that preference has been back-ported to 3.4.5 and also gone into the 3.4.6. For a Mac it's quite important to remove java 6_29 or was it 6_30 asap. Regards from JRE 1.7 has not been released for Macs.

[libreoffice-users] Re: database

Le 20/04/12 22:07, Elizabeth Lawrence a écrit : Hi Elizabeth, Further to my question regarding the version of Java on your system, it would appear from this link : http://support.apple.com/kb/HT1222 that the last update to Java for OSX 10.5 was made available on June 28, 2011 :

[libreoffice-users] Re: database

On 2012-04-20 8:39 AM Elizabeth Lawrence wrote: HI, I have downloaded libreoffice in order to use the database. I can bring up the database but the one I want use wont open the wizard for tables. I have tried to uninstall libreoffice twice but it wont go. My blood pressure is soaring -

[libreoffice-users] Re: database

Am 20.04.2012 16:39, Elizabeth Lawrence wrote: HI, I have downloaded libreoffice in order to use the database. I can bring up the database but the one I want use wont open the wizard for tables. I have tried to uninstall libreoffice twice but it wont go. My blood pressure is soaring - please

office politics Re: [libreoffice-users] Re: database

/4/12, Andreas Säger ville...@t-online.de wrote: From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: database To: users@global.libreoffice.org Date: Saturday, 21 April, 2012, 8:42 Am 20.04.2012 16:39, Elizabeth Lawrence wrote: HI, I have downloaded libreoffice in order

Re: [libreoffice-users] Re: database

Thanks for the clarification. Steve On 2012-04-21 19:02, Larry Gusaas wrote: On 2012-04-20 2:22 PM Steve Edmonds wrote: My mac tried to update my java the other day to V7 (1.7), I stopped it.. I think there were issues with this version and LO. Possibly someone can advise the state of

Re: [libreoffice-users] Re: database

wrote: From: Steve Edmonds steve.edmo...@pt-global.com Subject: Re: [libreoffice-users] Re: database To: users@global.libreoffice.org Date: Saturday, 21 April, 2012, 11:08 Thanks for the clarification. Steve On 2012-04-21 19:02, Larry Gusaas wrote: On 2012-04-20 2:22 PM  Steve Edmonds wrote: My

[libreoffice-users] Re: database

Am 20.04.2012 22:07, Elizabeth Lawrence wrote: Hi Nick, I'm using Mac OS X 10.5.8. I am trying to start a new database and trying to click on use Wizard to create table. It doesn't click properly and the suggestion of creating a table using the Wizard vanishes. I have to confess I haven't used

[libreoffice-users] Re: database

Le 20/04/12 16:39, Elizabeth Lawrence a écrit : Hi Elizabeth, I have downloaded libreoffice in order to use the database. I can bring up the database but the one I want use wont open the wizard for tables. I have tried to uninstall libreoffice twice but it wont go. My blood pressure is

Re: [libreoffice-users] Re: database

Hi Alex, Sorry I was so vague, when I start the database section and select tables, the Wizard comes up but disappears as soon as I try to click it. Sorry, not very technical language. Liz On 20 Apr 2012, at 17:55, Alexander Thurgood wrote: Le 20/04/12 16:39, Elizabeth Lawrence a écrit

Re: [libreoffice-users] Re: database

On 20 April 2012 18:08, Elizabeth Lawrence lawrence-elizab...@sky.com wrote: Hi Alex, Sorry I was so vague, when I start the database section and select tables, the Wizard comes up but disappears as soon as I try to click it.  Sorry, not very technical language. Liz That's a little bit

Re: [libreoffice-users] Re: database

Hi Nick, I'm using Mac OS X 10.5.8. I am trying to start a new database and trying to click on use Wizard to create table. It doesn't click properly and the suggestion of creating a table using the Wizard vanishes. I have to confess I haven't used Libreoffice before, but my Boss

Re: [libreoffice-users] Re: database

Hi. My mac tried to update my java the other day to V7 (1.7), I stopped it.. I think there were issues with this version and LO. Possibly someone can advise the state of compatibility with the different LO versions and Java. Steve On 2012-04-21 08:07, Elizabeth Lawrence wrote: Hi Nick,

Re: [libreoffice-users] Re: database

: From: Steve Edmonds steve.edmo...@pt-global.com Subject: Re: [libreoffice-users] Re: database To: users@global.libreoffice.org Date: Friday, 20 April, 2012, 21:22 Hi. My mac tried to update my java the other day to V7 (1.7), I stopped it..  I think there were issues with this version and LO

Re: [libreoffice-users] Re: database

#LibreOffice_Base_Guide Creating a database is not as trivial as writing a letter!  Regards from Tom :) --- On Fri, 20/4/12, Elizabeth Lawrence lawrence-elizab...@sky.com wrote: From: Elizabeth Lawrence lawrence-elizab...@sky.com Subject: Re: [libreoffice-users] Re: database To: users

Re: [libreoffice-users] Re: database or spreadsheet

On 12/02/2012 23:25, Jay Lozier wrote: On 02/12/2012 06:09 PM, Ron Johnson wrote: On 02/12/2012 01:52 PM, Gordon Burgess-Parker wrote: On 08/02/2012 12:57, James Knott wrote: Gordon Burgess-Parker wrote: On 07/02/2012 13:03, e-letter wrote: It is not known from the original poster _why_ the

Re: [libreoffice-users] Re: database or spreadsheet

On Mon, Feb 13, 2012 at 3:39 AM, Gordon Burgess-Parker gbpli...@gmail.comwrote: On 12/02/2012 23:25, Jay Lozier wrote: On 02/12/2012 06:09 PM, Ron Johnson wrote: On 02/12/2012 01:52 PM, Gordon Burgess-Parker wrote: On 08/02/2012 12:57, James Knott wrote: Gordon Burgess-Parker wrote: On

Re: [libreoffice-users] Re: database or spreadsheet

On 13/02/2012 15:27, jomali wrote: On Mon, Feb 13, 2012 at 3:39 AM, Gordon Burgess-Parker gbpli...@gmail.comwrote: On 12/02/2012 23:25, Jay Lozier wrote: On 02/12/2012 06:09 PM, Ron Johnson wrote: On 02/12/2012 01:52 PM, Gordon Burgess-Parker wrote: On 08/02/2012 12:57, James Knott

Re: [libreoffice-users] Re: database or spreadsheet

On 08/02/2012 12:57, James Knott wrote: Gordon Burgess-Parker wrote: On 07/02/2012 13:03, e-letter wrote: It is not known from the original poster _why_ the sheets needed to be changed. Jeeze. DOES IT MATTER? No of course it doesn't MATTER. When you try to provide computer support,

Re: [libreoffice-users] Re: database or spreadsheet

On 02/12/2012 01:52 PM, Gordon Burgess-Parker wrote: On 08/02/2012 12:57, James Knott wrote: Gordon Burgess-Parker wrote: On 07/02/2012 13:03, e-letter wrote: It is not known from the original poster _why_ the sheets needed to be changed. Jeeze. DOES IT MATTER? No of course it doesn't

Re: [libreoffice-users] Re: database or spreadsheet

On 02/12/2012 06:09 PM, Ron Johnson wrote: On 02/12/2012 01:52 PM, Gordon Burgess-Parker wrote: On 08/02/2012 12:57, James Knott wrote: Gordon Burgess-Parker wrote: On 07/02/2012 13:03, e-letter wrote: It is not known from the original poster _why_ the sheets needed to be changed. Jeeze.

Re: [libreoffice-users] Re: database or spreadsheet

On 02/12/2012 05:25 PM, Jay Lozier wrote: On 02/12/2012 06:09 PM, Ron Johnson wrote: [snip] We're not remote-sensing mind-readers. James Knott has a very valid point, one which I myself have suffered through over the decades: power user or newbie developer has skills inadequate to the task,

Re: [libreoffice-users] Re: database or spreadsheet

Gordon Burgess-Parker wrote: On 07/02/2012 13:03, e-letter wrote: It is not known from the original poster _why_ the sheets needed to be changed. Jeeze. DOES IT MATTER? No of course it doesn't MATTER. When you try to provide computer support, you'll often find someone is trying to

Re: [libreoffice-users] Re: database or spreadsheet

On 06/02/2012, Dan Lewis elderdanle...@gmail.com wrote: And it appears that you just explained why people will use spreadsheets (incorrectly perhaps) instead of a database. You just raised the bar too high for the average person. Why would anyone want to learn something as abstract as a

Re: [libreoffice-users] Re: database or spreadsheet

On 07/02/2012 13:03, e-letter wrote: It is not known from the original poster _why_ the sheets needed to be changed. Jeeze. DOES IT MATTER? No of course it doesn't MATTER. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

[libreoffice-users] Re: database or spreadsheet

Am 07.02.2012 16:52, Jay Lozier wrote: Most people are scared off by having to develop queries, particularly if they must use SQL. It is too much like programming to them and that tends to scare them; seemingly arcane rules and syntax that does not appear very flexible or easy to use. Some

Re: [libreoffice-users] Re: database or spreadsheet

On 02/07/2012 03:06 PM, Andreas Säger wrote: Am 07.02.2012 16:52, Jay Lozier wrote: Most people are scared off by having to develop queries, particularly if they must use SQL. It is too much like programming to them and that tends to scare them; seemingly arcane rules and syntax that does not

[libreoffice-users] Re: database or spreadsheet

Am 07.02.2012 21:57, Jay Lozier wrote: The irony is that most SQL queries are easier to understand because they reference tables and columns by name (out of necessity) and usually have a selection criteria that is makes contextual sense, such as vendor name. The above is not easy to follow or

[libreoffice-users] Re: database or spreadsheet

Am 07.02.2012 21:58, Paul D. Mirowsky wrote: I hope to to condense and reply to all. A person has spent arduous hours of entering/linking/formula-ing etc... on spreadsheets. It is not the optimum of data entry, as would be a database form. But it does do every thing they want it to. The

Re: [libreoffice-users] Re: database or spreadsheet

On Tue, 2012-02-07 at 22:59 +0100, Andreas Säger wrote: Am 07.02.2012 21:58, Paul D. Mirowsky wrote: I hope to to condense and reply to all. A person has spent arduous hours of entering/linking/formula-ing etc... on spreadsheets. It is not the optimum of data entry, as would be a

Re: [libreoffice-users] Re: database or spreadsheet

On 02/07/2012 04:18 PM, Andreas Säger wrote: Am 07.02.2012 21:57, Jay Lozier wrote: The irony is that most SQL queries are easier to understand because they reference tables and columns by name (out of necessity) and usually have a selection criteria that is makes contextual sense, such as

[libreoffice-users] Re: database or spreadsheet

Am 06.02.2012 18:24, Paul D. Mirowsky wrote: Everybody knows how write simple math statement as a formula. Everybody doesn't know how to right an SQL statement. My users can not fill out spreadsheets properly. They have no idea how to write formulas, they don't understand cell formats,

[libreoffice-users] Re: database or spreadsheet

Am 06.02.2012 19:22, Dan Lewis wrote: I wonder how many people who use LO have read chapter 8 of the Getting Started Gude, Getting Started with Base? I know that I have very seldom seen a comment about its contents. (I wrote it and am presently updating it. I'm also working on the Base

Re: [libreoffice-users] Re: database or spreadsheet

On Mon, 2012-02-06 at 19:51 +0100, Andreas Säger wrote: Am 06.02.2012 19:22, Dan Lewis wrote: I wonder how many people who use LO have read chapter 8 of the Getting Started Gude, Getting Started with Base? I know that I have very seldom seen a comment about its contents. (I wrote it

Re: [libreoffice-users] Re: database or spreadsheet

On 02/06/2012 02:45 PM, Dan Lewis wrote: On Mon, 2012-02-06 at 19:51 +0100, Andreas Säger wrote: Am 06.02.2012 19:22, Dan Lewis wrote: I wonder how many people who use LO have read chapter 8 of the Getting Started Gude, Getting Started with Base? I know that I have very seldom seen a

[libreoffice-users] Re: database or spreadsheet

Am 06.02.2012 20:45, Dan Lewis wrote: You obviously have a very in dept knowledges of database and can do many things with them that others can not do. But that does not mean others have to have a detailed knowledge of databases before they can create them. Not everyone has a need for a fairly