Another "Can't open more database" thread

[Grooz13]

Ok I already asked some questions about this problems and I managed to go through it and it was ok... but my boss doesn't want it to be ok he wants it to be perfect!

I am no access expert but I Managed to do some really good vb codes and all and my forms look like a calendar but this form is one huge form...

30 listbox
about 50 textbox
and lot of queries to fill those text box...

I closed the queries and set them to nothing but alas... I can't seem to make it better and I really need some idea cause when those calendar are open(can only open one at a time else the other one doesn't fill correctly) I can't really open other forms else I will get cannot open more database error... it's really hard for me to get what I could do to fix this

 

[Uncle Gizmo]

I’m sorry but I don’t understand the question, could you please think about what you want and post a question that can be answered.

 

[Grooz13]

My forms are too big, but they need to big that big (with lots of listbox textbox and those things) and I can't really open them at the same time as the other forms... what can I do

 

[boblarson]

... what can I do

Tell your boss that you can't do it exactly as he wants because you've run into a technical limitation of Access. You can only have so many recordsets open at a time and having one for each form, one for each listbox and/or combo box, is just overtaxing the system.