Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107

    Unanswered: simple thing .. is a query def open?

    hey there,

    i'm looking for quite an easy thing i guess, but i got stuck somehow. I'm searching for a line of code to check whether a certain querydef is open or not.
    I've got an timer event checking that should pop up a dialog when a certain query is closed.

    any ideas?

  2. #2
    Join Date
    Mar 2004
    Location
    Berlin, Germany
    Posts
    107
    i solved the problem on my own .. e.g. with a little help from google.

    this little routine does the trick .. shows you whether an object (form, query, report) is loaded or not ..

    Public Function isOpen(Name As String, _
    Optional ObjectType As AcObjectType = acForm) _
    As Boolean
    isOpen = (SysCmd(acSysCmdGetObjectState, ObjectType, Name) <> 0)
    End Function

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •