ACC97: How to Animate the Office Assistant

Last reviewed: October 24, 1997
Article ID: Q161014
The information in this article applies to:
  • Microsoft Access 97

SUMMARY

Moderate: Requires basic macro, coding, and interoperability skills.

There may be times when you would like to animate the movements of the Office Assistant in response to actions performed in your application. For instance, you may want to have the Assistant appear when you open a particular form. Or you may want the Assistant to react when a certain event is triggered. This article shows you how to do so.

This article assumes that you are familiar with Visual Basic for Applications and with creating Microsoft Access applications using the programming tools provided with Microsoft Access. For more information about Visual Basic for Applications, please refer to the "Building Applications with Microsoft Access 97" manual.

NOTE: A demonstration of the techniques used in this article can be seen in the sample file, FrmSmp97.exe. For information about how to obtain this sample file, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q175066
   TITLE     : ACC97: Microsoft Access 97 Sample Forms Available on MSL

MORE INFORMATION

The following example creates three event procedures that control the behavior of the Clippit Assistant. The first procedure selects Clippit and makes the Assistant visible when the Employees form is opened. The second procedure instructs Clippit to simulate listening to the computer when a field is updated. The third procedure closes the Assistant when the form is closed and resets some of the properties of the Assistant.

CAUTION: Following the steps in this example will modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and perform these steps on a copy of the database.

NOTE: This example assumes you have the Clippit Assistant (Clippit.act) installed on your computer. By default the Assistants are installed in the C:\Program Files\Microsoft Office\Office\Actors\ folder.

Starting the Assistant

  1. Open the sample database Northwind.mdb.

  2. Open the Employees form in Design view.

  3. Set the OnOpen property of the form to the following event procedure.

    NOTE: The following sample code requires that you have a reference to the Microsoft Office 8.0 Object Library in your database. To create the reference, open any module in Design view, click References on the Tools menu, and then click the Microsoft Office 8.0 Object Library.

          Private Sub Form_Open(Cancel As Integer)
    
             With Assistant
                .Filename = "Clippit.act"  ' Returns or sets the name of the
                                            ' active Office Assistant.
                .Visible = True
                .Animation = msoAnimationGreeting   ' Simulates greeting user.
                .Sounds = True
                .SearchWhenProgramming = True
                .FeatureTips = True
             End With
          End Sub
    
    

  4. Close the Module window.

Changing the Movement of the Assistant

  1. Set the AfterUpdate property of the FirstName text box to the following event procedure:

          Private Sub FirstName_AfterUpdate()
    
             With Assistant
                .Animation = msoAnimationListensToComputer  ' Animates
                                                            ' Assistant.
             End With
          End Sub
    
    

  2. Close the Module window.

Closing the Assistant When the Form Closes

  1. Set the OnClose property of the form to the following event procedure:

          Private Sub Form_Close()
    
             If Assistant.Visible = True Then
                With Assistant
                   .AssistWithHelp = False
                   .SearchWhenProgramming = False
                   .GuessHelp = False
                   .FeatureTips = False
                   .Visible = False
                End With
             End If
          End Sub
    
    

  2. Close the Module window.

  3. Save the form, and then open it in Form view. Note that the Powerpup Assistant is displayed.

  4. Type a new name in the First Name field and press ENTER. Note that the Powerpup Assistant responds with "listening" animation.

  5. Close the form. Note that the Clippit Assistant closes.

REFERENCES

For more information about using the Office Assistant, search the Help Index for "Assistant," or ask the Microsoft Access 97 Office Assistant.

To see a list of file names that correspond to the different Office Assistants, search the Help Index for "FileName Property."


Additional query words: program code help asst customize modify user
Keywords : kbprg kbusage
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbhowto


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 24, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.