Any Suggestions

  • Thread starter Thread starter James
  • Start date Start date
J

James

Is there any way that I can just say all forms.visible =
true and all forms.visible = false?

Cheers

James
 
Dim frm As Form
For Each frm In Forms
frm.Visible = True
Next

The Forms collection contains the open forms.
 
Thanks

So all I have to do with that now is to just for the on
open command on the report the code below and then on
close the code below but visible = false?

That will make ALL the forms that are open invisible or
ALL the forms in the database invisible?

Cheers

james
 
Thanks

So all I have to do with that now is to just for the on
open command on the report the code below and then on
close the code below but visible = false?

That will make ALL the forms that are open invisible or
ALL the forms in the database invisible?

Cheers

james
 
Thanks

So all I have to do with that now is to just for the on
open command on the report the code below and then on
close the code below but visible = false?

That will make ALL the forms that are open invisible or
ALL the forms in the database invisible?

Cheers

james
 
All the forms that are open.


Chris

-----Original Message-----
Thanks

So all I have to do with that now is to just for the on
open command on the report the code below and then on
close the code below but visible = false?

That will make ALL the forms that are open invisible or
ALL the forms in the database invisible?

Cheers

james
.
 
Remember that setting a form to be not visible does not close the form, so
you should bring them back to visible or close them later.
If you are looking to Hide the form then you could do that too, - look in
www.mvps.org/access for code to hide database objects.
be warned though that if you compact the database while the form is hidden,
you will delete the form.
This behaviour happens only when you set the hiden property by code - not if
you manually hide the form.

HS
 
HSalim said:
Remember that setting a form to be not visible does not close the
form, so you should bring them back to visible or close them later.
If you are looking to Hide the form then you could do that too, -
look in www.mvps.org/access for code to hide database objects.
be warned though that if you compact the database while the form is
hidden, you will delete the form.
This behaviour happens only when you set the hiden property by code -
not if you manually hide the form.

I believe you can safely hide an object (in the database window, which
is what we're talking about, right?) using code, in A2K or later, by
using the Application.SetHiddenAttribute method.
 
Back
Top