[AccessD] Invisible forms

artful at rogers.com artful at rogers.com
Mon Jan 29 13:19:55 CST 2007


Interesting, JC. Were I not occupied with BE projects, I would definitely play with this. Keep us posted!

A.

----- Original Message ----
From: JWColby <jwcolby at colbyconsulting.com>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Monday, January 29, 2007 12:30:43 PM
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


More information about the AccessD mailing list