Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Visual Studio 2005, Barcode scanning query with Access Database.

Posted on 2007-03-22
1
Medium Priority
?
253 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
[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
1 Comment
 
LVL 70

Accepted Solution

by:
Éric Moreau earned 750 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Loops Section Overview

610 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