Out of control loop in autoexec macro

[accessnewbie]

I have an autoexec macro that I am testing. I wanted it confirm it was looping through the tables in my database by displaying the names of the tables via "msgbox". Something is obviously wrong because I opened the database and a message box pops up with no text in it and an OK button. I can hit the OK button 1 time or 100 times and it won't go away. How do I get back to somewhere I can change the code and fix the loop?



Sorry for my stupidity.

accessnewbie

[TheShabz]

may i ask why you are doing this via messagebox? save yourself some time and have it populate a table you can look at.

As far as the problem goes, I'm going to assume you have the MsgBox inside the loop so its creating a new one for each iteration. Take the MsgBox outside the loop and it'll only go once.

Better yet, open it up in VBA mode, create a variable that will hold the text of the tables, then just debug.print it. itll show them all in the immediate window.

[RuralGuy]

AND...opening the db while holding down a <SHIFT> key will bypass the AutoExec macro, in case you did not know that.