Re: [libreoffice-users] Re: Need help with Base

I have not been tracking MS Access system design since version 1.1, but 
back then Access did have an external database back-end (server) engine 
called Jet.  Jet was bundled in with Access, much like Base uses HSQLDB, 
but I think it could be used by other front-end clients than Access.  
So, the MS Access client-server  topology was not that unlike Base.  
Base just allows one to get out of the MS Access proprietary "silo" and 
allow much more control of the database system.

For the record, I am using MySQL with Base, soon to be switching to 
MariaDB.  I have not needed to use any macros in my work with Base forms 
or reports.  I have made it a point to avoid macros because they are 
very client-dependent and they would lock me in to a specific client, 
much as the MS Access macros in your database are causing you problems 
now.  I have been able to do some of what you are needing to do with 
forms, only I used queries.  Many of my forms have list boxes where I 
select one of a list of options to be inserted into a database field.  
Although I have not used it, there is another type of drop-down listbox 
that presents options, but if an option not in the list is needed, the 
user may enter that option into the field.  I may have misread your 
posting, but that may be what you need.  I can see that there are times 
when macros would be the only answer to a problem, such as with custom 
forms, but my recommendation is to avoid them whenever you can.
Girvin Herr


On 05/05/2014 12:28 PM, milica wrote:
> Thanks,
> Actually, that base in ms access is kind of start point, and needs to be
> more developed,so I have to learn LO macros anyway :(
>   I'm reading the book OpenOffice.org Macros Explained (great book!), and
> making new version in LO but in LO Calc.
> Thank you once again :))
>
>
> On Mon, May 5, 2014 at 7:29 PM, TomD [via Document Foundation Mail Archive]
> <ml-node+s969070n4107696h68@n3.nabble.com> wrote:
>
> > Hi :)
> > Good point!!
> >
> > An external database is a really good approach.  Many people go for MySql
> > or MariaDb (unless using a Mac) but that's owned by Oracle and some worry
> > about the future of "free" or "Open Source" under Oracle.  Many go for
> > faster, lighter java back-ends such as Hsqldb as an external but others
> > worry about the whole java issue.
> >
> > So Postgresql might well be a good choice.  They have put a lot of work
> > into building a decent connector for Base.
> > Regards from
> > Tom :)
> >
> >
> >
> >
> >
> >
> >
> > On 5 May 2014 15:44, Wolfgang Keller <[hidden 
> > email]<http://user/SendEmail.jtp?type=node&node=4107696&i=0>>
> > wrote:
> >
> > > > I'm new user of LO Base, we are transitioning from MS Access, and I
> > > > need to redesign our db from it.
> > > One word of advice based on experience:
> > >
> > > Avoid use of the "built in" database.
> > >
> > > Use a proper client-server RDBMS. Preferrably PostgreSQL, as it's
> > > reliable and the driver comes with LO.
> > >
> > > Otherwise you *will* regret it the day your data has gone to Nirvana.
> > >
> > > Sincerely,
> > >
> > > Wolfgang
> > >
> > > --
> > > To unsubscribe e-mail to: [hidden email]<http://user/SendEmail.jtp?type=node&node=4107696&i=1>
> > > 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: [hidden email]<http://user/SendEmail.jtp?type=node&node=4107696&i=2>
> > 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
> >
> >
> > ------------------------------
> >   If you reply to this email, your message will be added to the discussion
> > below:
> >
> > http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107696.html
> >   To unsubscribe from Need help with Base, click 
> > here<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4107400&code=bWlsamtvdmljLm1pbGljYS44M0BnbWFpbC5jb218NDEwNzQwMHwxODIyNjg3NDEz>
> > .
> > NAML<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>


--
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