Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2009
    Posts
    22

    Question Unanswered: How can I record sound

    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

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    Why wouldn't that work for 2003? There's very few cases I've ran across where Access isn't backwards compatible.
    Me.Geek = True

  3. #3
    Join Date
    Jan 2009
    Posts
    22

    Smile

    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
    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
    Attached Files Attached Files

  4. #4
    Join Date
    May 2005
    Posts
    1,191
    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.
    Attached Files Attached Files
    Me.Geek = True

  5. #5
    Join Date
    Jan 2009
    Posts
    22

    Smile

    Thank you so much

    I tried it, and it is working , but I cannot record any sound... Did you try it to record?

  6. #6
    Join Date
    May 2005
    Posts
    1,191
    Yes, mine recorded and played it back, though I didn't test it thoroughly.
    Me.Geek = True

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •