G
Guest
does anyone know if i can add a barcode reader to my computer to imput data in to my access database. i am looking at the wasp nest suite and the wand reader. will this work?
Thanks Troy
Thanks Troy
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer
data in to my access database. i am looking at the wasp nest suite and theTroy said:does anyone know if i can add a barcode reader to my computer to imput
wand reader. will this work?
Yes, and barcodes work just fine in Access. There are several different
kinds and the Wasp appears to have different types as well. You may want to
visit a barcode site that doesn't sell one particular brand:
http://www.barcode-1.net/pub/russadam/faq.html
and here's another brand that advertises that they work with Access:
http://www.skandata.com/
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
T
Tony Toews
Troy said:does anyone know if i can add a barcode reader to my computer to imput data in to my access database. i am looking at the wasp nest suite and the wand reader. will this work?
Barcodes mean
1) a means of reading them. These devices usually fit between your
keyboard and your computer and mimic someone keying in the code
directly. All you need to do in your app is a little forms design to
ensure someone can continuously feed bar codes into your app and
change the quantity occasionally.
2) A means of printing them. Choose the proper barcode and locate an
appropriate font. Place the font file on all the systems which will
be printing bar codes. On the report(s) change the font on a field to
use the bar code font. Some bar codes like having *s before and after
while others like check digits.
For more info and links see the Using bar codes within an application
page at my website at http://www.granite.ab.ca/access/barcode.htm
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
A
agnieszka
Thanks Troydoes anyone know if i can add a barcode reader to my computer to imput data in
to my access database. i am looking at the wasp nest suite and the wand
reader. will this work?
agnieszka jestem
T
Thomas Lutz
For reading bar codes into an Access application, you have two
choices.
Most bar code readers are available with one of two output options.
The first option is called "Keyboard Wedge" output where you unplug
your keyboard, plug the bar code reader into the keyboard port on your
PC and then plug your keyboard into the bar code reader. This
arrangement makes the bar code reader appear as it it were simply a
second keyboard. Your original keyboard continues to work as normal
however when you read a bar code, the data encoded in the bar code
appears to any application running on your PC as if it were typed in.
The keyboard wedge interface is extremely simple however it has a few
drawbacks. If you swipe a bar code, the cursor has to be in the
correct input field in the correct application otherwise you end up
reading bar code data into whatever application has the focus. This
can cause all sorts of potential problems as you can imagine. The
keyboard output also is limited in that you cannot modify the data in
any way before sending it into the program that is to receive the
data. For example, if you needed to parse a bar code message up into
pieces or remove some of a bar code message or add in a date or time
stamp you would not be able to with a normal keyboard wedge reader.
The other possible output option is to get a bar code reader with an
RS232 or "Serial" interface. With these types of bar code readers, you
connect the reader to an available serial port on the back of your PC.
You would then need a program called a "Software Wedge" to take the
data from the bar code reader and feed it to the application where you
want the data to go. The disadvantage to this approach is that it is a
little more complex however you gain much more control over how and
where your data ends up when you read a bar code. With a Software
Wedge, you can control exactly where the data goes in the target
application and you can also perform all sorts of modifications on the
data before it is sent to the application.
TAL Tehchnologies sells a product called WinWedge which is a Software
Wedge for Windows. Visit: http://www.taltech.com for more information.
This web site is also an extremely good place to obtain information
about bar coding in general.
For printing bar codes from Access, you would be best off using a bar
code ActiveX control like the one fromTAL Technologies at the
following URL:
http://www.taltech.com/products/activex_barcodes.html
I would recommend that you download the demo of the TAL Bar Code
ActiveX control from the above URL and take a look at the sample
Access database that is provide with the demo.
choices.
Most bar code readers are available with one of two output options.
The first option is called "Keyboard Wedge" output where you unplug
your keyboard, plug the bar code reader into the keyboard port on your
PC and then plug your keyboard into the bar code reader. This
arrangement makes the bar code reader appear as it it were simply a
second keyboard. Your original keyboard continues to work as normal
however when you read a bar code, the data encoded in the bar code
appears to any application running on your PC as if it were typed in.
The keyboard wedge interface is extremely simple however it has a few
drawbacks. If you swipe a bar code, the cursor has to be in the
correct input field in the correct application otherwise you end up
reading bar code data into whatever application has the focus. This
can cause all sorts of potential problems as you can imagine. The
keyboard output also is limited in that you cannot modify the data in
any way before sending it into the program that is to receive the
data. For example, if you needed to parse a bar code message up into
pieces or remove some of a bar code message or add in a date or time
stamp you would not be able to with a normal keyboard wedge reader.
The other possible output option is to get a bar code reader with an
RS232 or "Serial" interface. With these types of bar code readers, you
connect the reader to an available serial port on the back of your PC.
You would then need a program called a "Software Wedge" to take the
data from the bar code reader and feed it to the application where you
want the data to go. The disadvantage to this approach is that it is a
little more complex however you gain much more control over how and
where your data ends up when you read a bar code. With a Software
Wedge, you can control exactly where the data goes in the target
application and you can also perform all sorts of modifications on the
data before it is sent to the application.
TAL Tehchnologies sells a product called WinWedge which is a Software
Wedge for Windows. Visit: http://www.taltech.com for more information.
This web site is also an extremely good place to obtain information
about bar coding in general.
For printing bar codes from Access, you would be best off using a bar
code ActiveX control like the one fromTAL Technologies at the
following URL:
http://www.taltech.com/products/activex_barcodes.html
I would recommend that you download the demo of the TAL Bar Code
ActiveX control from the above URL and take a look at the sample
Access database that is provide with the demo.