How can I record sound

mhb300 · #1 (**permalink**) 07-03-09, 03:55

Hi everybody,

I want to get a code for records sound, so I searched about it , and I found just this site

ACC2000: How to Record and Play Sounds from Microsoft Access

That for Access 2000 but does not work with 2003... Do you have some information about records sound for Access 2003

Than you

nckdryr · #2 (**permalink**) 07-03-09, 04:02

Why wouldn't that work for 2003? There's very few cases I've ran across where Access isn't backwards compatible.

mhb300 · #3 (**permalink**) 07-03-09, 08:27

Actually, I did exactly what was in that site, but it does not work.

If you try it, you may understood what happened.

This is the code

Quote:

Option Compare Database

Private Sub PlayMessage___Click()
Me.message.Action = 7
End Sub

Private Sub RecordMessage_Click()
With Me.message
.Class = "soundrec"
.Action = acOLECreateEmbed
.Verb = acOLEVerbPrimary
.Action = acOLEActivate
End With

End Sub

The program in the attachment, If you want to see what I do.

Thank you sir

nckdryr · #4 (**permalink**) 07-03-09, 15:11

There were a few irregularities in the db you attached, I couldn't seem to get rid of them. So I started my own dB (I have 2007 btw, but I saved it also in 2003 format) and did it, and it worked fine. Also, I tweaked what MS suggested just a little as you can see.