Solved

Visual Studio 2005, Barcode scanning query with Access Database.

Posted on 2007-03-22
1
243 Views
Last Modified: 2013-11-26
Here is what Im trying to do.

Page 1 is a simple form where I scan in a barcode.  If the barcode is in the database it should return the values (below) on the second page.

Im using an access database and MS Visual Studio  2005 (.Net 2.0)
My table is called Stock, the fields are, Barcode, StockID, Equipment, SerialNo, Manufacturer & Supplier.

Im hopeless at writing SQL queries and the wizard doesnt help much. Can any one assist me for what code I should be writing on the second page.  The page names are irrelevant at the moment so feel free to use any examples.
0
Comment
Question by:toddml
1 Comment
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 250 total points
ID: 18776587
isn't it simply:

select Barcode, StockID, Equipment, SerialNo, Manufacturer, Supplier
from stock
where Barcode = YourValue

A barcode is always a string or a number so it doesn't matter.
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Flash (http://en.wikipedia.org/wiki/Adobe_Flash) has evolved over the years to where it has become a masterful tool for displaying content screen.  It has excellent layout placement, UI precision as well as rendering capabilities. This, along with t…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

777 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