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

Calc menu:Data>Form... https://forum.openoffice.org/en/forum/viewtopic.php?f=21=77543 includes a macro to extract and reconnect all forms from a database document. Background: https://forum.openoffice.org/en/forum/viewtopic.php?f=83=40493 -- View this message in context:

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

Le 16/03/2016 12:06, Jaroslaw Staniek a écrit : Hi Jaroslaw, It seems that Ian wants a solution that doesn't require too much effort and just works, at least in the way that he would like. In that case, Base, and from your own answer, Kexi, will be unsuited to that task. Defining the metes and

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

Le 16/03/2016 11:06, Ian Whitfield a écrit : Hi Ian, > I wrote to you directly but it seems you don't like direct contact this > way - sorry about that. Yes, that's not my thing, sorry, but I only contribute to this list when I think it is worthwhile, or I'm having a rant ;-) > there seems

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

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: Calc as a Flat File Database

Hi Alexander and all: Thank you for your clear explanation. If I understood you well, this happen when we predefined the table in Base that we think that we will need. But when I have needed do it, I didn't make the table, I only use connect option (when start BASE), with a .db

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

Le 16/03/2016 13:27, Alexander Thurgood a écrit : You could plausibly also design your form from the ground up using a Calc sheet, inserting form controls onto it, and linking that form to your datasource, and then binding your form controls to the data fields. Alex -- To unsubscribe e-mail

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

Hi Alexander On 03/17/2016 05:59 PM, Alexander Thurgood wrote: So Alexander has told me how to save my Form (that helps a lot) and I >decided to get back into Base as it seems to be the only way to go for >me. But MySQL is giving me up-hill. It does not seem to want to save an >empty Table for

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

Hi Ian and all: Excuse me if I understood bad your problem. I understood that you need import a .CSV file to BASE with BASE. And You can't do it. I suggest to you to open the .CSV file with CALC. Then save it as .ODS. Finally, import from BASE the .ODS file. I

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

Le 18/03/2016 12:31, Ian Whitfield a écrit : Hi Ian, > > But I now have the problem of bringing in the Form you told me how to save. > I have it as an ODT file but can not find a way of coping it into Base!! > > Can you assist me with this please?? The whole point of saving the form as an ODT

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

Le 17/03/2016 16:08, jorge a écrit : Hi Jorge, > I suggest to you to open the .CSV file with CALC. Then save it as .ODS. > Finally, import from BASE the .ODS file. > The import wizard from Calc to Base is not perfect, so unless one is absolutely sure that the data in your CSV or Calc

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

Le 16/03/2016 21:19, Ian "Witty" Whitfield a écrit : Hi Ian, > > My needs are to have a SOLID, RELIABLE simple Members Database that does > not crash all the time and take the data with it as well. > I don't even need a RDB as I have one table, one Form and a few queries, > it is single user on

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

Hi Ian, I think what you are wanting to discover is how to open your Form - the .odt file. One possibility would be to right click on the .odt file, then choose Send to | Desktop (create shortcut). After that, simply clicking on the shortcut on the Desktop will open the . odt file. No doubt to

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

On 16 March 2016 at 11:06, Ian Whitfield wrote: > Hi Alex > > On 03/10/2016 01:11 PM, Alex Thurgood wrote: > >> Why not separate out your forms from the ODB file if you are concerned >> about the stability of the ODB file itself ? It is perfectly possible, >> you can

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

Hi Alex On 03/10/2016 01:11 PM, Alex Thurgood wrote: Why not separate out your forms from the ODB file if you are concerned about the stability of the ODB file itself ? It is perfectly possible, you can still link to a mysql db and you won't have the issues of screwing up your ODB just because

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

Le 09/03/2016 10:43, Ian Whitfield a écrit : Hi Ian, > Database and re-designing your Forms etc. This has happened repeatedly > with the embedded engine and also with the MySQL engine. I'm sorry, but crashing and subsequent corruption of an ODB file that links to a mysql database does not lead