> Cheers Tony,
>
> Do you know how I could implement a sound file which would play upon the
> scanning of an invalid part?
>
> The vb code which produces a warning (pop-up) in my application is:
>
> If StrValid = 0 Then
> MsgBox "This part does not exist in Item Master: " & _
> [Forms] ! [Actual Stocktake]![TxtProd] & Chr (13) & _
> "Enter a valid part number", vbInformation,"Invalid
> Part"
> [Forms]![Actual Stocktake].undo
> [Forms]![Actual Stocktake]![TxtCarStatus] = " "
> [Forms]![Actual Stocktake]![TxtMasterstatus] = " "
>
> What I need is a bit of code which would also produce a warning sound. If
> you can help, I would really appreciate it.
>
> Thanks
>
> "Tony Toews" wrote:
>
>> Jack <Jack[ at ]discussions.microsoft.com> wrote:
>>
>> >I am in the process of developing a stocktake program. I can get the
>> >barcode
>> >scanner to work well with Access, but what I need to do is have the
>> >program
>> >communicate with the scanner so that when a invalid barcode no is
>> >scanned, a
>> >sound is emitted. A different sound will also need to be emitted for a
>> >valid
>> >barcode no. Is there some way of configuring the barcode scanner to make
>> >two
>> >different sounds? I have an item master table in access which records
>> >all
>> >valid and invalid barcode numbers.
>>
>> That depends on the bar code scanner. You will need to ask the bar
>> code vendor how you can do this. They may not know how to do this in
>> Access so if nothing else ask for the Visual Basic solution which
>> should work.
>>
>> Also you might want to have different noises on the PC.
>>
>> Tony
>> --
>> Tony Toews, Microsoft Access MVP
>> Please respond only in the newsgroups so that others can
>> read the entire thread of messages.
>> Microsoft Access Links, Hints, Tips & Accounting Systems at
>>
http://www.granite.ab.ca/accsmstr.htm>>