[libreoffice-users] Data base problem
I have a lenova T400 with two data bases. One is still available, but the second appears to have disappeared. I get the following messaes: The connection to the data source "Financial" couls not be made. The driver class "could not be loaded. ./connectivity/source/drivers/jdbc//Jconnection.cxx.685 The driver class "could not be loaded. ./connectivity/source/commontools/dbexception.cxx:413 Can I recover the data base and if so how? Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Forms
Thanks. That worked. Regards Peteg On 9/7/24 15:39, Robert Großkopf wrote: Hi Peter, open the form for editing, not for input data. Click on a field of the form. Right mouseclick → Form properties → Data Choose the new table. Save the form. Regards Robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Forms
How do I change the table that a form displays. I have a standard form which I use to display financial data. Each year I create a new table which I link to a copy of the standard form. I have forgotten how to link the new table to copy of the standard form. ( my excuse is I am 89 and the memory is not what it was) Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users]
A simple spread sheet is all you need - 5 columns , date, time, stystolic, diastolic and pulse rate. In my case a a diabetic i also have a column for sugar level. I can send you a copy of the form I use if you want. Regards Peter Goggin On 19/4/23 03:01, Serena Clooney wrote: Hi I wonder if you could please help me. We have been asked to record my 92 yr old mum's blood pressure readings at home and to present the results in spreadsheet form to our GP. Can anyone help with a Libreoffice template to help record these daily readings,please? Many thanks Srena -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Libre Office Base
I have read with interest the comments about Libre Office. Over the years I have managed large (100 Million records and small databases ( 1 million records or less) using Oracle, running in Unix machines. I have also developed a number of small ( less than 100,000 records ) using a variety of data base software (e. g. Paradox, Dbase, MS Access etc ). Over the last few years, since I retired I have run Oracle on Linux. Mysql, and now Libre Base. For my current needs I have found Libre Base more than adequate. I use straight out of the box and use its internal data base engine. I currently run four data bases, the largest has about 10,000 records. I have found it possible to produce the reports I need and the data summaries etc just as easily as I could in MS Access or even Oracle. The developers deserve congratulations on producing this product. If I were forced to pay for MS products I would have to stop my computing since XP is no longer supported and I cannot afford to buy the latest windows and associated software. Like all software Libre Base has its quirks and the documentation probably needs improving but overall it is a very useful product. If problems occur it is well worth reading the available documentation and then if the solution is not obvious e-mail the list. Regards Peter Goggin -- 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
Re: [libreoffice-users] Re: Where is Base?
Much of the e-mails on Base have focussed on negative aspects. It is worth remembering that for moderate size data bases (a few thousand records, a dozen tables) it is perfectly adequate. I have now converted all of my data ase applications for MS Access to run on Base with its internal data base. All of them perform better than they did using MS Access. I would not regard either Base or Access as suitable for a large multiuser data base application. The only linux based large data base I have developed I used MySQL with a web based front end using php to interface to the data base. Regards Peter Goggin -- 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
Re: [libreoffice-users] Re: Where is Base?
I have read with interest the emails on Base. I have always regarded the data base component of Open Office, Libre office as the equivalent to the datbase component of MS Access. I have 5 data bases, originally run under windows and MS Access which I have converted to run under Libre Base. I have found the LibreBase is probable slightly easier to use than MS Access and it certainly copes very well with my data bases, all of which are small. (The biggest has about 5000 records) The only problem I have had is in a new database where I needed to store photos against each record. It quickly gave up after about 4 records. I am not certain why, but other claims on my time have prevented me for investigating what caused the problem. I was a database administrator for many years with extremely large data bases (millioms of records) using Oracle, etc. When I needed to manage a large data base (about 100,000 records, 30 to 40 users) in linux, I used MySQL with web based front end using PHP to connect to the database. My advice to people needing to use databases is to use Base for small databases (less than 1 records). For larger bases consider using Mysql with a web based front end and PHP to connect to the databse. Regards Peter Goggin -- 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
Re: [libreoffice-users] mongodb and base
in the successful implementation of a project involving large amounts of data and a number of users. Over the years I have been involves in the design and implementation of a number of data base systems involving large amounts of data ( many millions of records) and many users (in excess of 100). Without the steps outlined above such systems are extremely unlikely to be successfully developed. By the way if your clients do require lots of special ad hoc reports SQL provides a convenient way of developing them. Regards Peter Goggin -- 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
Re: [Solved] Re: [libreoffice-users] Setting Base to open with a slected form
The solution to getting LibreBase to open with a particular form involves several steps: 1. Create a macro /Sub Menu_Main( ) Dim ObjTypeWhat Dim ObjName As String ObjTypeWhat = com.sun.star.sdb.application.DatabaseObject.FORM ObjName = MainMenuForm 'The name of the form you want to open at Base start-up, this needs to exist. If ThisDatabaseDocument.FormDocuments.hasbyname(ObjName) Then 'Check the form exists ThisDataBaseDocument.CurrentController.Connect() 'If the form exists connect to the database ThisDatabaseDocument.CurrentController.loadComponent(ObjTypeWhat, ObjName, FALSE) 'Open the form Else MsgBox This is embarrassing, sorry, can't find the requested form to open!+chr(10)+Form Name = ObjName + chr(10)+Check the details. , 48, DS4A SBM encountered a problem! End if End Sub/ 2. Call the macro when the data base is opened: From the top tool bar select: Toolscustomiseopendocument Add macro Main_menu to this selection. When the data base is opened there is a delay of about 1 second before the form named in the macro opens. This isn't quite as fast as Access, but in many other areas I found LibreBase to be more intuitive and than MS Access. I was able to convert my data bases from Access to LibreBase with all of the functionality the original Access databases, including reports, and in some cases with improved functionality. Regards Peter Goggin On 05/11/14 12:51, Mark LaPierre wrote: Hey Tom, It would be nice to post the solution here on the string that is labelled [Solved] so that people searching for the solution can find it. Maybe Peter should do that since he seems to have a better grip on the solution. On 11/04/14 04:33, Tom Davies wrote: Hi :) Peter has let me know, off-list, that he solved the problem. Details are sketchy (ie i didn't understand) but he's working on the Base Handbook at the moment so this is a distraction. Anyone who fancies their chances of being able to proof-read a chapter or 2 would be a huge help in getting the Base Handbook published more quickly. Most chapters have been reviewed (tested for technical accuracy) already and been kinda proof-read once but a final round of proof-reading would help reassure those who have been involved with getting the guide/handbook this far. There are still a few chapters that need reviewing but it's tough work so just proof-reading those already done would be great and could be done by almost anyone. Regards from Tom :) On 3 November 2014 21:40, Tom Davies tomc...@gmail.com wrote: Hi :) Has anyone had any luck trying to find the thread Noel was referring to? Is it possible to give a link to specific threads? Has anyone here been able to convert a database from Access? Has anyone been able to set-up a database file so that when it opens it goes straight to a main form instead of into a design view? Is this something that might be better done using a form that is made in Writer? Regards from Tom :) On 27 October 2014 09:26, Marion Noel Lodge lodg...@gmail.com wrote: Hi Peter, This question was asked recently. If you go to - http://www.libreoffice.org/get-help/nabble/ and search for How to open a particular form at startup you will find the thread. Noel -- Noel Lodge lodg...@gmail.com On 27 October 2014 19:08, Peter Goggin petergog...@bigpond.com wrote: I have completed the conversion of my Access contacts data base to LibreBase. The only problem I have not solved is to get the database to open with my main menu form. This could easlly be set in MS Access ut so far I cannot find the mechanism for doing this in Base. Is rhere a way of doing this? Or do I have to open the data base and manully select the for i want to start with? Regards Peter Goggin -- 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 -- 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
Re: [libreoffice-users] Printing Reports from BASE
On 28/10/14 15:01, Marion Noel Lodge wrote: Hi Peter, A macro similar to this should do what you want - Sub PrintReport() ThisDatabaseDocument.ReportDocuments.getbyname(name of your report).open() End Sub Then edit your Menu form, double click on the Print button and under Events | 'Mouse button pressed', link the button to the PrintReport() sub. Then when you run your application, clicking on the button should fire your report. Noel -- Noel Lodge lodg...@gmail.com On 28 October 2014 13:24, Peter Goggin petergog...@bigpond.com wrote: I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- 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 Thanks for the suggestion. However all the subroutine does is display the report on the screen. I want to be able to send it to the printer without first displaying it on the screen. So far I cannot see any reference on how to doi this. Regards Peter Goggin -- 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
[libreoffice-users] Setting Base to open with a slected form
I have completed the conversion of my Access contacts data base to LibreBase. The only problem I have not solved is to get the database to open with my main menu form. This could easlly be set in MS Access ut so far I cannot find the mechanism for doing this in Base. Is rhere a way of doing this? Or do I have to open the data base and manully select the for i want to start with? Regards Peter Goggin -- 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
[libreoffice-users] Printing Reports from BASE
I have a report run from a push button on a menu form. I can print it from the screen, but in Access I was able to program a push button to print id directly. Is this possible in BASE? I cannot find any reference to this. Regards Peter Goggin -- 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
[libreoffice-users] Date manipulation
I want to set a date range in a query to be between TODAY -10 Days and TODAY + 10 days. Is there a simple way to do this? Regards Peter Goggin -- 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
Re: [libreoffice-users] Re: Open .accdb in--or convert to--.odb in LibreOffice Base?
On 08/10/14 19:25, Werner wrote: Hi, On 10/7/2014 20:46, m. nease wrote: Hello, I'd like to do some work on Access databases (.accdb files) but haven't been able to access(!) them using Base (and have no MS OS or MS Office--happily). Is this possible? Some time ago I used the Microsoft SQL Server Migration Assistant for Access (http://www.microsoft.com/en-us/download/details.aspx?id=42656) together with SQLExpress from MS to get at the data in a MS Access db. I just needed to get it into calc, but I would think you should be able to access it once the data is in SQLExpress using the ADO adapter, or in worst case you should be able to export it from SQLExpress. Werner I have just converted an Access data base to LibreBase. The steps I used are: 1.Install virtualbox with windows xp on the Linux box 2. Install MS Access on the virtual box. 3. Set up the virtualbox machine to share a linux directory on home/username/database where username is your linux user 4. Load the MS database file into this directory. 5. From the virtualbox using Access open the database. 6. Export all of the database tables, one by one in MS Excell format. I could not find a way to export forms or reports. 7. From your linux account start Librebase and create a new data base. 8. Using LibreCalc open each of the Excell files. Ensure the column definitions in he spreadsheet are correct, i.e. make sure date columns are formatted as date. I had some problems with date fiels and solved it by formatting the date columms as -MM-DD. 9. For each spreadsheet select all and copy. 10 Go to your LibreBase and select the Tables creation area. Paste the spreadsheet dataa into the bottom pane. Follow the prompts to create your table. Note if you have any problems import only the table definition first. Ensure it is correct and then import the data to append to the table. 11 Repeat steps 8-10 for each table. If your access data base uses views or queries you will need to extract the SQL code and use it to import into the LibreBase. If you do have access to a MSwidows machine the you can load LibreOffice into it, open the MSdata base and create a new database in LibreOffice format. The data base will contain all tables and data. It will convert access views to tables. It will not convert forms or reports. Either way you will have to recreate views, queries, forms and reports in LIbreBase. Regards Peter Goggin Regards -- 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
Re: [libreoffice-users] Anyone keen to help get the Base Handbook done?
On 07/09/14 18:29, Tom Davies wrote: Hi ) The Documentation Team needs people to help update the Base Handbook. Two people, Hazel and Alan, have worked very hard to get the translations done. Now it needs; 1. Proof-readers who maybe have no idea about how to use Base, in order to help de-geekify it. 2. People who understand Base well enough to follow through the written instructions. This reviewing process is to make sure that the instructions really do show exactly what normal readers would experience if they tried to work through the guide. 3. People who are on non-Windows platforms, preferably Linux, who are able to take screen-shots. For 1 there are people who could help people to do the proof-reading. Proof-reading kinda needs to be done by people who can bring a fresh perspective, ie that weren't involved in doing the translations and wont be involved in the reviewing. Inevitably there is some overlap though! For 3 there is a guide to help ensure screen-shots are consistent within the guide and consistent with other guides. It's mostly about theming but also about resolution and sizes. It has been a tough challenge getting this far because the last handbook was for several branch's ago. So changes that happened in 4.0.x then had to be modified due to more changes in the 4.1.x. The current work consolidates on the 4.2.x branch. This should give a good solid foundation from which it'll be easier to produce the next handbook. The Docs Team will probably skip the 4.3.x branch and go straight to the 4.4.x when that appears in a few months time. Joining the Documentation Team, to work on the Guides or Handbook, involves a registration process for the ODFAuthors website. Sometimes there is a shortage of people able to do that for you so please bear with them if you join. Just joining their mailing list is a good start documentat...@global.libreoffice.org A quick email to say hi and request a login for ODFAuthors is a good way to start. They like to know if you have previous experience working with documentation in other projects or elsewhere but please keep it brief, it's just to give them a hint. Also let them know if there are specific things you might like to be involved with or things you would like to avoid. Note that complete noobs can be extremely valuable because we are often able to help degeekify things. Regards from Tom :) I have had a number of years experience in data base design and user documentation, mainly on Oracle installations, but also on MS Access. I have also been involved in programming NMC and documenting the process of setting up programs for non computer people. I have been working with computers since 1958 and have had to document a number of different applications. I have also written about 30 scientific research papers. If you think I can contribute please let me know. Regards Peter Goggin -- 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
[libreoffice-users] Converting Microsoft Access to Libre Base
I have a MS access data base running under XP. For various reasons I am converting my ;laptops to run Ubuntu with LibreOffice. I have successfully transfered Thunderbird e-mail from XP to Ubuntu. I am able to transfer and read MS Word and Excel files to run under LibreOffice under Ubuntiu. I cannot see how to transfer rhe MS Access to run uder LibreBase. I tried doing the conversion under XP by loading LibreOffice and then opening the Access data base using LibreBase. with the following results: 1 All tables were successfully converted and retained their data. 2 All vies finished as being defined as tables. 3 No forms were transferred. Is there an easy way to convert Access data bases to run under LibreBase? Can I get the vies transferred as vies ? Do I need to extract the SQL for the vies and then recreate them in Libre Base. If I cannot transfer the forms directly then I will need to recreate them. I have looked at how forms work in LibreBase butr I cannot find out how to create a menu form which allows the juser to select other menu forms or data entry forms. Is there a reort system in Libre Base? Any help will be gratefully accepted Regards Peter Goggin --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- 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