Visual Studio Visual Basic 2012, Automatically update a record when moving to next record without need for save button
Posted on 2014-09-22
Trying to see if I can teach an old dog(me) new tricks. After years of using Access to create databases, I am trying to use Visual Studio 2012 Visual Basic to re-create some of the applications I have created. Right now my learning curve is more of a straight line than a curve. I am used to Microsoft Access handling all record update functions for me. I used the before update event for data validation. Then, if no errors were found, Access would write the updated data to the table. Not so with VB 2012. How do I get VB 2012 to error check a record before the update is written and then, if no errors are found, to write the changes (and/or add a new record) when moving to a new record. I have purchased a couple of books on VB 2012 and I cannot find the answer in any of them. I can't find it online. As a side issue, is there a book/tutorial that anyone could recommend that deals pretty much exclusively with handling databases? I would like to find one that takes me, step by step, thru the creation of a small vb project that updates data located in a SQL server.