 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Prevent Uncomplete records
Hi all, I have a form with few fields that create the record. How can I force/notify the user to fill all fields? Is the method of (If IsNull........then..... exit sub ) is the only way? There must be better way to do it. Thanks, Ron >Hi all, > [quoted text clipped - 8 lines] > >Ron Well, what's wrong with it? I take it you're using the Form's BeforeUpdate event. It's less work for you to open the form's Table in design view and make each such field Required; however, that is harder on the user because they get a possibly-confusing error message, rather than one that you handcraft ("please select a vendor"... setfocus to the vendor combo box, vs. "Unable to save record: validation failure on VendorID" or some such). John W. Vinson [MVP] with SQL Server, you can reuse FIELD VALIDATION in a concept called _RULES_ Access MDB has nothing simliar If you really care about data integrity; you should be using SQL Server and not MS Access FILE, NEW, PROJECT EXISITING DATA > Hi all, > [quoted text clipped - 8 lines] > > Ron >with SQL Server, you can reuse FIELD VALIDATION in a concept called >_RULES_ [quoted text clipped - 4 lines] > >FILE, NEW, PROJECT EXISITING DATA Note that this person is really A a r o n K e m p f and that he is not an employee of Microsoft. Tony  SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Thanks Tony, I have no clue in SQL. Is it possible to connect Access with MySql? Is MySql is object oriented like Access? Thanks >>with SQL Server, you can reuse FIELD VALIDATION in a concept called >>_RULES_ [quoted text clipped - 10 lines] > > Tony >I have no clue in SQL. >Is it possible to connect Access with MySql? Yes, it is possible. You need to install a MySQL ODBC driver though. And it won't integrate quite as well as SQL Server will. >Is MySql is object oriented like Access? No idea. Tony SignatureTony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Tony yeah no sh.t you don't know how to spell SQL why don't you STFU and go and play with your baby database if you give a sh.t about your data, you should be using a database SERVER On May 22, 10:02 am, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote: > >I have no clue in SQL. > >Is it possible to connect Access with MySql? [quoted text clipped - 13 lines] > Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ Tony yeah no sh.t you don't know how to spell SQL why don't you STFU and go and play with your baby database if you give a sh.t about your data, you should be using a database SERVER On May 22, 10:02 am, "Tony Toews [MVP]" <tto...@telusplanet.net> wrote: > >I have no clue in SQL. > >Is it possible to connect Access with MySql? [quoted text clipped - 13 lines] > Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.