Adding A Sound Clip To Query Database Response Follow

0

I have been using the query the database function to scan through our inventory and print labels for the inventory that is listed in the excel sheet that I have linked to the database.

I am curious as to if there is a way to add a sound to the programming so that when an item is scanned and does not exist on the list, a sound is associated with the appearance of the message that pops up on the screen saying that the item is not found in the database.  Sometimes we need to scan from a distance from the computer so not having to read the screen and having a sound indicator would be very useful.  Any suggestions greatly appreciated.  Thanks. 

3 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

You can make the computer beep using VBScript with something like the below:

 

Set oShell = CreateObject("Wscript.Shell")
oShell.Run "%comspec% /c echo " & Chr(7), 0, False
 
Note sure if there is a VBS event that is suited for putting it into though.
0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

You can make the computer beep using VBScript with something like the below:

 

Set oShell = CreateObject("Wscript.Shell")
oShell.Run "%comspec% /c echo " & Chr(7), 0, False
 
Note sure if there is a VBS event that is suited for putting it into though.
0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

You can make the computer beep using VBScript with something like the below:

 

Set oShell = CreateObject("Wscript.Shell")
oShell.Run "%comspec% /c echo " & Chr(7), 0, False
 
Note sure if there is a VBS event that is suited for putting it into though.

Please sign in to leave a comment.