Detecting Open Forms

R

Ross

How can I Loop Thru and determine which forms are OPEN
regardless of whether or not they have Focus / Active.
 
B

Bas Cost Budde

Ross said:
How can I Loop Thru and determine which forms are OPEN
regardless of whether or not they have Focus / Active.
Click to expand...

The Forms collection tells you exactly that.
 
M

Marshall Barton

Ross said:
How can I Loop Thru and determine which forms are OPEN
regardless of whether or not they have Focus / Active.
Click to expand...


The Forms collection only contains open form objects.

Newer versions of Access have an AllForms collection and
each member can be tested with its IsLoadeds property to see
if it's open..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA office 365 on windows 10 0
Hyperlink fails to open on the first click 0
VBA word change keys 0
How do I set focus (and select text) on a text box on a modeless userform? 0
How to make scroll bar permanently visible, Word 365 0
Mis-performing MP4 files in Mac PPT 1
Adding data to MS Access from csv file 0
Managing multiple jobs in a fabrication shop 0

Top