Audio?

I'm creating a database that will use a scanner to scan barcodes. The scanner
is pretty simple, nothing complicated. The scanner will be used to scan
barcodes on boxes and once scanned, it will automatically populate a field in
Access.

My questions is, is it possible to have audio with the scanner that will
announce the barcode number? Does Access have this feature? Like I said, the
scanner is simple, I don't need to program it or anything. I can use it with
Word or Excel. I scan a bar code for example, and if Word is up, the barcode
number will automatically appear on the Word document.

Does anyone know if Access has the feature of audio with a scanner attached?

Thanks.

On Wed, 29 Oct 2008 19:10:01 -0700, Antney
wrote:

Let me make sure I understand. You scan a barcode into a textbox, and
then you want Access to automatically "speak" that value? No, there
is no built-in functionality that can do that.
You may want to look at phone system software that can read the input
from a phone and speak "you entered the account number 123456789 - do
you want to proceed?"
Not for the faint of heart.

-Tom.
Microsoft Access MVP


I'm creating a database that will use a scanner to scan barcodes. The scanner
is pretty simple, nothing complicated. The scanner will be used to scan
barcodes on boxes and once scanned, it will automatically populate a field in
Access.

My questions is, is it possible to have audio with the scanner that will
announce the barcode number? Does Access have this feature? Like I said, the
scanner is simple, I don't need to program it or anything. I can use it with
Word or Excel. I scan a bar code for example, and if Word is up, the barcode
number will automatically appear on the Word document.

Does anyone know if Access has the feature of audio with a scanner attached?

Thanks.

On Wed, 29 Oct 2008 19:10:01 -0700, Antney
wrote:

I'm creating a database that will use a scanner to scan barcodes. The scanner
is pretty simple, nothing complicated. The scanner will be used to scan
barcodes on boxes and once scanned, it will automatically populate a field in
Access.

My questions is, is it possible to have audio with the scanner that will
announce the barcode number? Does Access have this feature? Like I said, the
scanner is simple, I don't need to program it or anything. I can use it with
Word or Excel. I scan a bar code for example, and if Word is up, the barcode
number will automatically appear on the Word document.

Does anyone know if Access has the feature of audio with a scanner attached?

Thanks.

