Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    1

    Lookup

    Hello!



    Can anyone help me. I am almost new to access, and I am designing a form. I need to know if Access has a built in control or maybe a database containing a lists of the U.S. and Canada states/provinces?

    Thanks!

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Unfortunately, no :roll:

  3. #3
    Zipster1967 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    May 2006
    Location
    Wisconsin
    Posts
    19

    States/provinces database

    I am thinking you can simply open a database or states and or provinces from the web copy and paste into a txt file then edit the textfile and create a CSV file then import the info into your database. That is what I did to get all the postal codes for the states into my database.
    Hope that helps
    Zipster1967

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Lookup Form
    By virgiljones in forum Access
    Replies: 0
    Last Post: 10-17-2008, 10:39 PM
  2. lookup values in backend tables
    By deb56 in forum Database Design
    Replies: 1
    Last Post: 01-23-2008, 11:12 AM
  3. Lookup Form
    By cav0227 in forum Forms
    Replies: 0
    Last Post: 04-16-2007, 09:23 AM
  4. Lookup Tables
    By JoeBio in forum Database Design
    Replies: 1
    Last Post: 09-01-2006, 07:34 AM
  5. Simple record lookup?
    By Transeau in forum Access
    Replies: 0
    Last Post: 01-18-2006, 10:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums