Using Scanner with POS

[Chuck]

Hi,
I need some help getting started.
We have an Access pos system in a small gift shop.
In the current system we select the item from a pull down but would like to
use a scanner.
I think I get the idea that we would scan an item at the register and it
would populate the item field.
So, is the first step to create bar code stickers of the Item Description
and attach them to all the items or is it better to use the vendors barcode
and tie that to our item descriptions.
Hope this makes sense, it's more of a process that technical question.

 

[Tom van Stiphout]

On Tue, 31 Mar 2009 16:37:01 -0700, Chuck

And because it is more a process question only you can answer it. We
wouldn't know if it makes sense for you to print your onw stickers and
put them on everything.
If you are trying to read vendor barcodes, you may want to do some
tests with a variety of vendors and products, because there is more
than one barcode format and your code would have to read all. The
system they have at the grocery store is not a $100 solution.

-Tom.
Microsoft Access MVP

 

[viglen]

On Tue, 31 Mar 2009 16:37:01 -0700, Chuck


And because it is more a process question only you can answer it. We
wouldn't know if it makes sense for you to print your onw stickers and
put them on everything.
If you are trying to read vendor barcodes, you may want to do some
tests with a variety of vendors and products, because there is more
than one barcode format and your code would have to read all. The
system they have at the grocery store is not a $100 solution.

-Tom.
Microsoft Access MVP




- Show quoted text -

Why not just buya POS software that can print barcodes and read
barcodes already and do 100 more functions for your business, the
better ones start at arround $30 on eBay anyways ? Is $30 worth more
than all of your time, plus I do not think Access is a professional
solution for POS.

Thank you.
Support,
www.AlexandriaComputers.com

 

[a a r o n _ k e m p f]

I disagree.

I've built a POS system in Acess before, it worked pretty well and it
was easy to build

-Aaron

 

[viglen]

I disagree.

I've built a POS system in Acess before, it worked pretty well and it
was easy to build

-Aaron





- Show quoted text -

OK, but did it support a receipt printer, did it kick a cash drawer
open, did it work with a pole display ? Let's face it Access is not a
programming language and people should stop treating it as one and
either learn how to write code in a programming language or buy a
professionally developed software, because sooner or later you will
find out it cannot do everything your business needs and that you have
just wasted your time and you become stuck with a lot of data that
cannot be transferred easily into a mainstream respectable POS
software.

Right ?

Thank you.
Support,
www.AlexandriaComputers.com

 

[James A. Fortune]

OK, but did it support a receipt printer, did it kick a cash drawer
open, did it work with a pole display ? Let's face it Access is not a
programming language and people should stop treating it as one and
either learn how to write code in a programming language or buy a
professionally developed software, because sooner or later you will
find out it cannot do everything your business needs and that you have
just wasted your time and you become stuck with a lot of data that
cannot be transferred easily into a mainstream respectable POS
software.

Right ?

Thank you.
Support,
www.AlexandriaComputers.com

I have written two POS systems in Access. One was for stores in the
(Winmark) chain that includes, among others, "Music Go Round,"
"Computer Renaissance" and "Play it Again Sports." I found Access quite
capable of working with a receipt printer, reading barcodes and kicking
a cash drawer open. It could even use the label printer that was
already a part of the existing system. Access had no trouble reading
things like the list of prices for the SKU's from the existing system.
So I am quite sure that Access can handle nearly all POS tasks. That
system also used the bar code reading capability to do store
inventories. But you might still be correct about buying professionally
developed software because it takes a fair amount of skill in Access to
get everything correct when dealing with a POS system despite Aaron's
claim that it was easy to build.

James A. Fortune
(e-mail address removed)