[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-24 Thread Andreas Säger
Am 24.09.2011 15:27, Don C. Myers wrote: 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

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-24 Thread Andreas Säger
Quick and dirty draft of an embedded HSQLDB with US zip codes: http://www.mediafire.com/?1k312s62qupaqgb The form's dummy text field stands for all those name, address, phone, email fields that may be in a list of addresses. The list box lets you select one particular ZIP code which stands f

Re: [libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-24 Thread Don C. Myers
time. For myself i will make time to test it. Regards from Tom :) --- On Sat, 24/9/11, NoOp wrote: From: NoOp 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: H

Re: [libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-24 Thread Tom Davies
-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 appe

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-23 Thread NoOp
On 09/23/2011 12:34 AM, Andreas Säger wrote: > Am 23.09.2011 04:26, NoOp wrote: >> On 09/22/2011 01:40 AM, Andreas Säger wrote: >>> >>> This is impossible because big cities have more than one ZIP and there >>> are ambiguous city names. >> >> Actually it's not if you have (in the US) the USPS 5 dig

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-23 Thread NoOp
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 Bas

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-23 Thread Andreas Säger
Am 21.09.2011 19:00, stripedtomato wrote: I am moving my db from Access to LibreOffice, so I know Access much better, but I was never able to figure this out in Access either. If you happen to know the answer in either Access or Base I should be able to figure it out from there. All this is

Re: [libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-23 Thread Tom Davies
Hi :) I think Andreas was just pointing out that given a zip code it might be fairly easy to find the city, State and such but given a State or even a specific city it might not be easy to guess which of the zip codes is right.  I think you can get part of the zip code that way buit not all of i

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-23 Thread Andreas Säger
Am 23.09.2011 04:26, NoOp wrote: On 09/22/2011 01:40 AM, Andreas Säger wrote: This is impossible because big cities have more than one ZIP and there are ambiguous city names. Actually it's not if you have (in the US) the USPS 5 digit Zip Code database: http://www.usps.com/business/address-i

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread NoOp
On 09/22/2011 01:40 AM, Andreas Säger wrote: > 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 sele

RE: [libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread Bruce Carlson
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

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread NoOp
On 09/21/2011 10:09 AM, Tom Davies wrote: > Hi :) 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. You keep dishing out this advise... that and "It's just that almost everyone avoids Base." why? At every turn I s

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread Andreas Säger
Am 21.09.2011 19:09, Tom Davies wrote: Hi :) 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. Regards from Tom :) These things use to work since OOo 1.0 (long before "Base") and when they break, the whole offic

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-22 Thread Andreas Säger
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 s

[libreoffice-users] Re: Auto Filling Drop Down Boxes

2011-09-21 Thread Alexander Thurgood
Le 21/09/11 19:09, Tom Davies a écrit : Hi Tom, > 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. > Regards from The poster's question is a common one, which has been answered many times on the OpenOffice.org