Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Closed Thread
Old 08-18-2004, 07:22 AM   #1 (permalink)
 
Newb Techie

Join Date: Aug 2004

Posts: 11

Tshimega

Default POS system!!!!

hi all...

I am try to develop a Point Of Sale system for a small florist. i am using VB 6. Pls give me an overview of the whole process. Where can I get info to connect a cash register to a scanner and to the ms access database.

Give me just an overview and again tell me how in depth knowlegde of VB 6 should I be having..

Thanks
Tshimega is offline  
Old 08-18-2004, 07:43 AM   #2 (permalink)
 
Newb Techie

Join Date: Jun 2004

Posts: 22

lexor

Default

You must atleast knowledgeable in ADO before starting your program.

About the cash regisiter it is not very hard to make code for it, if you mean the barcode scanner then you don't need a code for it just plug in to your computer then it works.

To start your project you must design first your database make it perfect before starting your code else you will spend more time when your data design crush
lexor is offline  
Old 08-18-2004, 08:00 AM   #3 (permalink)
 
Newb Techie

Join Date: Aug 2004

Posts: 11

Tshimega

Default

How ieasy is it to link the Barcode tags on the flower to the scanner so that when I point the scanner to the barcode, information about the flower, i.e the price, description is retrieved from the database.

Thanks...
Tshimega is offline  
Old 08-18-2004, 07:19 PM   #4 (permalink)
 
Newb Techie

Join Date: Jun 2004

Posts: 22

lexor

Default

O ic you really need to create a table where barcodes stores, including info for specific code.

Then use a SQL Select statement to query it.

For example :
Quote:
Select * from stocks where barcode = txtbarcode
If you need help just count me start building your database now...


O I almost forgot, include on your program design a utility or form where you can enter or update barcode description and stocks
lexor is offline  
 
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On