Re: Changing area code in contact data

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

So what you want is to identify records that start with 678 but may have
leading characters and will be followed by 3 other numbers and then followed
by four other numbers.

Criteria: LIKE "*678*###*####*"

That should find records that have 678 followed by 3 number characters and
four number characters (with or without spaces).

IF you are using Access 2000 (with latest service packs) or a later version
you can use the replace function to replace the 678 with 864

Field: [Phone]
Criteria: LIKE "*678*###*####*"
UpDate To: REplace([Phone],"678","864",1,1,1)

SAME ADVICE as before, test this on a copy of your data to see if it does
what you want.


"faxylady" <faxylady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BDC7757C-FCDE-44E2-94B6-6E2A37BD1ED5@xxxxxxxxxxxxxxxx
These downloaded contacts are automatically dumped into Outlook then
exported
into Access. The problem is they are downloaded from sites that list 7
digit
phone numbers. Outlook or Windows inserts my home area code into these
contacts. Before they can be used of course, the area code has to be
changed
to the correct one.

The reason for the *678 is to include formatting symbols like parentheses.
Some contacts have them, some don't.

Thanks.

"John Spencer" wrote:

Perhaps you want

Calculated Field
Field: Left([phone],4)
Criteria: ="*678"

Field: [Phone]
update to: "864" & Mid([Phone],5)

Or alternative
Field: Phone
Criteria: Like "[*]678*"
Update To: "864" & Mid([Phone],5)

I'm not sure if you are trying to identify phone numbers that start with
*678 or that start with just 678. If this criteria doesn't work for you
I
suggest you post an example of two or three numbers that you want to
change
and what the result is after the change.

IMPORTANT: TEST this on a copy of your data. The changes are not
undoable.


"faxylady" <faxylady@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9234793D-8362-44DC-BCF0-2029FE2BF520@xxxxxxxxxxxxxxxx
After downloading contact info from the Internet into Outlook, I then
export
the contacts into Access. Sometimes the original data does not have
area
codes (10 digit numbers, only 7 digit numbers). Outlook automatically
inserts the home area code that is in the dialing and setup section in
Windows.

I am trying to do an update query to change the area code but nothing I
have
tried works. I do not know vb code. Under the phone field, in the
criteria
row, I have tried Left([phone],4=*678; update to 864. This does not
seem
to
work. Are there any knowledge base articles that show how to change
area
codes in contact data?





.

Relevant Pages

  • Re: Trim Help
    ... country has a trunk prefix which is dialed just before the area code for a ... phone number begins with the International Prefix of the country of origin, ... Then there's the bit about alpha characters. ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing area code in contact data
    ... The first line includes the incorrect area code plus left parenthesis. ... The Update to row concatenates the correct area code with the 7 digit phone ... is a wild card character meaning match any number of characters in this ... If this criteria doesn't work for you ...
    (microsoft.public.access.queries)
  • Re: Changing area code in contact data
    ... Calculated Field ... If this criteria doesn't work for you I ... codes (10 digit numbers, only 7 digit numbers). ... I am trying to do an update query to change the area code but nothing I ...
    (microsoft.public.access.queries)
  • Re: Retrieving phone numbers from Word documents using VBA
    ... extended it to 15 characters, because in some cases, there are extension ... The client has just made things very simple for you. ... the area code plus the next 10 characters following the area code. ... Right now I just pull out the entire sentence and I ...
    (microsoft.public.word.vba.general)
  • Re: form validation
    ... bcc or anything that would be used for e-mail injection vulnerability) ... Phone number area code ... Address has to be stripped of all illegal characters like slashes, ... Where does the validation code go? ...
    (comp.lang.php)