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 get the Form working I would expect that you need to
also have Base running before you click on the shortcut - you may need to
experiment.

I tried it on one of my databases. The .odt file opened OK, but I did not
do the work to connect it back to the database, (or to my macros), so it
didn't do anything.  But if you have connected your .odt file to the
database, then I think it would work.  It's worth a try, if this is what
you want to happen.

Regards,

Noel
--
Noel Lodge
lodgemn@gmail.com

On 18 March 2016 at 22:31, Ian Whitfield <whitfield@telkomsa.net> wrote:

> 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 me to import my CSV into and gives me this error ...
> > Again, I don't understand why you are attempting to use LO and a CSV
> > file to import your data into your mysql database.
>
> I have managed - after a 2 day battle - to get all my CSV data back into
> MySQL as a Table.
> I needed to do this as that was the only source of my original data.
> I have also successfully linked Base to this Table. And can view it all in
> Base.
>
> 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??
>
> Thanks a lot.
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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+unsubscribe@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