Dear Girvin, I have that base that we use in our workshop like warehouse management,(select product, type amount that needs to be added/removed from warehouse and macro does it) and also base needs to create work orders based on calculation (for every product, how many half products there is to be made) times number of products needs to be made,and then write that on some report. I pretty mush did all the work in LO Calc, and the SQL is too much for me currently. And I do that for personal use, since we have to switch from XP/Access to Ubutu/LO on our workshop computer. I cannot ask you to do that work for me, and I'm not sure If I could handle that myself. Thanks, Milica
On Tue, May 6, 2014 at 12:07 AM, Girvin Herr [via Document Foundation Mail Archive] <ml-node+s969070n4107732...@n3.nabble.com> wrote: > 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] > > <[hidden email] <http://user/SendEmail.jtp?type=node&node=4107732&i=0>> > 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< > > >> . > >> 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: [hidden > email]<http://user/SendEmail.jtp?type=node&node=4107732&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 > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107732.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> > -- If you can imagine it, you can achieve it; if you can dream it, you can become it. -- View this message in context: http://nabble.documentfoundation.org/Need-help-with-Base-tp4107400p4107761.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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
