[AccessD] IsLoaded function

The .IsLoaded property of an access object is in Access 2003.  

I could see where an IsLoaded function may have difficulty if a version of
Access uses IsLoaded as the name of a property.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Tuesday, March 23, 2010 8:45 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] IsLoaded function

Unless you are working with Access 97 or earlier. In which case IsLoaded()
is not built in. In which case the code looks like this...

Function IsLoaded(FrmName As String) As Boolean
Dim i As Integer

IsLoaded = False
For i = 0 To Forms.Count - 1
    If Forms(i).Name = FrmName Then
        IsLoaded = True
        Exit Function
    End If
Next i

End Function

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Tuesday, March 23, 2010 9:35 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] IsLoaded function

It looks like .IsLoaded is a property of an access object, rather than a
function.

Like this:

    If CurrentProject.AllForms(stgFormName).IsLoaded = False Then
        ... Do Something
    End If

HTH,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, March 23, 2010 8:26 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] IsLoaded function

For some reason I'm a "procedure not found" error on a call to the function
IsLoaded(). Does anyone have a copy of it handy? I thought it was built-in
but maybe I got it from ADH or somewhere.

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com