ACC: How to Record and Play Sounds from MS Access (95/97)

MORE INFORMATION

1. Create the following new table in Design view:

         Table: Messages
         -----------------------
         Field Name: Message
           Data Type: OLE Object
   					

2. Save the table as Messages, and then close the table.
3. Create a new form in Design view based on the Messages table.
4. Add the following controls to the form:

         Bound Object Frame:
           Name: Message
           ControlSource: Message
   
         Command Button:
           Name: RecordMessage
           Caption: Record
   
         Command Button:
           Name: PlayMessage
           Caption: Play
   					

5. Add the following event procedure to the OnClick property of the RecordMessage button:

         Me!Message.Class = "soundrec"
         Me!Message.Action = acOLECreateEmbed
         Me!Message.Verb = acOLEVerbPrimary
         Me!Message.Action = acOLEActivate
   					

6. Add the following event procedure to the OnClick property of the PlayMessage button:

   Me!Message.Action=7
   					

7. Switch the form to Form view.
8. To record a message, click the Record button to open the Windows Sound Recorder.
9. Record your message, and then click "Exit and Return to Messages" on the File menu. To play your recorded message, click the Play button.