Channel: Computer Learning Zone

Category: Education

Tags: beep#tutorialhow to play sound in access#msaccessms accesssoundwav fileplay sound#microsoftaccessbeep macro actionplay sound on your microsoft access forms#howtobeeping sound#lessonmp3#trainingmicrosoft access#help#database#learnhow do you add audio to accessms access tutorial

Description: 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? Silver Members and up get access to an Extended Cut of this video. 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... :) MEMBERS VIDEO: youtu.be/6GOGffwFBw8 BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/PlaySound LINKS: Intro to VBA: 599cd.com/Sleep For Next Loops: 599cd.com/ForNext DateAdd Function: 599cd.com/DateAdd Sleep: 599cd.com/Sleep PlaySound Code Vault: 599cd.com/PlaySoundCode Sound Site 1: tinyurl.com/ycrqdt38 Sound Site 2: tinyurl.com/ycelvv3v Sound Site 3: tinyurl.com/y53rvt4m SUGGESTED COURSE: Access Developer 1: 599cd.com/ACD1 OTHER COURSES: FREE Access Beginner Level 1: 599cd.com/Free1 $1 Access Level 2: 599cd.com/1Dollar FREE TEMPLATE DOWNLOADS: TechHelp Free Templates: 599cd.com/THFree Blank Template: 599cd.com/Blank Contact Management: 599cd.com/Contacts Order Entry & Invoicing: 599cd.com/Invoicing More Access Templates: 599cd.com/AccessTemplates ADDITIONAL RESOURCES: Donate to my Tip Jar: 599cd.com/TipJar Get on my Mailing List: 599cd.com/YTML Contact Me: 599cd.com/Contact TechHelp: 599cd.com/TechHelp Consulting Help: 599cd.com/DevNet Twitter: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access 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 QUESTIONS: Please feel free to post your questions or comments below. Thanks.