How to Make a Beep or Play a Sound in Access

In this video, I will show you how to make Microsoft Access sound a beep. More importantly, I'll show you how to make a series of beeps, so whether you need 2, 3, 4, or more beeps, I've got you covered. We'll use a For/Next loop in VBA plus a little sleep timer for a delay.

David from Cedar Rapids, Iowa (a Platinum Member) asks: I have a very long report that I run every morning. It takes a good 5 to 10 minutes. When it's finished, I'd love for the database to make some kind of noise to let me know it's ready. I played around with the Beep function, and it works OK, but it's easy to miss one beep. If I try to get it to play like 10 times in a row, it still just sounds like one beep. Any ideas?

Members

Members will learn how to actually play a real WAV sound file in VBA, so the sky is the limit as far as the sounds you can hear from your databases. You can play Star Trek sounds... all... day... long... :)

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Links

• Intro to VBA: https://599cd.com/Sleep
• For Next Loops: https://599cd.com/ForNext
• DateAdd Function: https://599cd.com/DateAdd
• Sleep: https://599cd.com/Sleep
• PlaySound Code Vault: https://599cd.com/PlaySoundCode
• Sound Site 1: https://tinyurl.com/ycrqdt38
• Sound Site 2: https://tinyurl.com/ycelvv3v
• Sound Site 3: https://tinyurl.com/y53rvt4m

Suggested Course

• Access Developer 1: https://599cd.com/ACD1

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, beep, sound, wav file, mp3, play sound, beep macro action, beeping sound, How to play sound in Access, How do you add audio to Access, Play Sound on Your Microsoft Access Forms