Hi,
Does anyone know what code I need to add in the VB section to add new records to a table(thats exists in SQL) ?
In other words, what needs to be included in this section:
Private Sub Add_Record_Click()
End Sub
Thanks !
Paul
Hi,
Does anyone know what code I need to add in the VB section to add new records to a table(thats exists in SQL) ?
In other words, what needs to be included in this section:
Private Sub Add_Record_Click()
End Sub
Thanks !
Paul
What exactly does this mean
?thats exists in SQL
The code you have shown is related to a button on a Form. Is this form bound to the Table you mentioned?
Yes, the form is bound to a table(VESSEL) and when the button is clicked, all the values in the form need to be added to the existing VESSEL table. This tabe already exists in SSMS.
It exists in Access through ODBC. Pls find the form attached, this would make it more clear.
I have access 2003 so can not read the accdb.
Since the form is bound, what happens when you move to the "next" record?