I am trying to stop this sub from updating a certain field (logoimage) if the new parameter is null.
Many thanks, Rit Updating method to make sure it is hitting the lines?
Just a guess but it is probably one of the dates you're trying to update or the yes/no field.
Next step would probably be to start manipulating the update data until you can get a good update then go back to your app and massage the data before doing the update.
I have verified that _Non_MS_Office_Licenses has a primary key that is unique.
Looking in dataset manager I see the query for fill By() is fine and it has all the insert and update stuff.
When i double-click the Row Header, a detailed view of the selected customer will pop-up.
In the main form, i have a Data Grid View which binded to a Data Set. NET Framework data provider to connect to a data source and Command objects to retrieve data from and resolve changes to the data source. The Sql Data Adapter uses the Connection object of the .I have attached my Access Data Source control and the eventsa that perform the update.Please could anyone suggest why the Update is being ignored?At the end when it verifies it says all is verified when I configure the dataset Dim row = Frm App. Current row("Primary User") = Replace(CStr(Txt Userid. Text), "'", "`") row("Staff Last Name") = Replace(CStr(Txt Last Name.