Jim,
I agree the queries are looping for no good reason but when I stop the looping the report is wrong. There are quite a few nested queries so it is going to be a long process. I was hoping for a quick solution in the meantime.
I am not having any luck with your suggestion but am going to continue trying to find the right combination.
Thanks.
bterri50
Last Activity: Jun 11 '14, 02:57 PM
Joined: May 4 '14
Location:
-
Stop append query from running when it reaches 0 records
I inherited a previous employees project in Access 2010 and need to fix a loop that locks the database. I set Warnings to True in the code to see where the problem is so that I could escape out and avoid the lockup. After pressing Yes to append rows from about 30 tables the query eventually returns 0 records. Choosing NO pulls up the report perfectly. However, it isn't very effective to sit and press the ENTER key 20 times every time I need the... -
Thank you. I was told it was just a simple Access database or I would have turned it down. Thanks again for your help. I think I'll go take a VBA class ASAP.Leave a comment:
-
Thank you for responding but I don't really know how to write code. What would that DCount look like and where within the Loop command would I put it?
Thanks in advance for any assistance.Leave a comment:
-
Do Loop in Access Code Runs to Infinity
I have inherited someone else's database and process. There is a report that would not work. The problem lies in the code but I do not know enough to fix it.
I turned on all Warnings to help me determine where the problem is. The queries loop continuously as expected but when 0 rows are returned the loop needs to stop.
I have determined this because if I hit No when it asks to return 0 records the report appears in...Last edited by Rabbit; May 4 '14, 06:50 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Leave a comment: