User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 397,810 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,517 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser:
Views: 7310 | Replies: 4
Reply
Join Date: Jul 2005
Location: South East Asia , Singapore
Posts: 52
Reputation: LiBOC is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
LiBOC's Avatar
LiBOC LiBOC is offline Offline
Junior Poster in Training

Help Email Validation Rule with MS ACCESS

  #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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jan 2007
Location: India
Posts: 7
Reputation: PCsrivastava is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
PCsrivastava PCsrivastava is offline Offline
Newbie Poster

Re: Email Validation Rule with MS ACCESS

  #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
[IMG]http://www.daniweb.com/techtalkforums/C:\Documents and Settings\v-shalar\Desktop\access.bmp[/IMG]
Prakash Srivastava
India
Reply With Quote  
Join Date: Mar 2007
Location: Manchester, UK
Posts: 1
Reputation: ankz.upadhyay is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
ankz.upadhyay ankz.upadhyay is offline Offline
Newbie Poster

Question Re: Email Validation Rule with MS ACCESS

  #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  
Join Date: Mar 2005
Posts: 65
Reputation: cpopham is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
cpopham cpopham is offline Offline
Junior Poster in Training

Re: Email Validation Rule with MS ACCESS

  #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  
Join Date: Jun 2008
Posts: 1
Reputation: roamz101 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
roamz101 roamz101 is offline Offline
Newbie Poster

Re: Email Validation Rule with MS ACCESS

  #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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb MS Access and FileMaker Pro Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum

All times are GMT -4. The time now is 6:24 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC