Adding Sound Byte

[scubagal]

Hi all, I must say thanks to all who helped me in my prior postings. My database is up and working well. I would like to add a sound byte to the save button I placed in a form to alert ppl when they try to save without making sure all fields are filled in. It will give them a bubble when they try to save it but if they aren't paying attention and walk away then the data won't be saved. I am trying to dummy proof it as much as possible. Can I add a sound to a button? If so could someone tell me how? Thanks.

[scubagal]

I downloaded a "Beep" to use as the error. Just to make clear what I am needing. If someone hits the save button I have in my form, and the form has any blank fields I want the button to give an audible alarm. If all fields are complete when saved is hit nothing should happen except data being saved. Is this possible?

[ssanfu]

Try:

http://allenbrowne.com/func-04.html

or

http://access.mvps.org/access/api/api0011.htm

[rpeare]

http://www.techonthenet.com/access/q.../play_wav2.php

Very simple to follow instructions on how to.

[scubagal]

rpeare, thank you for your help. I want to do this but am so uptight about it. I do not understand what it is I am doing when it comes to VBA and coding. Is there any other sight I can use that can help me better understand what I am doing. That link you provided is specific to what someone needed but if I try to tailor it for me I will completely ruin what I've done so far. If you have taken me as far as you can I understand and say thank you immensely for all of your input.

[rpeare]

You almost never find a piece of code that does exactly what you want it to. In the example I gave you the person wanted to perform the playing of a sound on a form loading. the code is identical to what you would perform in the ON CLICK event of any button. You just use the exact same code but put it in the ON CLICK event of your button instead of the ON LOAD event of your form.

[scubagal]

I will give it a try and let you know how it goes. Thanks again for the help.