Hi Everyone,
I'm brand new to this forum, and to VB.NET. I've been an intermediate Access VBA programmer for a few years, and decided to try and improve my skills by learning VB.NET. I'm running visual studio community 2015 if it matters.
I figured I could start by duplicating one of my simplest Access applications. my .accdb has three tables; tblEvent, tblJunction, and tblTags. All of the controls on my form except one are bound to fields in the tblEvent table. That other control is a data grid view that is bound to the tblTags table. This data grid view shows just one field (the tags description), but has ID fields hidden to match up with the ID on the parent form, as well as the one for the Tag. This all seems to work when ran. I can flip through the data of existing records fine.
But, I cannot insert new records. My code breaks around the following:
I know I need to do something to this, but I'm unclear as to what. Thanks for any insight.
Also, if anyone has a good way to learn this language and/or visual studio, please share. I've been watching videos on Lynda.com, which have been helpful, but I'm exploring all avenues.
I'm brand new to this forum, and to VB.NET. I've been an intermediate Access VBA programmer for a few years, and decided to try and improve my skills by learning VB.NET. I'm running visual studio community 2015 if it matters.
I figured I could start by duplicating one of my simplest Access applications. my .accdb has three tables; tblEvent, tblJunction, and tblTags. All of the controls on my form except one are bound to fields in the tblEvent table. That other control is a data grid view that is bound to the tblTags table. This data grid view shows just one field (the tags description), but has ID fields hidden to match up with the ID on the parent form, as well as the one for the Tag. This all seems to work when ran. I can flip through the data of existing records fine.
But, I cannot insert new records. My code breaks around the following:
VB.NET:
Public Class frmRecord Private Sub TblEventBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles TblEventBindingNavigatorSaveItem.Click
Me.Validate()
Me.TblEventBindingSource.EndEdit()
'code breaks on line below....
TableAdapterManager.UpdateAll(Me.ACS_Engineering_Changes_beDataSet)
End Sub
I know I need to do something to this, but I'm unclear as to what. Thanks for any insight.
Also, if anyone has a good way to learn this language and/or visual studio, please share. I've been watching videos on Lynda.com, which have been helpful, but I'm exploring all avenues.