 |  |  |  |  |  |  |  |
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
 |
•
•
Join Date: Jul 2005
Posts: 73
Reputation: 
Solved Threads: 0
Junior Poster in Training
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.
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.
•
•
•
•
Originally Posted by LiBOC 
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.
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
India
•
•
•
•
Originally Posted by PCsrivastava
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.
•
•
Join Date: Mar 2005
Posts: 65
Reputation:
Solved Threads: 0
Junior Poster in Training
Try looking at the InStr function examples on this page:
http://office.microsoft.com/en-us/ac...547271033.aspx
Chester
http://office.microsoft.com/en-us/ac...547271033.aspx
Chester
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
((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
•
•
•
•
Originally Posted by roamz101
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.
|
Similar Threads
- Microsoft Access 2003 Validation Rule (MS Access and FileMaker Pro)
- Any help with a Defult Value and Validation RULE. **MICROSOFT ACCESS** (MS Access and FileMaker Pro)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Query Criteria issue and Emailing with Access 07
- Next Thread: inventory db
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
