Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL INSERTS skipped when several Inserts are used in a row
DoEvents doesn't seem to be working. The header table is appending but the data table is skipped. Thank you for the suggestion. I hadn't tried that.- Toddius
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
SQL INSERTS skipped when several Inserts are used in a row
Sub LoadToDB() Dim rs As ADODB.Recordset Dim strSQL As String Dim conn As ADODB.Connection . . Set conn = New ADODB.Connection . For ii = 1 To 10000 If Len(myRange(ii, colAction)) > 0 Then . . ...- Toddius
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
SQL INSERTS skipped when several Inserts are used in a row
Lets try this again:- Toddius
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
SQL INSERTS skipped when several Inserts are used in a row
Hi For starters I am working from excel and controlling an Access 2007 database. I am trying to use an INSERT with an rs.execute command to add data into a table in one db into a table in another db. My problem is that I have two insert queries one right after another (header info and then...- Toddius
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
