Email Validation Rule with MS ACCESS

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Jul 2005
Posts: 73
Reputation: LiBOC is an unknown quantity at this point 
Solved Threads: 0
LiBOC's Avatar
LiBOC LiBOC is offline Offline
Junior Poster in Training

Email Validation Rule with MS ACCESS

 
0
  #1
Jan 7th, 2007
Hi,

I am using MS ACCESS. I want to validate a particular field.
To check whether if its a valid email address with a @

So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string?

Thanks alot.
Reply With Quote Quick reply to this message  
Join Date: Jan 2007
Posts: 11
Reputation: PCsrivastava is an unknown quantity at this point 
Solved Threads: 0
PCsrivastava PCsrivastava is offline Offline
Newbie Poster

Re: Email Validation Rule with MS ACCESS

 
0
  #2
Jan 11th, 2007
Originally Posted by LiBOC View Post
Hi,

I am using MS ACCESS. I want to validate a particular field.
To check whether if its a valid email address with a @

So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string?

Thanks alot.
Yes
You Can Validate A Field Which Must Contain "@"
for That Open Table In Design View & in General Tab Go To "Validation Rule" & Edit Function with <A href="mailto:"InStr(1,[Email],"@")>=1">"InStr(1,[Email],"@")>=1"
& Creat A error Msg If u Want Please Note That In Above Syntex Second String "[Email]" is Name Of Field For Which You want To Add Validation
http://www.daniweb.com/techtalkforum...top\access.bmp
Prakash Srivastava
India
Reply With Quote Quick reply to this message  
Join Date: Mar 2007
Posts: 1
Reputation: ankz.upadhyay is an unknown quantity at this point 
Solved Threads: 0
ankz.upadhyay ankz.upadhyay is offline Offline
Newbie Poster

Re: Email Validation Rule with MS ACCESS

 
0
  #3
Mar 9th, 2007
Originally Posted by PCsrivastava View Post
Yes
You Can Validate A Field Which Must Contain "@"
for That Open Table In Design View & in General Tab Go To "Validation Rule" & Edit Function with <A href="mailto:"InStr(1,[email],"@")>=1">"InStr(1,[email],"@")>=1"
& Creat A error Msg If u Want Please Note That In Above Syntex Second String "[email]" is Name Of Field For Which You want To Add Validation
http://www.daniweb.com/techtalkforum...top\access.bmp

Hi Prakash

Thanks for the message posted but I am havng troule to understand the logic you have shown in the code.

I have also tried this code in MS Access but it is not working. if you could then can you please send me the proper solutionI mean the code which works in your MS Access version which I can copy and paste and understand it.

This is not my assignment so don't think anything in that perspactive. I am doing advance stuff than this. So please do reply me either here or at my mail id which is : ankit_upadhyay2020@yahoo.com

Cheers.
Reply With Quote Quick reply to this message  
Join Date: Mar 2005
Posts: 65
Reputation: cpopham is an unknown quantity at this point 
Solved Threads: 0
cpopham cpopham is offline Offline
Junior Poster in Training

Re: Email Validation Rule with MS ACCESS

 
0
  #4
Mar 11th, 2007
Try looking at the InStr function examples on this page:

http://office.microsoft.com/en-us/ac...547271033.aspx

Chester
Reply With Quote Quick reply to this message  
Join Date: Jun 2008
Posts: 1
Reputation: roamz101 is an unknown quantity at this point 
Solved Threads: 0
roamz101 roamz101 is offline Offline
Newbie Poster

Re: Email Validation Rule with MS ACCESS

 
0
  #5
Jun 19th, 2008
Hey i am did this validation rule for a project i did 3 months ago, i readead your thread and found the way i did it. just place this text in to your validation rule field and it works a dream:
((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

it works perfectly and the company i just built a database for have no issues with it, it can even tell if someone enters " accedentally due to them not configuring their language settings properly. I hope all you guys out there find this useful.

cheers Remi
Reply With Quote Quick reply to this message  
Join Date: Apr 2009
Posts: 1
Reputation: milakrish is an unknown quantity at this point 
Solved Threads: 0
milakrish milakrish is offline Offline
Newbie Poster

Re: Email Validation Rule with MS ACCESS

 
0
  #6
Apr 27th, 2009
Originally Posted by roamz101 View Post
Hey i am did this validation rule for a project i did 3 months ago, i readead your thread and found the way i did it. just place this text in to your validation rule field and it works a dream:
((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))

it works perfectly and the company i just built a database for have no issues with it, it can even tell if someone enters " accedentally due to them not configuring their language settings properly. I hope all you guys out there find this useful.

cheers Remi
Remi Gr8 Job. You are awesome! please be in contact me with me. my email is [email snipped]

Thanks
Last edited by Ezzaral; Apr 27th, 2009 at 3:24 pm. Reason: Snipped email. Keep it on site.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC