Thanks alot. 11 posts since Jan 2007 Reputation Points: 10 [?] Q&As Helped to Solve: 0 [?] Skill Endorsements: 0 [?] 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 =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] 1 post since Mar 2007 Reputation Points: 10 [?] Q&As Helped to Solve: 0 [?] Skill Endorsements: 0 [?] 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 =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/techtalkforums/C:\Documents and Settings\v-shalar\Desktop\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.
Experian Data Quality Releases New Cloud-based Email Validation Enhanced Qas Email Now Available To Improve
For more information, visit http://www.qas.com/email-verification.htm : www.qas.com/email-verification.htm . About Experian Data Quality Experian Data Quality is a global leader in providing data quality software and services to organizations of all sizes. We help our clients to proactively manage the quality of their data through world-class validation, matching, enrichment and profiling capabilities. With flexible software-as-a-service and on-premise deployment models, Experian Data Quality software allows organizations around the world to truly connect with their customers by delivering intelligent interactions, every time. Established in 1990 with offices throughout the United States, Europe and Asia Pacific, Experian Data Quality has more than 13,500 clients worldwide in retail, finance, education, insurance, government, healthcare and other sectors. For more information, visit http://www.qas.com : www.qas.com/ . About Experian Marketing Services Experian Marketing Services is a global provider of integrated consumer insights and targeting, data quality and cross-channel marketing. We help organizations from around the world intelligently interact with today’s dynamic, empowered and hyperconnected customers.