Control Sound Volume Using VBA

Posted on 2011-10-06
Last Modified: 2013-11-27
Just wondering if this is even possible. Here's the deal, I have a DB in our front lobby that plays a safety video for visitors. We set the speaker system at the appropriate volume for that. I wanted to add some background music to play when the video is not playing. So basically I need two different volume levels.

Basically the music is at a level 3 and when the video starts the music stops and the volume goes to say, 7. When the video finishes I can send it back down to 3. If that makes sense.

I may be asking just a bit too much of Access, but I figured why not ask anyway. Thanks for any help you can give me.
Question by:G Scott
    LVL 3

    Accepted Solution


    This should work it's a setVolume function for VBA, depends on your version of Windows and so on.. Code.txt
    LVL 1

    Author Closing Comment

    by:G Scott
    That worked perfectly! Thank you so much.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now