EPoS System - Help!

[tomgrant00]

Hey,

I'm in the process of creating an EPoS system with stock control for a small store for a family member. I'm a little lost as to how i should go about creating a user friendly interface. Should it be done in visual basic and then linked to an access stock database, or all done in Access?

Any advice would be most appreciated as to how i should go about creating this. Basically, i want to scan an item, and then for it to pop up on screen and deduct an item from tblStock whilst keeping a track of all the transactions in tblTransactions.

Im finding this all a bit tricky to implement and a little daunting...

Thanks for any help

 

[Dreamweaver]

You will need to find the barcode reader code or obtain it from one of the code sites.

The program you use will depend on the end user if they have access on the system that the project will be used on then I would go for access being it is a lot more user friendly to new users as it has a vast number of wizards to do a lot of the work.

VBA Is a lot more complex but would be a little faster and is a stand alone system that would only require you installing the proram on the PC the installer would install all it needs to run the program.

mick

 

[spikepl]

I suspect Tom has resolved his problem. In fact, last I heard he was running Tesco!