Re: Is form Open?

From: StCyrM (stcyrm_at_aol.com)
Date: 10/06/04


Date: 06 Oct 2004 01:21:21 GMT

Hi Lyle

You can use the following function to check if the a form is loaded.

Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.

Function FormIsLoaded(MyFormName As String) As Boolean
'
' Determines if a form is loaded.
'
Dim i As Integer
  FormIsLoaded = False
  For i = 0 To Forms.Count - 1
    If Forms(i).FormName = MyFormName Then
      FormIsLoaded = True
      Exit Function ' Quit function once form has been found.
    End If
  Next i
End Function

>I need to have one form check to see if another form is open. Anyone know
>how to do this??
>Thanks,
>Lyle



Relevant Pages

  • Re: Please help!
    ... Best regards ... Maurice St-Cyr ... Micro Systems Consultants, Inc. ... >been asked to put a field in that can hold multiple ...
    (microsoft.public.access.forms)
  • Re: MS Access just hangs when opening
    ... Best Regards ... Maurice St-Cyr ... Micro Systems Consultants, Inc. ... >Access itself, and it hangs for a very long time, ...
    (microsoft.public.access.gettingstarted)
  • Re: Is MS ACCESS a multi user database
    ... You can have up to 255 concurrent users. ... Best Regards ... Maurice St-Cyr ... Micro Systems Consultants, Inc. ...
    (microsoft.public.access.gettingstarted)
  • Re: Joining 2 fields
    ... You could combine the 2 fields into a Memo field. ... Best Regards ... Maurice St-Cyr ... Micro Systems Consultants, Inc. ...
    (microsoft.public.access.forms)
  • Re: Input Mask
    ... Maurice St-Cyr ... Micro Systems Consultants, Inc. ... the field name that contains the number to change, as a string. ... >local area code in the telephone number. ...
    (microsoft.public.access.forms)

Loading