[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Using Bar codes with VB

Posted on 2002-05-28
9
Medium Priority
?
166 Views
Last Modified: 2010-05-02
Hi!

I need some help with the Barcode device. Could any one tell me how much does it cost and where could i get further information on how to use it in VB or Access2000.

Are there any free software available on the net that use it?

Nomi.
0
Comment
Question by:Syed Irtaza Ali
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 3
9 Comments
 
LVL 1

Expert Comment

by:hiranmaya
ID: 7038708
I can give some suggetion:

1. Install IR device/bar code device to computer
2. define bar code sequence in the vb program to read as characters
3. Connect to device by vb program and read bar code once bar codes are shown in front or read if found any activity
4. Convert codes to readable charatcters
0
 
LVL 43

Expert Comment

by:TimCottee
ID: 7038710
How long is a piece of string?

Generally speaking barcode scanners fall into two categories:

1) Keyboard Wedge: reads the barcode and places the decoded string into the keyboard buffer

2) Serial Connection: reads the barcode and places the decoded data into the serial buffer for reading using a communications control.

Each has its benefits and downsides, the keyboard wedge is usually the simplest as whatever is scanned is then placed in the keyboard buffer and is simply "typed" into whichever application/control has the focus at that time. The serial communications type is more suited to high volume / precision scanning especially where you have fixed units scanning items on a conveyor or similar. This method allows you to read the data and then automatically determine what to do with it without it having to go into a textbox or other control first.

As for cost, it depends on how much you want to spend, which features you require - which barcode formats you wish to read etc - and which manufacturer you want.
0
 
LVL 2

Author Comment

by:Syed Irtaza Ali
ID: 7038758
guys Im totally new with the bar codes. The main reason Im using it for is in a library system. Suppose I reader has not issued a book and when he is about to leave the book will be scanned and a beep will occur. If the book is issued the barcode on the book will be decoded and a flag set that this book has been issued so when the reader leaves the library he does not get a beep on scanning.

Now could someone give me a detailed info on barcode detectors and barcodes, also their usage with VB and databases.

TimCoffee could u describe your view using the above info i have written and hiranmaya what does IR stand for?


Nomi.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 1

Expert Comment

by:hiranmaya
ID: 7038760
IR stands for Infra-Red devices. We will be getting better information for you.
0
 
LVL 43

Expert Comment

by:TimCottee
ID: 7038789
Ok, for something like this I would suggest that you look at simple keyboard wedge scanners. Here is a cheap example http://www.kanecal.net/scanner.htm however a simple search on google for keyboard wedge scanners provides a wealth of hits for you to check out. http://www.google.com/search?num=100&hl=en&lr=&newwindow=1&safe=off&q=keyboard+wedge+barcode+scanner

Your process would probably require something like this:

Books table:
  BookID - Barcode
  Title
  Author
  OnLoan - Boolean Yes/No
  OnLoadTo - Reference to userid (optional)
  ...

Users Table:
  UserID - Barcode (on their library card perhaps)
  Name
  Address
  ...

Loans Table:
  UserID
  BookID
  DateOut
  DateDueBack
  ...

You would then have a simple form with a single textbox to start with, scan the barcode from the user's library card, this can then be stored and the appropriate information displayed on the screen, the scan will be detected using the _Change event of the textbox, or alternatively you can have a submit button on the form to then perform the lookup of the userid in the users table. The textbox is now ready to scan the book(s). Each time you scan a book and the data goes into this field you can then do a lookup in the books table for the bookid. If it is onloan you can optionally get the information from the users table for the person it is on loan to. If not then you create a record in the loans table with the bookid and userid and the appropriate dates.

When the book comes back you effectively do the reverse of this operation though you probably wouldn't want to delete the record from the loans table.
0
 
LVL 1

Expert Comment

by:hiranmaya
ID: 7040824
very usefull link:
http://www.idautomation.com/
0
 
LVL 2

Author Comment

by:Syed Irtaza Ali
ID: 7042998
TimCoffee thats good info but i think its limited to what i require.
Please check out the library thread.

I need a site that could describe or have an article showing how to use keyboard wedges programatically in VB or Access 2000.

0
 
LVL 43

Accepted Solution

by:
TimCottee earned 200 total points
ID: 7043921
The whole point about a keyboard wedge is that there is no programmatic use required. The decoded string is placed directly in the keyboard buffer, either by software in some cases or because the actual device plugs into the keyboard socket on the computer in parallel with the standard keyboard. When you scan the barcode the data is placed in the keyboard buffer and is then effectively typed into the currently active control whatever that may be.

From reading the other thread though you may want to consider using a serial device instead of a keyboard wedge as the potential scale of the system (I don't know how big your client is of course) could be large and you have much more control using this kind of scanner than you would with a keyboard wedge as this will just dump the data to the current control.
0
 
LVL 2

Author Comment

by:Syed Irtaza Ali
ID: 7052164
Thanks for the info.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question