Column control datagrid information insufficient key refreshing updating relationships changed from dating to serious
Also, my SQL query is as follows but I ruled out that the problem is there since I tried deleting records from the same query in Access and it seems to work fine.
If you ever solve it, please let me know Matt Sent via Share what you know.
While you don’t want to keep him completely in the dark, keeping him guessing just enough will lure him in.
Show Him You’re Interested Although Hitch was a fictional character, he was a dating guru nonetheless....
Then I update one Col in the Recordset and Updates the database table.
I get few records into a Record set using Select Command.
It kinda makes sense what it is doing, you selected data from three tables into a recordset, when you delete a row from the recordset, it tries to delete from all the base tables. I suspected that as the problem, so just as a test, I changed the querey to be a very simple one. John Poe Since the user would delete records very rarely in my program, I created a delete procedure that opens a separate recordset containing just one table, then I moved to the record that I want to delete and deleted it.
My guess is this is NOT the functionality you are looking for. I never found a way to do this through the datagrid, I ended up doing the deletes myself. I guess that the best solution would be to open a new recordset containing only the primary table and then delete from there. I'm getting this same problem - also with a complex SQL statement - a join of two tables.
Back Color = &HC0C0FF Case 7, 8, 9 '---Back Data Grid1. The Data Grid seems to be the problem,this works with textboxes and other controls. Problems running a VB6-SP3 with data envirionment within W95 10. VB6 SP3 Install Problem DAO and MDAC 2.1 (URGENT) 12. Back Color = &HC0FFC0 Case 10, 11, 12 '---* Data Grid1. Sec" strsql = strsql & " FROM Swimmers INNER JOIN (Events INNER JOIN Times ON Events. Back Color = &H80C0FF Case 13, 14 '---Medley Data Grid1.
After that JET (I think) says 'error during notification'.