Re: [libreoffice-users] Re: Calc as a Flat File Database

2016-03-19 Thread Ian "Witty" Whitfield
Thanks all - appreciated!! My background is 30 years in the Computer Business - Training, installations, support etc etc. Since retiring I left Windows behind and changed to Linux. What I'm not is a Programmer - except with BASIC about 20 years ago!!! My needs are to have a SOLID, RELIABLE

Re: [libreoffice-users] Re: LibreOffice Base and MySQL

2016-01-26 Thread Ian "Witty" Whitfield
On 01/24/2016 10:04 AM, Hank Alper wrote: Hi Ian, I frequently import Calc Spreadsheets into my MySQL database using phpMyAdmin.. My version of phpMyAdmin asks to locate the File you wish to import.Specifically, it offers a Browse option. Locate the Calc file you wish to import.by browsing to it

[libreoffice-users] LibreOffice Base and MySQL

2016-01-20 Thread Ian "Witty" Whitfield
Hi All I have been trying to import a CSV file from Calc into MySQL to run with Base for over a week now and can not believe this is so difficult to do so I'm hoping some other Base users might have cracked this one!! My OpSys is PClinuxOS - 32-bit and MySQL is ver 5.1.73. Everything is

Re: [libreoffice-users] Linking a Form to another table

2016-01-15 Thread Ian "Witty" Whitfield
OK - I have found the answer to this problem myself here... http://stackoverflow.com/questions/27102600/solved-libreoffice-com-mysql-jdbc-driver-cannot-be-loaded On 01/14/2016 06:23 PM, Ian "Witty" Whitfield wrote: Hi All Am still trying to connect my existing 'Input Form' to a diffe

Re: [libreoffice-users] Linking a Form to another table

2016-01-14 Thread Ian "Witty" Whitfield
Hi All Am still trying to connect my existing 'Input Form' to a different Table. Been busy so got round to trying it again today!! Now when I try to link to an existing Database I get the error "The JBDC Driver could not be loaded". The Class is "com.mysql.jdbc.Driver" which worked before.

Re: [libreoffice-users] Linking a Form to another table

2016-01-08 Thread Ian "Witty" Whitfield
Thanks Stephan and Dan - I appreciate. Stephan - I will give your idea a try... Dan - I've had several crashes and problems and during a recent backup and re-build I found my Back-up and screwed up completely and I lost my Database!! Digging around in old backups I found a slightly older

[libreoffice-users] Syntax Question

2011-12-14 Thread Ian Witty Whitfield
Hi All Can someone help me with some syntax please?? I have a two-sheet Calc Spreadsheet. All my data lives on the first sheet called Data and my Analysis Reports are on Sheet Two. I have the same values in any given Column in my Data Sheet, (ie all my Totals are in Column D), and - as per