Hi :) Can you post some of the old macros as plain text and give a rough idea of what each does. SQL is usually easier because you get a nice gui to do a lot of the work in a nice point&click way. Some of the algebraic formulae might be much the same or perhaps a little less convoluted.
Plus Sql is more generic and less dependant on specific product and versions. On the other hand the LibreOffice/OpenOffice macro language is also much less version-specific than MS macros. I'm not certain that Girvin is offering to do the work for free. Knowing him he probably is but it might be better if there was a potential for payment for work done, unless exchange-rates make that unworkable (as often happens). Regards from Tom :) On 6 May 2014 07:45, milica <[email protected]> wrote: > 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] <[email protected]> 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: [email protected] > 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: [email protected] 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
