[AccessD] Invisible forms

JWColby jwcolby at colbyconsulting.com
Mon Jan 29 11:30:43 CST 2007


I just discovered something interesting.  I am working on a progress meter
for my framework.  There is a class for the progress meter which loads an
instance of the progress meter FORM using the syntax:
 
set frmMyPM = new form_ProgressMeter
 
This syntax loads the CLASS for the form, and in fact will not load a form
if it has no "module behind it".  The interesting thing is that by going
this route, I can then set the visible property of the form to false (hide
the form) and it does NOT show up in Window/Unhide.
 
It appears that only objects in Access' collection of open objects appears
in that window/unhide collection, and these forms loaded using this syntax
does not get displayed, which means that users (including the developer)
can't go unhide them.
 
Which of course leads me to...
 
I use little forms bound to a small recordset in a given back end in order
to hold a lock on that BE and thus make manipulations of everything faster.
I open that form and then hide it.  Unfortunately it is in the
Window/unhide.  Using a method like this, I can open these forms and truly
hide them so that they just flat cannot be seen ever.
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 



More information about the AccessD mailing list