User Profile

Collapse

Profile Sidebar

Collapse
SLMQC
SLMQC
Last Activity: Apr 27 '13, 08:45 PM
Joined: Jan 19 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • SLMQC
    replied to VBA code to verify phone numbers
    in Access
    Thank you Anas! Tested and confirmed.
    See more | Go to post

      Leave a comment:

    • SLMQC
      started a topic VBA code to verify phone numbers
      in Access

      VBA code to verify phone numbers

      I am new to VBA (Access), and I'm trying write a proceedure to verify Phone field values for a particular City. Example: if the City is Cleveland, the two 'valid' area codes are 216 and 440.

      I am using the VBA statement below, and the message block is popping up even when the first three numbers meet the 216 or 440 criteria. Can anyone help me identify how to correct?



      Code:
      Private Sub Form_BeforeUpdate(Cancel As
      ...
      See more | Go to post
      Last edited by TheSmileyCoder; Jan 19 '13, 10:17 PM. Reason: When posting code, please wrap it on [code]...[/code] to improve readability.
      No activity results to display
      Show More
      Working...