ACC: Sound Object on Form Does Not Play Sound When Clicked

• Microsoft Access versions 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you click an embedded sound object on a form (such as a Sound Recorder icon), a sound playing application (such as Sound Recorder) does not open as expected. This occurs only after you use the Create New option of the Insert Object command to create the sound object on the form.

CAUSE

If you use the Create New option of the Insert Object command to add a sound object to a form, no application file, such as a wave file (*.wav), is associated with the object. Consequently, when you click the object, no application is started.

RESOLUTION

Associate a sound wave file (*.wav) with the sound object on the form. To do so, follow these steps:

1. Start Microsoft Access.

2. Create a new database as follows:

       a. On the File menu, click New Database.
   

       b. In the New Database dialog box, click the General tab.
   

       c. Click the Blank Database icon and click OK.
   

       d. In the File New Database dialog box, type SoundTest as the
          name of the database (.mdb).
   

       e. Click the Create button.
   

3. Create a new form as follows:

       a. In the Database window, click the Form tab.
   

       b. Click the New button.
   

       c. Select Design View from the list in the New Form dialog box.
   

       d. Click OK.
   

       e. On the File menu, click Save As/Export.
   

       f. In the Save As dialog box, type Form1 in the New Name box.
   

       g. Click OK.
   

4. Insert the OLE Object on the form as follows:

       a. On the Insert Menu, click Object.
   

       b. In the Insert Object dialog box, click "Create From File" and
          type in the path for the wave file, C:\Windows\System\Ringin.wav.
   

       c. Click OK.
   

5. Right-click the sound object and click Properties. Click the Data tab and set two properties as follows:

        Enabled = Yes
        Locked = No
   

6. Close the Properties box.

7. On the View menu, click Form.

8. Double-click the wave sound icon. Note that the wave file plays.

MORE INFORMATION

Steps to Reproduce Behavior

1. Follow steps 1 - 3 in the "Resolution" section.

2. Insert the OLE Object on the form as follows:

       a. On the Insert Menu, click Object.
   

       b. In the Insert Object dialog box click "Create New".
   

       c. Select Wave Sound from the Object Type list.
   

       d. Click the OK button
   

3. Notice that Sound Recorder starts. Close Sound Recorder.

4. Right-click the sound object and click Properties. Click the Data tab and set two properties as follows:

        Enabled = Yes
        Locked = No
   

5. On the View menu, click Form.

6. Double-click the Wave Sound object (OLE object) in the form. Note that Sound Recorder does not open as expected.

REFERENCES

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