A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Phone No. Input mask + another Q ....



 
 
Thread Tools Display Modes
  #1  
Old February 9th, 2005, 04:23 PM
Max
external usenet poster
 
Posts: n/a
Default 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
Ads
  #2  
Old February 9th, 2005, 08:23 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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  
Old February 9th, 2005, 09:53 PM
Max
external usenet poster
 
Posts: n/a
Default

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  
Old February 11th, 2005, 06:26 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 08:31 PM
Prevent Blank Records being written. Need Help. Robert Nusz @ DPS Using Forms 4 December 29th, 2004 06:15 PM
Input Mask Loi New Users 1 November 18th, 2004 06: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


All times are GMT +1. The time now is 02:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.