W whdyck Registered User. Local time Today, 04:44 Joined Aug 8, 2011 Messages 169 Aug 22, 2011 #1 I'm using Access 2003. Sorry if this is a dumb question, but is there VBA code to detect whether a given form is already open? (I've googled for a while, but I can't seem to find the answer.) Thanks. Wayne
I'm using Access 2003. Sorry if this is a dumb question, but is there VBA code to detect whether a given form is already open? (I've googled for a while, but I can't seem to find the answer.) Thanks. Wayne
M Mr. B "Doctor Access" Local time Today, 04:44 Joined May 20, 2009 Messages 1,932 Aug 22, 2011 #2 This code will do what you want: http://access.mvps.org/access/forms/frm0002.htm
MarkK bit cruncher Local time Today, 02:44 Joined Mar 17, 2004 Messages 8,458 Aug 22, 2011 #3 Also ... Code: currentproject.allforms("formname").isloaded
W whdyck Registered User. Local time Today, 04:44 Joined Aug 8, 2011 Messages 169 Aug 22, 2011 #4 Mr. B said: This code will do what you want: http://access.mvps.org/access/forms/frm0002.htm Click to expand... Worked great! Thanks. Wayne
Mr. B said: This code will do what you want: http://access.mvps.org/access/forms/frm0002.htm Click to expand... Worked great! Thanks. Wayne
W whdyck Registered User. Local time Today, 04:44 Joined Aug 8, 2011 Messages 169 Aug 22, 2011 #5 lagbolt said: Also ... Code: currentproject.allforms("formname").isloaded Click to expand... Works great. And it's short and to the point. Thanks.
lagbolt said: Also ... Code: currentproject.allforms("formname").isloaded Click to expand... Works great. And it's short and to the point. Thanks.
MarkK bit cruncher Local time Today, 02:44 Joined Mar 17, 2004 Messages 8,458 Aug 23, 2011 #6 Yeah, there didn't used to be a CurrentProject object with an AllForms collection... I think that might have appeared in the Access 2000.
Yeah, there didn't used to be a CurrentProject object with an AllForms collection... I think that might have appeared in the Access 2000.
