Any Suggestions

[James]

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

Cheers

James

 

[Wayne Morgan]

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

The Forms collection contains the open forms.

 

[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

 

[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

 

[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

 

[Chris]

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
.

 

[HSalim]

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

 

[Dirk Goldgar]

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.

 

[HSalim]

Dirk,
That is correct. Forget my warning - that applies only to tables.
I could not get to Dev's site so I was writing from memory.
Here is the link to the article I was thinking of.
http://www.mvps.org/access/bugs/bugs0036.htm

Regards
HS