Tip of the Month (October 2000)

Adding voice recording to your forms

Our sample expense tracking form allows you to associate a recorded message with a record. That way, you can use the voice recorder to create a voice note, tie it to a record in the database, then play it later by just pressing a button on the form.

Creating this is a snap. First, create a text column in your table to store the name of the file that has the recording in it. Then, on your form, create two controls. One is an edit control to allow the user to pick the recording. Make sure the "File selection on click" box is set. The other is a command button whose action is set to "Run External" and whose argument is set to the column connected to the edit control (leave the command blank).