Search results

Cronk - The loop was completing properly. Something was triggering the "Loop While Not rstAccounts.EOF" DavidAtWork - Item is a unique key that is formed by a series fields. I think what happened was there is a null value which is trigger the loop to stop. Gemma-The-Husky - I think you are...

Hey everyone. I am having trouble with this VBA that I am using to select and append data to an output table. Everything is working fine until the last step. The last step appends all the data to an output table from the initial table. The intermediate steps select the data to output. This...

StarGrabber, Thank you. I realized that was my error after reviewing more code samples online and was able to make the solution work. When I started writing the script for this I initially set out to count the records in the table and then for a loop for I = 0 to 'max' rowcount. That is...

Help with nested Do Loop(s) - Solved Hello Everyone, I am working on improving a database that I inherited which has several routine update queries based on various criteria. I am working on automating this process and I have a working solution (band-aid). My current solution uses pages of...