Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 3rd, 2006, 02:01 PM
Registered User
 
Join Date: Apr 2006
Location: Calne, Wiltshire, United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Scanning / Finding codes

I can generate barcodes from a database, using code and some barcode printing software...that was the easy bit.

There are two parts to this..
1.
I need to be able to scan barcodes (numeric), back in and locate the record they came from. The numbers have been generated by "auto-number"
I have decided that to help with error trapping during the scan,
(because basic barcode scanning can be unreliable)they need a fixed length field, in this case 8 digits. Since barcodes will be scanned in as text they will have leading zeros.

 I have scanned them in as text, into a text field of a "data_input_check" table and an unbound text box, I then hit problems. Of finding the record, in my main data.

In order to form a query to find the record I have tried transfering the value of these into a numeric field in the "data_input_check" table, by storing it as a variable and then transfering into the field. This works when the code is in a separate button, but I cannot do it automatically from the "properties after-update".

In an attempt to do without the button pressing for every item, I have also tried creating a query by reading from the "data_input" form, both from the unbound text box, and from the "data_input_check_table" (which is not yet linked to the main data) and have been unable to save the work (used Expression builder) though no error messages were generated.

2. When scanning into a box, I don't want to have to hit return every time, I would like to scan in whole trays of items and check them off in an unbroken sequence.

Any ideas, or pointers to were I am going wrong would be greatly appreciated. I have spent a depressing number of hours on this, but have to admit that without finding a course or help, I am beaten.

Thanks

Mark Horton


markh




Similar Threads
Thread Thread Starter Forum Replies Last Post
web based scanning jayanthg20 ASP.NET 1.0 and 1.1 Basics 1 March 10th, 2009 12:05 PM
Scanning documents and inserting them into Access DebT37 Access 3 January 3rd, 2007 09:32 AM
problem scanning over all non system table method Access 1 July 30th, 2005 02:36 AM
attendance scanning system rajanikrishna Classic ASP Databases 2 June 8th, 2004 04:30 AM
attendance scanning system rajanikrishna Classic ASP Basics 0 June 7th, 2004 10:04 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.