Supressing Msgbox beep

[uncletreetrunk]

Hi all,

Is there a way to supress the beep from a msgbox using vba? Or a combination of msgbox types?

Thanks in advanced

[JoeM]

Its the second argument of the MsgBox function. As you type it into VBA, it should pop up the arguments (hit a comma after you type what you want the message to say, and it should give you the options).

Alternatively, you could create the MsgBox in a Macro, setting the Beep argument to "No", and use the "Convert Macros to Visual Baisc" to see what the code needs to look like.

[uncletreetrunk]

Thanks Joe,

Do you know which option has no sound? I know vbCritical has a different sound

When I tried creating a Macro for the beep argument, where do you disable the beep? I couldn't type anything in arguments.

Thanks for your help

*Disregard the beep comment, I'm stupid and called the beep method instead of msgbox xD

[JoeM]

Try creating a macro that shuts off the beep on a Message Box, and then convert your Macro to VBA, and then you can see exactly how it needs to be set.

[uncletreetrunk]

It's interesting, when I create a msgbox in the macro creator and disable the beep it works fine. After converting to vba the beep is enabled T.T

Sorry my access experience is very limited. I barely know enough vba to run the database. I've never used the macro creator before.

[JoeM]

I checked it out myself, and it appears that you have stumbled onto something very odd - you can suppress the MsgBox beep in a Macro, but not via VBA. I have some discussions on that elsewhere through Google searches.

I did find a link that has a workaround. See here: http://www.freevbcode.com/ShowCode.asp?ID=1108

[uncletreetrunk]

hmmm that is interesting... I wonder why that is. The dev's for access continue to intrigue me.

Oooo cool! Thank you very much! Ummm quick question, how do I apply this to my system?

LOL sorry never installed something like this before

[June7]

Interesting, I do MsgBox in VBA and don't get beep. Not sure how that is accomplished, don't remember ever getting beep nor doing anything to prevent.

[JoeM]

Interesting, I do MsgBox in VBA and don't get beep. Not sure how that is accomplished, don't remember ever getting beep nor doing anything to prevent.

Its more of a "plonk" than a "beep".
Forgive me for asking (probably a silly question), but do you have your volume turned off or set to mute?

[June7]

First thing I checked. Volume was on, set low, so I turned it up to max. Still no beep or plonk. That was computer at work. Here I get plonk.