By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,131 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Barcode Scanning

P: n/a
DS
Does anyone know anything about barcodes in Access. I don't want to
create them in Access. I merely want to scan whats already been created.
I need to scan Liquor bottles. I have the scanner hooked up.
Any help is appreciated,
Thanks
DS
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
"DS" <bo******@optonline.net> wrote in message
news:0c******************@fe08.lga...
Does anyone know anything about barcodes in Access. I don't want to create
them in Access. I merely want to scan whats already been created.
I need to scan Liquor bottles. I have the scanner hooked up.
Any help is appreciated,
Thanks
DS


There are two kinds of scanners typically used for this. One that attaches to
the PC's serial port and one that attaches via the keyboard. The former gives
you more control over what happens and when, but requires quite a bit of
knowledge and coding to configure.

When using the type that attaches to the keyboard connection the scanned "word"
appears to Windows exactly the same as if the user had typed the characters with
the keyboard so no special programming is required. You simply put focus on the
appropriate form control and scan the barcode. The rub is that the user has to
be aware of what he's doing. He could very easily scan the barcode when the
focus in not in the correct field so you would be well-served to create an
interface where this is unlikely to happen.

When I set this up I create a modal form that has only one control able to have
focus and I have the app play a particular WAV file upon a successful scan so
that it is obvious to the user that everything is working (or not working) as
expected. Obviously it makes a big difference if the user is expected to be
looking at the screen when the scanning is taking place.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

P: n/a
DS
Rick Brandt wrote:
"DS" <bo******@optonline.net> wrote in message
news:0c******************@fe08.lga...
Does anyone know anything about barcodes in Access. I don't want to create
them in Access. I merely want to scan whats already been created.
I need to scan Liquor bottles. I have the scanner hooked up.
Any help is appreciated,
Thanks
DS

There are two kinds of scanners typically used for this. One that attaches to
the PC's serial port and one that attaches via the keyboard. The former gives
you more control over what happens and when, but requires quite a bit of
knowledge and coding to configure.

When using the type that attaches to the keyboard connection the scanned "word"
appears to Windows exactly the same as if the user had typed the characters with
the keyboard so no special programming is required. You simply put focus on the
appropriate form control and scan the barcode. The rub is that the user has to
be aware of what he's doing. He could very easily scan the barcode when the
focus in not in the correct field so you would be well-served to create an
interface where this is unlikely to happen.

When I set this up I create a modal form that has only one control able to have
focus and I have the app play a particular WAV file upon a successful scan so
that it is obvious to the user that everything is working (or not working) as
expected. Obviously it makes a big difference if the user is expected to be
looking at the screen when the scanning is taking place.

I have the Keyboard wedge scanner. A quick question, what do I need to
do in Access to make this work. I have the Liqour bottle in one hand,
the scanner in another, and Access open with one field, do I need to
code something in that field? Thanks
DS
Nov 13 '05 #3

P: n/a
A scanner is an input device. Place a field for the scan in Access and when
that field is active, scan and the barcode scanner will place data in the
field.

HTH
Nov 13 '05 #4

P: n/a
"DS" <bo******@optonline.net> wrote
I have the Keyboard wedge scanner. A quick question, what do I need to
do in Access to make this work. I have the Liqour bottle in one hand,
the scanner in another, and Access open with one field, do I need to
code something in that field? Thanks

First, put down the liquor. This will make your coding easier ...


Nov 13 '05 #5

P: n/a

"DS" <bo******@optonline.net> wrote in message
news:U%******************@fe08.lga...

I have the Keyboard wedge scanner. A quick question, what do I need to do in
Access to make this work. I have the Liqour bottle in one hand, the scanner
in another, and Access open with one field, do I need to code something in
that field? Thanks
DS


As stated previously...when you scan the barcode the scanner will send the exact
same input to the computer as if you were typing. If you have the cursor in a
control that can accept keyboard input then all you have to do is scan the
barcode.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #6

P: n/a
You first need to determine the type of the barcode; there are numerous
types of barcodes. Then you need to look at your scanner's documentation and
configure your scanner for that particular barcode to read the barcode.

Each barcode represents some value. A scanner reads a barcode and interprets
it to determine the value the barcode represents. A scanner outputs the
value. So you need to set focus to a textbox on your form and when you press
the trigger on the scanner it will enter that value in the textbox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"DS" <bo******@optonline.net> wrote in message
news:0c******************@fe08.lga...
Does anyone know anything about barcodes in Access. I don't want to
create them in Access. I merely want to scan whats already been created.
I need to scan Liquor bottles. I have the scanner hooked up.
Any help is appreciated,
Thanks
DS

Nov 13 '05 #7

P: n/a
DS
PC Datasheet wrote:
You first need to determine the type of the barcode; there are numerous
types of barcodes. Then you need to look at your scanner's documentation and
configure your scanner for that particular barcode to read the barcode.

Each barcode represents some value. A scanner reads a barcode and interprets
it to determine the value the barcode represents. A scanner outputs the
value. So you need to set focus to a textbox on your form and when you press
the trigger on the scanner it will enter that value in the textbox.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com


"DS" <bo******@optonline.net> wrote in message
news:0c******************@fe08.lga...
Does anyone know anything about barcodes in Access. I don't want to
create them in Access. I merely want to scan whats already been created.
I need to scan Liquor bottles. I have the scanner hooked up.
Any help is appreciated,
Thanks
DS


It Works!!!
Just had to calibrate ir for a notebook.
Thank You Evreyone.
DS
Nov 13 '05 #8

P: n/a
On Sun, 23 Jan 2005 09:01:15 -0500, DS <bo******@optonline.net> wrote:
Does anyone know anything about barcodes in Access. I don't want to
create them in Access. I merely want to scan whats already been created.
I need to scan Liquor bottles. I have the scanner hooked up.
Any help is appreciated,
Thanks
DS


If the focus is on a text box when you scan, the code will go right in
there. Your software would need to recognise when a sucessful scan has
occurred.

For commercial software search Google for
barcode scan software vb
or
barcode scan software access

David

Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.