zip code look up
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 69158 articles for 1.393 sec
That could be the problem. Ok so if I use the DLookup I can just use a macro? I just want the user to see it on the form. When they enter the zip code I want the city and state to update automatically. Thats why I was thinking of using the afterupdate. I'm still learning this and trying to get things to work for me. Thanks "Dennis" wrote: > What is txtZip_Code ? It is not defined     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for zip code look up in microsoft.public.access.modulesdaovba
Author: Bill
Date: Jun 17, 2008 09:39

I get an error and debug highlights the following string strSql = "SELECT City, State " & _ "FROM tblZIP_CODES " & _ "WHERE Left(Zip_Code, 5) = '" & Left(txtZip_Code.Value, 5) & "'" "John Spencer" wrote: Is that not working? It appears that it should work. Are you getting any errors? John Spencer Access MVP 2002-2005, 2007-2008 Center for Health
Show full article (1.53Kb) · Show article thread
What is txtZip_Code ? It is not defined in your code. Can you not simply do a DlookUp as below ? State = Nz(DLookup("[State]","[tblZIP_CODES]","Left([ZIP_Code],5) = '" & Left(Zip_Code,5) & "'"),"State not found") City = Nz(DLookup("[City]","[tblZIP_CODES]","Left([ZIP_Code],5) = '" & Left(Zip_Code,5) & "'"),"City not found") "Bill" wrote: > I'm trying to do a zip code look up where     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for zip code look up in microsoft.public.access.modulesdaovba
Author: Bill
Date: Jun 17, 2008 09:37

Is that not working? It appears that it should work. Are you getting any errors? John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County Bill wrote: I'm trying to do a zip code look up where the user enters a zip code then the city and state is populated base on a table. My table is called ZIP_CODES
Show full article (1.30Kb) · Show article thread
I'm trying to do a zip code look up where the user enters a zip code then the city and state is populated base on a table. My table is called ZIP_CODES and the table which will be holding all data is "Address". When the user enters the zip code into the form I want the city and state to autofill. Here's what I have: Private Sub Zip_Code_AfterUpdate() Dim rsCurr As DAO.Recordset Dim strSql     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for zip code look up in microsoft.public.access.modulesdaovba
Author: Dennis
Date: Jun 17, 2008 05:18

UPDATE Table1 SET Houston = True WHERE Table1.ZIP in (SELECT Table2.Zip FROM Table2) OR UPDATE TABLE1 INNER JOIN Table2 On Table1.Zip = Table2.Zip SET Houston = True "robpiolink" <roberto.moreno@gmail.com> wrote in message news:1164905669.462556.295170@n67g2000cwd.googlegroups.com... I have 2 tables. Table1 has Zip Codes from many cities, also table1 has a field(yes/no) that
Show full article (1.11Kb) · Show article thread
LEFT will return a text result, so try it this way: =IF(AND(LEFT(A1,3)*1>=606,LEFT(A1,3)*1<=612),1,0) Hope this helps. Pete "CM" <CM@discussions.microsoft.com> wrote in message news:981D22A5-BB80-42EF-9163-6C0F2858F4D5@microsoft.com... > I'm trying to deal with 3 digit zip codes. I'm trying to associate prices > with these zip codes, but when I convert a 5 digit zip to 3 digits, I     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for zip code look up in microsoft.public.access.modulesdaovba
Author: John Spencer
Date: Jun 17, 2008 05:15

The left function returns text but you are comparing that to a number... Add some quotation marks... =IF(AND(LEFT(A1,3)>="606",LEFT(A1,3)<="612"),1,0) or just =AND(LEFT(A1,3)>="606",LEFT(A1,3)<="612") which will return true or false as the case warrants. -- HTH... Jim Thomlinson "CM" wrote: I'm trying to deal with 3 digit zip codes. I'm trying to associate prices with
Show full article (1.00Kb) · Show article thread
=IF(AND(LEFT(I1,3)>="606",LEFT(I1,3)<="612"),1,0) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "CM" <CM@discussions.microsoft.com> wrote in message news:981D22A5-BB80-42EF-9163-6C0F2858F4D5@microsoft.com... > I'm trying to deal with 3 digit zip codes. I'm trying to associate prices > with these zip codes, but when I convert a 5 digit zip to 3 digits, I     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for zip code look up in microsoft.public.access.modulesdaovba
Author: Bill
Date: Jun 16, 2008 21:29

Show full article (0.72Kb)
    

Group: microsoft.public.access.gettingstarted · Group Profile · Search for zip code look up in microsoft.public.access.gettingstarted
Author: John Spencer
Date: Nov 30, 2006 09:51

Show full article (0.65Kb) · Show article thread
    

Group: microsoft.public.access.gettingstarted · Group Profile · Search for zip code look up in microsoft.public.access.gettingstarted
Author: robpiolink
Date: Nov 30, 2006 08:54

Show full article (0.33Kb)
    

Group: microsoft.public.excel.misc · Group Profile · Search for zip code look up in microsoft.public.excel.misc
Author: Pete_UK
Date: Jul 9, 2008 16:47

Show full article (0.94Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for zip code look up in microsoft.public.excel.misc
Author: Jim Thomlinson
Date: Jul 9, 2008 16:38

Show full article (1.00Kb) · Show article thread
    

Group: microsoft.public.excel.misc · Group Profile · Search for zip code look up in microsoft.public.excel.misc
Author: Don Guillett
Date: Jul 9, 2008 16:34

Show full article (0.94Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next