Re: [libreoffice-users] Base data-loss and other problems

2013-05-09 Thread Hank Alper
Hi Tom, My experience with the embedded database in Base has convinced me to move to an external back-end. I have had several instances of data loss particularly during sessions of heavy data input. While I'm in the process of moving my database to an external H2 database, I still use the

Re: [libreoffice-users] Italics and bold in BASE

2013-05-10 Thread Hank Alper
Hi The short answer to your question is Yes. You can use Bold and Italics in your Forms and in your Reports in Base. In both cases you must be in design mode. Have you been able to design a Form without using Bold or Italics ? Hank On Wed, May 8, 2013 at 12:31 PM, acanela

Re: [libreoffice-users] SQL statement error when linking Main form to SubForm

2013-06-06 Thread Hank Alper
Hi Noel I'm building a database for a fishing club. I have Member and Boat as two of the many tables in the DB. I have a form which shows my Member data and a sub form with the Boat data of all the boats the member owns. I used the wizard to produce this form. How did you establish the

Re: [libreoffice-users] LO Base/MySQL Backup??

2013-06-30 Thread Hank Alper
Hi Ian, Ive been reading the posts concerning the security of your database using mysqldump. Are you using a remote server for your MySQL, or is it on your own computer? I've completed a database using LO Base with embedded HSQL. I guess I can use a MySQL server on my own machine to which I can

Re: [libreoffice-users] documentation for LO base

2012-10-08 Thread Hank Alper
Hi I have found that a good source of documentation for LO base is found in some of the documentation written for OO Base. I've been using Marano Casanova's excellent work available at Base_tutorial.pdf (application/pdf Object)https://wiki.documentfoundation.org/images/0/02/Base_tutorial.pdf.

[libreoffice-users] Base Form behavior.

2012-12-05 Thread Hank Alper
out handling records in increments of about 40 records until it finds the end of the file. Strange. Hank Alper -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more

Re: [libreoffice-users] Re: Base Form behavior.

2012-12-10 Thread Hank Alper
...@gmail.comwrote: On 12/06/2012 05:08 AM, Hank Alper wrote: Hi Hank, ith the same result. Is this a bug? Has anyone noticed this type of behavior ? Base seems to start out handling records in increments of about 40 records until it finds the end of the file. Strange. Hank Alper

Re: [libreoffice-users] Libre Office Version 3.6.4.3 (Build ID: 2ef5aff)

2012-12-22 Thread Hank Alper
Hi Chris, I'm using the same version of Libre Office as you are, on a windows 7 Professional system.. I have run databases on this version of Base which were developed on previous versions and even some developed on Open Office. I do not not have the same problem as you. However, If I close the

Re: [libreoffice-users] Re: Base scenario

2013-01-01 Thread Hank Alper
Hi Ian, I'm not sure what you mean by automatic.Would you consider a list box with a drop down list of all the member names with the equivalent member ID being the input value to the subform automatic enough? I've used this approach many times on the project I'm working on. In your form edit mode

Re: [libreoffice-users] Re: Base scenario

2013-01-01 Thread Hank Alper
reply to me - appreciated!! *On 01/01/2013 10:21 AM, Hank Alper wrote: * *Hi Ian, I'm not sure what you mean by automatic.Would you consider a list box with a drop down list of all the member names with the equivalent member ID being the input value to the subform automatic enough? I've

Re: [libreoffice-users] Re: Base scenario

2013-01-11 Thread Hank Alper
Ian How are you defining your primary keys and your foreign keys ? From your post, it looks like you have two tables, 'Members' and eMail. Implicit in your post it appears that the primary key of 'Members' is 'Record ID'. Also, the primary key of 'eMail' is 'Message ID' while a key called 'Members

[libreoffice-users] Base Report Builder

2013-01-20 Thread Hank Alper
Hi I've invested a considerable amount of time in constructing tables, forms and queries for a project of mine. I successfully produced 3 nice reports using Report Builder. Now, I'm starting to observe strange behavior in Base. Queries and Reports I've prepared days earlier suddenly disappear

Re: [libreoffice-users] Re: Base Query Sort and Reports

2013-01-26 Thread Hank Alper
Hi capemayal, In your case expression you use the WHEN keyword. You should have a THEN keyword to match. If the two dates in your expression match THEN what happens ? Hank On Sat, Jan 26, 2013 at 10:52 AM, capemayal capema...@gmail.com wrote: Yes, thank you Dan. I upgraded to 3.6.4, and the

Re: [libreoffice-users] Re: Base Report Builder

2013-01-26 Thread Hank Alper
Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16 tables.( with a few more coming as I've discovered as

Re: [libreoffice-users] Re: Base Report Builder

2013-01-27 Thread Hank Alper
:24, Hank Alper hankal...@gmail.com wrote: Hi Alex, Mark, Tom, You guys scare me ! I'm beginning to think I'd better start looking for a new back end. I've put a lot of work into this project. Tom, this is not a small database like an address book. After normalizing, my design has 16

Re: [libreoffice-users] Re: Base Report Builder

2013-01-29 Thread Hank Alper
for not replying sooner! I've just been a bit snowed under and anyway Dan, Alex and others know far more about specifically Base itself so hopefully someone has been able to give you much better help! Regards from tom :) -- *From:* Hank Alper hankal...@gmail.com

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

2016-01-30 Thread Hank Alper
wrote: > 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.

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

2016-01-24 Thread Hank Alper
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 in your file system. It also asks for the