Recent content by Ummyeah

nevermind i'll figure it out myself. thanks anyway.

yeah I did that. If I take the DoCmd.Close line out of the for loop and add a message box or some test code I get the same error. If I completely remove the second for loop and instead print the arrays, it works fine and the arrays print exactly as expected. Additionally, that is the entirety of...

I tried that and I even used a completely different variable for the second loop and I still get the error

The code is called from a form with no source that I use as the "Main Menu" that just has a lot of buttons on it to navigate to different forms. The Module is public so that it can be called by any button that is used to open one of the main forms. The problem that I am having, which is why I am...

That is exactly what I did.

That is actually a helpful suggestion thanks. I have already verified that all my previous loops are properly closed and do what I expect them to do. I verified the indentation as well. If I completely remove the second For Loop everything works perfectly.

I didn't want to post my whole code because I didn't want to deal with people yelling about something that has nothing to do with my question, (which was literally the second response to my question). Even if I replace my code in the first loop with a Message box with a test message I have the...

openForms is just an array of strings. I am not removing anything from the array.

Is there another explanation for the error "For Loop Not Initialized" other than : You jumped into the middle of a For...Next loop. Remove the jump into the loop. Placing labels inside a For...Next loop isn't recommended. Every solution I have been able to find is that you have jumped into the...

So I am having a problem with this that came up later because my database is still in design mode and I am making frequent changes. Now I can easily comment this code out and wait until I put out the operational executable only copy. However, it slows down switching from one form to another...

And another thing! Don't come back here like, why are you being so mean? I was just trying to help! No you weren't. You were trying to be right and superior. Next time try something like hey that code is a huge improvement on that previous suggestion. Thanks so much for contributing to the...

You comment about having too many indexes means I need more tables is just wrong. I know all of these things and you people just literally don't believe that someone could need more indexes than Access has available and that is ridiculous. This is why I don't try to ask for help or help others...

I wouldn't call myself "an expert" but I do understand normalization. The issues I have, which would be alleviated by switching to SQL server, are things like table index limits, which at this time require me to horizontally split a table into multiple tables, which then require more subforms on...

Actually it would BECAUSE my database is properly normalized, but that is beyond the scope of this topic. I really dislike that people always assume that when a person has a database issue, they assume the person knows nothing about normalization. There are many other factors that can diminish...

I realize the last time a comment was made on this was 2016, but here goes. So I used a version of the code supplied by Gizmo and it worked great. The issue I have with it is that I have a very complex database utilizing multiple subforms on each tab and multiple forms that I would like to...