This documentation is archived and is not being maintained.

Assistant Property [Access 2003 VBA Language Reference]

Office 2003

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

expression.Assistant

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

Example

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


Show: