Loaded Forms

[virencm]

Hi

Is there a way of knowing which forms are loaded in the database?

viren

 

[virencm]

Is there a way i can get a list of all loaded forms in my database?

viren

 

[boblarson]

Function RetFormsLoaded() As String
Dim strList As String
Dim frm As Form

For each frm In Forms
  strList = strList & frm.Name & vbCrLf
Next frm

RetFormsLoaded = strList

That should do it.

 

[boblarson]

And you know that LOADED means open (in any view).

 

[virencm]

Hi Bob

Thanks for your quick reply.
I dont know how to incorporate this code into the database.
Do I need to create a list box / command button and then attach this code to the on open event .. please help

Viren

 

[boblarson]

Hi Bob

Thanks for your quick reply.
I dont know how to incorporate this code into the database.
Do I need to create a list box / command button and then attach this code to the on open event .. please help

Viren

For what are you wanting to know what forms are loaded (open)? That would kind of determine where it needs to be.