Point of Sales With Barcodes in Ms Access

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc used Ask the Experts™
on
We are now required to be scanning the bar codes for the supermarket stock using the point of sales ms access software when selling:

(1) all the stock are stored in the inventory table using the bar codes in place of stock codes
(2) Some stocks can be manufactured within the company some are ordered from outside if there are some pick periods especially monthends

Assistance required:

(1) To avoid wrong bar codes capturing in the software, is it possible the Ms Access 2016 built software can allow the bar codes scanning as a method of imputing the stock /Bar code in the system? There is a text control in a form for imputing bar code which require imputing the bar code manually

(2) Since  the cash sale form has a similar text control but in a combobox control form is it possible to be scanning the same bar codes here also, remember the bar codes are stored in the product table  hence the reason for the combobox in the cash sale form to easy lookup?

(3) Since the prices are linked to the product codes/ Bar codes such that once the product code/ bar code is selected the price also come automatically, now the question in the text control where we are required to capture the stock sold, is it possible to have the control show a default one (1) quantity sold automatically? or if the customer is buying more than one then the quantity can be over written manually?

Regard

Chris
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
Most scanners are just keyboard replacements, meaning essentially all you're doing is using that scanner instead of a keyboard. You can run code just like you would for keyboard input, so you could determine stock levels, etc. You could also set whatever defaults you want on your form.

If you're going to be using this on a point-of-sale terminal, however, you'd have to do quite a bit more. For example, at most stores the barcode scan automatically inserts a line into the order, and then moves to the next line and readies for input. you can do this with Access, of course, but you have to code all that in.
John TsioumprisSoftware & Systems Engineer
Commented:
Just because you have a barcode scanner it doesn't mean that it carries a "magic bullet" to solve all issues...as pointed above barcode scanners are just keyboard replacements and instead of typing some values by hand you get them by the barcode scanning technology...its up to you/developer to use this input to perform what you want.
I have used extensively barcode scanners in the past to perform a number of actions ...from logging user actions to manipulate raw material consumptions...to complex packaging systems that involved product "explosions"...and correct items placing.
Scott FellDeveloper & EE Moderator
Fellow 2018
Most Valuable Expert 2013
Commented:
For example, at most stores the barcode scan automatically inserts a line into the order

This is typically a function of the scanner set up. I have not done this for Access, but for web apps.  Bar code scanners or even card readers are programmable and you will want to follow the instructions from the manufacturer such as zebra

https://supportcommunity.zebra.com/s/article/How-dodr-every-scan-with-the-laser-scanners-when-attached-via-USB-or-Keyboard-Wedge?language=en_US or sending RAW codes https://supportcommunity.zebra.com/s/article/Including-Carraige-Return-Line-Feed-in-QR-Barcode-Using-ZPL?language=en_US
David FavorFractional CTO
Distinguished Expert 2018
Commented:
(1) To avoid wrong bar codes capturing in the software, is it possible the Ms Access 2016 built software can allow the bar codes scanning as a method of imputing the stock /Bar code in the system? There is a text control in a form for imputing bar code which require imputing the bar code manually.

As stated above, bar code scanners are essential keyboards which only produce a subset of typed characters.

(2) Since  the cash sale form has a similar text control but in a combobox control form is it possible to be scanning the same bar codes here also, remember the bar codes are stored in the product table  hence the reason for the combobox in the cash sale form to easy lookup?

Well... Anything's possible, if you're willing to write the code.

And, barcode are just dumb keyboards. Nothing else.

So your combobox code, you'd have to write + this code will work the same whether a keyboard is typing or a barcode scanner is scanning.

(3) Since the prices are linked to the product codes/ Bar codes such that once the product code/ bar code is selected the price also come automatically, now the question in the text control where we are required to capture the stock sold, is it possible to have the control show a default one (1) quantity sold automatically? or if the customer is buying more than one then the quantity can be over written manually?

Yes.

And this is all code you must write.

Whether keyboard or barcode scanner, you're only producing a string of characters.

You still must write all the software to process all your character/string input.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Chris,

  Just to add a few points as to your questions..as Scott McDaniel said, scanners read and decode bar codes, and then present that data to Access (or any other program waiting for input) as if it came from the keyboard.   And as Scott Fell said, they are programmable for things like adding an automatic carriage return.

  What I wanted to add is that you can also have it add other characters as a prefix or suffix, which it will add to the data that Access sees. That means you can tell if something comes from the scanner or the keyboard by having it add something.

  Say you are on a control that you only want scanned (UPC Code).   By programming the scanner to prefix and suffix a code it scans with say an *, then you will see in Access:

 *123456789012*

 When a scan is done.   But if someone types the code in from the keyboard, they would just type in 12345678912.    The characters can be anything (even non-visible), but by adding them you can tell where the data came from.

 Which brings me to the second point; think of the scanning as an "add-on".   Your app should be able to do everything you asked about on it's own already.   Scanning (or not) does not do any of that for you.  Defaulting the qty to 1, inserting a line into an order when you enter all the data, etc.

 The scanner just makes entering data easier.

 Hope that makes things a bit clearer.

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial