Search results
-
R
docmd.runsql doesnt execute in 2nd iteration of for loop
I am a complete dunce. I found my problem in that I opened the recordset in the subroutine, and had an additional rstable = open recordset in the function (2 different variable names). Once corrected, the loop executes just like I always knew it should Done in again by cut and paste... -
R
docmd.runsql doesnt execute in 2nd iteration of for loop
In this case I believe I do need a loop as I am taking a large number of competitors in an event and splitting them into separate groups. Initially, I take a group of (ex:) 16 people in an event and split it 3 ways (6, 5, 5) Each of the original records is updated to show if the competitor is... -
R
docmd.runsql doesnt execute in 2nd iteration of for loop
Hello -- New to the forum and fairly new to vba. I am running a for loop with a run sql command as part of it. It runs correctly the first time, updates the proper table and populates the form. When it comes back again, the value of the counter (i) is correctly incremented, but the sql...