Re: [libreoffice-users] Re: Auto Filling Drop Down Boxes
Hi :) Thanks for those links. Some useful information that does indeed contradict what i have previously heard about Base. It makes me wonder about the accuracy of other information i have seen about Base in a variety of places. No, of course i am not going to name names or divulge sources after the way i have been treated. I will quietly ask a few people to see how the misunderstandings arose and see what they say about the links you just gave. More importantly it gives me enough confidence to try out Base myself at work to see if migration is possible after all. Given that this is the first good news i have had about Base i still wouldn't recommend it to other people but it's obviously worth testing if there is enough time. For myself i will make time to test it. Regards from Tom :) --- On Sat, 24/9/11, NoOp gl...@sbcglobal.net wrote: From: NoOp gl...@sbcglobal.net Subject: [libreoffice-users] Re: Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Saturday, 24 September, 2011, 0:35 On 09/23/2011 06:55 AM, Tom Davies wrote: Hi :) Lol. Cor appears to be accusing me of being wrong but with no proof to support the accusation. The only link he did give appears to bolster my assertions. It appears to show a lot of work going into Calc and the other apps but none into Base. Of course it is pure geek and difficult to understand but the few i clicked seemed to mention something about Calc and one mentioned wizards. None mentioned Base. The other accusation Cor appears to make is that i have not provided the type of proof he wants, which is a bit hypocritical imo as there is no proof that my assertions were inaccurate or misleading at all. He provided you with a link to query the work being done in LO on Base: http://cgit.freedesktop.org/libreoffice/core/log/ Enter 'dbaccess in the search window you'll see the dev work on Base. That results in: http://cgit.freedesktop.org/libreoffice/core/log/?qt=grepq=dbaccess Another is: http://cgit.freedesktop.org/libreoffice/core/log/connectivity I'm not sure what others may be involved, but it is clear that there is development work on Base in LO. I do know 1 person that has been trying to work on Base and a few people tell me there is another one but the work is not easy. And that person is? It seems to me that there are several people working on Base. Disclaimer: I've just learned about http://cgit.freedesktop.org/libreoffice/core/log/ as well and am still working my way through it. However your continued FUD regarding Base advising new users on this list to stick to Access et al seems to be just that: FUD. Before you continue posting the like, how about actually trying to find out the facts? None of this is relevant to the original question and i think the time would be better spent helping people rather than wasting everyone else's time with this sort of nonsense so publicly. It is possible to send emails to individuals off-list if you think they are wrong in some way. Regards from Tom :) Actually time would be better spent assisting the user with Base rather than making such statments as: I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. and It's just that almost everyone avoids Base. While Writer and Cal and the rest attract a LOT of devs they just avoid Base.. If you can't back up those statements with fact, then they are better left unsaid. Gary Lee --- On Fri, 23/9/11, Cor Nouws oo...@nouenoff.nl wrote: From: Cor Nouws oo...@nouenoff.nl Subject: Re: [libreoffice-users] Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Friday, 23 September, 2011, 13:58 Tom Davies wrote (23-09-11 14:27) Hi :( If you are familiar with those tools then i am sure you could find an answer faster. Irrelevant. *You* make the statements - lots of well reading sentences that seem to make sense but may as well be tendentious or misleading. So if you do not give a solid ground to your statements, or even want to make real effort in trying to do so, then please stop making them. -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe
Re: [libreoffice-users] Re: Auto Filling Drop Down Boxes
Hi Tom, When there have been posts about this or that in Base, generally there have been quite a few people who have participated. It may be used more than most people realize. Shortly after Base became a part of OpenOffice, I converted, successfully, all of my data from Paradox to Base. If I had been using Access, it would have been slightly easier. Base has been an extremely dependable program for me. The only issue I've had is the one with Java. Yes, I'm aware of a couple of bugs, but none of those affect me in any meaningful way. I've been using it for about 8 years and would not change to anything else since it has worked so well for me, and it serves my needs. Don On 09/24/2011 05:14 AM, Tom Davies wrote: Hi :) Thanks for those links. Some useful information that does indeed contradict what i have previously heard about Base. It makes me wonder about the accuracy of other information i have seen about Base in a variety of places. No, of course i am not going to name names or divulge sources after the way i have been treated. I will quietly ask a few people to see how the misunderstandings arose and see what they say about the links you just gave. More importantly it gives me enough confidence to try out Base myself at work to see if migration is possible after all. Given that this is the first good news i have had about Base i still wouldn't recommend it to other people but it's obviously worth testing if there is enough time. For myself i will make time to test it. Regards from Tom :) --- On Sat, 24/9/11, NoOpgl...@sbcglobal.net wrote: From: NoOpgl...@sbcglobal.net Subject: [libreoffice-users] Re: Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Saturday, 24 September, 2011, 0:35 On 09/23/2011 06:55 AM, Tom Davies wrote: Hi :) Lol. Cor appears to be accusing me of being wrong but with no proof to support the accusation. The only link he did give appears to bolster my assertions. It appears to show a lot of work going into Calc and the other apps but none into Base. Of course it is pure geek and difficult to understand but the few i clicked seemed to mention something about Calc and one mentioned wizards. None mentioned Base. The other accusation Cor appears to make is that i have not provided the type of proof he wants, which is a bit hypocritical imo as there is no proof that my assertions were inaccurate or misleading at all. He provided you with a link to query the work being done in LO on Base: http://cgit.freedesktop.org/libreoffice/core/log/ Enter 'dbaccess in the search window you'll see the dev work on Base. That results in: http://cgit.freedesktop.org/libreoffice/core/log/?qt=grepq=dbaccess Another is: http://cgit.freedesktop.org/libreoffice/core/log/connectivity I'm not sure what others may be involved, but it is clear that there is development work on Base in LO. I do know 1 person that has been trying to work on Base and a few people tell me there is another one but the work is not easy. And that person is? It seems to me that there are several people working on Base. Disclaimer: I've just learned about http://cgit.freedesktop.org/libreoffice/core/log/ as well and am still working my way through it. However your continued FUD regarding Base advising new users on this list to stick to Access et al seems to be just that: FUD. Before you continue posting the like, how about actually trying to find out the facts? None of this is relevant to the original question and i think the time would be better spent helping people rather than wasting everyone else's time with this sort of nonsense so publicly. It is possible to send emails to individuals off-list if you think they are wrong in some way. Regards from Tom :) Actually time would be better spent assisting the user with Base rather than making such statments as: I would stay with Access for now. There is almost no-one working on Base so it's gradually getting worse as regressions slip in. and It's just that almost everyone avoids Base. While Writer and Cal and the rest attract a LOT of devs they just avoid Base.. If you can't back up those statements with fact, then they are better left unsaid. Gary Lee --- On Fri, 23/9/11, Cor Nouwsoo...@nouenoff.nl wrote: From: Cor Nouwsoo...@nouenoff.nl Subject: Re: [libreoffice-users] Auto Filling Drop Down Boxes To: users@global.libreoffice.org Date: Friday, 23 September, 2011, 13:58 Tom Davies wrote (23-09-11 14:27) Hi :( If you are familiar with those tools then i am sure you could find an answer faster. Irrelevant. *You* make the statements - lots of well reading sentences that seem to make sense but may as well be tendentious or misleading. So if you do not give a solid ground to your statements, or even want to make real effort in trying to do so, then please stop making them. -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
RE: [libreoffice-users] Re: Auto Filling Drop Down Boxes
Am 21.09.2011 19:00, stripedtomato wrote: I have three drop down boxes: City, State, Zip as part of an address record. As of now, I have to make independent selections for each of these drop down boxes. What I would like to do is when selecting a city from the drop down box list, then related state and zip information would automatically be filled in, in their respective drop down boxes, and the information stored in their respective db cells. == 22/09/2011: Andreas S�ger Wrote:- This is impossible because big cities have more than one ZIP and there are ambiguous city names. You may enter a city name and then choose the actual city and zip from suggested data. I use to enter zip codes. Each zip code belongs to one particular city in one state. Apart from this, big companies and public sectors have their own zip codes. == Hi stripedtomato, What you want to do is actually very easy. At least in Australia where it is possible to download a postcode file from the post office (what USA folk call a zip code we call a postcode (with no spaces)). However even without starting from a set data file it is still possible to create the tables and code and add zip codes as and when required. In the City/Suburb drop down list, all cities, suburbs, towns, villages and other zip codes for the relevant country are listed and should be sorted alphabetically then if there are thirty instances of Bridge Town for example each would have additional columns in the dropdown list for State, zip code and any other information needed to quickly identify the correct Bridge Town then in the afterupdate or onvalidate event (etc. depending on programming platform) simply write code to add the relevant data from the state and zip code columns in the list. Of course to do this you will need a dropdown control capable of handling multiple columns. You could do as Andreas S�ger suggested and sort the list by zip code but that would mean that everyone using the system would need to know the zip codes but this is not very practicable as most people find it much easier to remember actual names rather than the relevant code. So if there was a Bridge Town MA or Bridge Town CA or Bridge Town NJ most users would know instantly which Bridge Town they wanted. (I'm only guessing with Bridge Town because the last time I was in the United States of America I lost count of the number of Bridge Towns I drove through. A bit like Kingston in Australia. Every state's got at least one.) Also in Australia, I'm guessing that it's much the same in your country, there are many small adjoining suburbs with the same postcode. So just entering a zip code would not necessarily give the correct data for location name and state. In Great Brittan and parts of Europe it is much more difficult because each street has at least one or more postcodes, however these codes come in two parts, the first part represents the area and the second part represents a section of the street. Cheers, if you need any code samples, let me know what platform you are using and I'll see if I can help, Bruce Carlson. -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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