I also had another idea, but I don't realy know if this can be done.
I have added a splash screen when the db opens. What I could do is to load every form then, because the splash screen works with a timer anyway... and then keep them loaded and show and hide them instead of opening and closing them. I know there is a load, show, hide and unload property in VB
, but I don't know if VBA has these properties... (and if yes, how to use them)
If this is possible, it could also solve my problem, because I would only load the forms that will be used more often, and the ones that would be used from time to time or even rarely I would open and close normally... If these ones has to load the picture every time, it would not be that bad... The forms that will load on the splash screen would make the picture loading pop up to appear, but when you load the application and they only appear then is not too bad. This could be a solution I can live with :)
The only thing that would be important than, is that they hide instead of closing and there would be no window for the hidden forms on the taskbar.
Don't know if this is clear for you.