Sound other than Beep

[Design by Sue]

I am writing a piece of code for a message box and really want get the user's attention, more than the standard DoCmd.beep. Is there any way to add another sound, something more noticeable?

Thanks
Sue

 

[TJPoorman]

A quick Google search came up with this:

http://bytes.com/topic/access/answers/902321-how-link-sound-wav-file-button

 

[Design by Sue]

You are better than I am at Google - thank you! Will give that a try (though a gunshot may not be the best choice - I will need to find another sound!)

Sue

 

[Design by Sue]

That works - my concern is that this is a split database - need to know where to put the sound so it can be found. Is there another sound, standard to Access, that will always be available??

 

[TJPoorman]

You could put the .wav file in the same location as your backend file so all users would have access to it.

 

[Design by Sue]

Will test that out - wondering if the path in the code works as it is or will need work.

 

[Design by Sue]

Is there a way to store the wav file in a table and reference that in the code?

Sue

 

[Design by Sue]

On http://www.cpearson.com/excel/PlaySound.aspx I found how to access the Windows sounds - that work better as I don't have to store a wav file (though I did like the loud beep I found)

Thanks for your help
Sue