 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / November 2005Simple Forms Collection Question
I'm tying to get a handle on the forms collection. If I have 5 forms in my application, why don't I get a message box for each of the forms in my application using the code below? Currently, I'm only gettng the name of the form where this handler exists and none of the other forms in the application. Private Sub Detail_Click() Dim Objform As Form For Each Objform In Application.Forms MsgBox (ObjForm.Name) Next End Sub Thanks! Bernie > I'm tying to get a handle on the forms collection. If I have 5 forms > in my application, why don't I get a message box for each of the [quoted text clipped - 10 lines] > > End Sub The Forms collection only includes "open" forms. Similar is true of the Reports collection.  SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Ok, that helps a bunch, but, is there a way to iterate through all the forms in an application without them being open? Thanks B > > I'm tying to get a handle on the forms collection. If I have 5 forms > > in my application, why don't I get a message box for each of the [quoted text clipped - 13 lines] > The Forms collection only includes "open" forms. Similar is true of the Reports > collection. > Ok, that helps a bunch, but, is there a way to iterate through all > the forms in an application without them being open? CurrentDB.Containers("Forms").Documents(n).Name Will return the form name of each form if n is substituted with a value from zero to the number of forms minus 1, but you cannot use that to get at all the same properties that the Forms collection does. SignatureI don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.