[AccessD] Invisible forms

Just don't forget where you put them, John.  I've done that with my
glasses a few times. LOL

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Monday, January 29, 2007 9:31 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Invisible forms

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
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com