If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Phone No. Input mask + another Q ....
Isn't there an input mask so that a phone number has to be entered as
(111)111-1111? In a table of names and addresses, is there a way (in Access) to have the user enter the zip code and have the city and state automatically appear? (I know that there is in some software, because when I order things over the phone, sometimes the operator will ask me for my zip code first and then confirm my city and state.) Thanks again! In peace, Max |
#2
|
|||
|
|||
Isn't there an input mask so that a phone number has to be entered as
(111)111-1111? !(999) 000-0000 In a table of names and addresses, is there a way (in Access) to have the user enter the zip code and have the city and state automatically appear? Well, Access does not "automagically" know what cities and states might be associated with a zip code -- nor, for that matter, does the software that the phone operator is using. You will need a table of zip codes with their associated locations. You can then use a combobox on a data entry form to pull that information. I think you can find that information somewhere -- perhaps you can by doing a Google search. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
#3
|
|||
|
|||
Thank you for both answers. I was able to enter the phone no. mask! After
surfing around here, I think what I need to add to the phone number fields is a validation rule, but when I get the dialog box for validations, I am so confused, I don't know what any of those terms mean, let alone how to use them. For now, the mask will suffice, I guess. Lol, I kind of knew that the computer doesn't really "know" the zip codes, cities or states....I guess now I have to figure out how to create a combo box .... wish me luck! Thanks again! Max "Lynn Trapp" wrote: Isn't there an input mask so that a phone number has to be entered as (111)111-1111? !(999) 000-0000 In a table of names and addresses, is there a way (in Access) to have the user enter the zip code and have the city and state automatically appear? Well, Access does not "automagically" know what cities and states might be associated with a zip code -- nor, for that matter, does the software that the phone operator is using. You will need a table of zip codes with their associated locations. You can then use a combobox on a data entry form to pull that information. I think you can find that information somewhere -- perhaps you can by doing a Google search. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
#4
|
|||
|
|||
Good Luck with it.
-- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "Max" wrote in message ... Thank you for both answers. I was able to enter the phone no. mask! After surfing around here, I think what I need to add to the phone number fields is a validation rule, but when I get the dialog box for validations, I am so confused, I don't know what any of those terms mean, let alone how to use them. For now, the mask will suffice, I guess. Lol, I kind of knew that the computer doesn't really "know" the zip codes, cities or states....I guess now I have to figure out how to create a combo box .... wish me luck! Thanks again! Max "Lynn Trapp" wrote: Isn't there an input mask so that a phone number has to be entered as (111)111-1111? !(999) 000-0000 In a table of names and addresses, is there a way (in Access) to have the user enter the zip code and have the city and state automatically appear? Well, Access does not "automagically" know what cities and states might be associated with a zip code -- nor, for that matter, does the software that the phone operator is using. You will need a table of zip codes with their associated locations. You can then use a combobox on a data entry form to pull that information. I think you can find that information somewhere -- perhaps you can by doing a Google search. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't find "Social Security Number" data in Input Mask Wizard Wind | azik | Database Design | 1 | January 1st, 2005 07:31 PM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Input Mask | Loi | New Users | 1 | November 18th, 2004 05:44 PM |
input mask for phone number? | BruceM | Using Forms | 2 | October 28th, 2004 12:29 PM |
phone number input mask | LGarcia | General Discussion | 4 | September 25th, 2004 12:40 AM |