There's nothing built in to Access. You may be able to get some third party
software such as Dragon Naturally Speaking (not a recommendation, just one
that I've heard of); I'm not sure how to interface it with Access. Good luck.
--

John W. Vinson [MVP]

On Oct 30, 2:10*am, Antney wrote:
I'm creating a database that will use a scanner to scan barcodes. The scanner
is pretty simple, nothing complicated. The scanner will be used to scan
barcodes on boxes and once scanned, it will automatically populate a field in
Access.

My questions is, is it possible to have audio with the scanner that will
announce the barcode number? Does Access have this feature? Like I said, the
scanner is simple, I don't need to program it or anything. I can use it with
Word or Excel. I scan a bar code for example, and if Word is up, the barcode
number will automatically appear on the Word document.

Does anyone know if Access has the feature of audio with a scanner attached?

Thanks.

Hi Ant

I saw this and it prompted me to try a bit of lateral thinking. If
(and it's a big if, I suppose) you can get hold of a wav file for each
of the 0 - 9 digits then, with appropriate parsing and Select Case
usage you might get something like this to work where the code plays
each sound in turn (it does actually play the sounds I used as a
test).

Public Function MySounds()
Dim xx As Double
Dim strSound As String
strSound = "C:\Program Files\Windows Media Player\wmplayer.exe"
strSound = strSound & " c:\windows\media\chimes.wav"
strSound = strSound & " c:\windows\media\chord.wav"
strSound = strSound & " c:\windows\media\ringin.wav"
xx = Shell(strSound, vbHide)
End Function

where you build your series of wav sounds according to the digits in
the bar code.

Worth a try - probably a lot simpler than trying to use speech
recognition.

Jeff.

On Thu, 30 Oct 2008 14:16:24 -0700 (PDT), jbguernsey
wrote:

On Oct 30, 2:10*am, Antney wrote:
I'm creating a database that will use a scanner to scan barcodes. The scanner
is pretty simple, nothing complicated. The scanner will be used to scan
barcodes on boxes and once scanned, it will automatically populate a field in
Access.

My questions is, is it possible to have audio with the scanner that will
announce the barcode number? Does Access have this feature? Like I said, the
scanner is simple, I don't need to program it or anything. I can use it with
Word or Excel. I scan a bar code for example, and if Word is up, the barcode
number will automatically appear on the Word document.

Does anyone know if Access has the feature of audio with a scanner attached?

Thanks.

Hi Ant

I saw this and it prompted me to try a bit of lateral thinking. If
(and it's a big if, I suppose) you can get hold of a wav file for each
of the 0 - 9 digits then, with appropriate parsing and Select Case
usage you might get something like this to work where the code plays
each sound in turn (it does actually play the sounds I used as a
test).

Public Function MySounds()
Dim xx As Double
Dim strSound As String
strSound = "C:\Program Files\Windows Media Player\wmplayer.exe"
strSound = strSound & " c:\windows\media\chimes.wav"
strSound = strSound & " c:\windows\media\chord.wav"
strSound = strSound & " c:\windows\media\ringin.wav"
xx = Shell(strSound, vbHide)
End Function

Or even record the ten digits yourself, if you have a microphone; create a
little ten row table with an Integer primary key, values zero through 9, and
the filename of the .wav file of each. Then open a recordset based on the
table, and step through the text string returned by the scanner and build up
strSound just as you're suggesting here.

--

John W. Vinson [MVP]

Thanks, I will try this.

"jbguernsey" wrote:

On Oct 30, 2:10 am, Antney wrote:
I'm creating a database that will use a scanner to scan barcodes. The scanner
is pretty simple, nothing complicated. The scanner will be used to scan
barcodes on boxes and once scanned, it will automatically populate a field in
Access.

My questions is, is it possible to have audio with the scanner that will
announce the barcode number? Does Access have this feature? Like I said, the
scanner is simple, I don't need to program it or anything. I can use it with
Word or Excel. I scan a bar code for example, and if Word is up, the barcode
number will automatically appear on the Word document.

Does anyone know if Access has the feature of audio with a scanner attached?

Thanks.

Hi Ant

I saw this and it prompted me to try a bit of lateral thinking. If
(and it's a big if, I suppose) you can get hold of a wav file for each
of the 0 - 9 digits then, with appropriate parsing and Select Case
usage you might get something like this to work where the code plays
each sound in turn (it does actually play the sounds I used as a
test).

Public Function MySounds()
Dim xx As Double
Dim strSound As String
strSound = "C:\Program Files\Windows Media Player\wmplayer.exe"
strSound = strSound & " c:\windows\media\chimes.wav"
strSound = strSound & " c:\windows\media\chord.wav"
strSound = strSound & " c:\windows\media\ringin.wav"
xx = Shell(strSound, vbHide)
End Function

where you build your series of wav sounds according to the digits in
the bar code.

Worth a try - probably a lot simpler than trying to use speech
recognition.

Jeff.

Thanks!

"John W. Vinson" wrote:

On Thu, 30 Oct 2008 14:16:24 -0700 (PDT), jbguernsey
wrote:

On Oct 30, 2:10 am, Antney wrote:
I'm creating a database that will use a scanner to scan barcodes. The scanner
is pretty simple, nothing complicated. The scanner will be used to scan
barcodes on boxes and once scanned, it will automatically populate a field in
Access.

My questions is, is it possible to have audio with the scanner that will
announce the barcode number? Does Access have this feature? Like I said, the
scanner is simple, I don't need to program it or anything. I can use it with
Word or Excel. I scan a bar code for example, and if Word is up, the barcode
number will automatically appear on the Word document.

Does anyone know if Access has the feature of audio with a scanner attached?

Thanks.

Hi Ant

I saw this and it prompted me to try a bit of lateral thinking. If
(and it's a big if, I suppose) you can get hold of a wav file for each
of the 0 - 9 digits then, with appropriate parsing and Select Case
usage you might get something like this to work where the code plays
each sound in turn (it does actually play the sounds I used as a
test).

Public Function MySounds()
Dim xx As Double
Dim strSound As String
strSound = "C:\Program Files\Windows Media Player\wmplayer.exe"
strSound = strSound & " c:\windows\media\chimes.wav"
strSound = strSound & " c:\windows\media\chord.wav"
strSound = strSound & " c:\windows\media\ringin.wav"
xx = Shell(strSound, vbHide)
End Function

Or even record the ten digits yourself, if you have a microphone; create a
little ten row table with an Integer primary key, values zero through 9, and
the filename of the .wav file of each. Then open a recordset based on the
table, and step through the text string returned by the scanner and build up
strSound just as you're suggesting here.

--

John W. Vinson [MVP]