Assistant Property [Access 2003 VBA Language Reference]

You can use the Assistant property to return a reference to the Assistant object. Read-only Assistant object.


expression Required. An expression that returns one of the objects in the Applies To list.


The following example uses the Assistant property of the Application object to manipulate various properties and methods of the Assistant object.

Public Sub AnimateAssistant()

    Dim blnState As Boolean

    With Assistant
        ' Save Assistant's visible state.
        blnState = .Visible

        ' Make Assistant visible.
        If blnState = False Then .Visible = True

        ' Animate Assistant.
        .Animation = msoAnimationAppear

        ' Display Assistant object's Item and FileName properties.
        MsgBox "Hello, my name is " & .Item & ". I live in " & _
.FileName, , "Assistant Information:"

        ' Return Assistant's visible state to original setting.
        .Visible = blnState
    End With
End Sub

Applies to | Application Object