Need help to construct simple MS Access DB - read Barcode number & update inventory

[larrystaley]

Need help to construct simple MS Access DB - read Barcode number & update inventory

Hello. I have been tasked with constructing a basic VB Access Database that will do the following:
1. User uses a basic barcode reader to scan in barcode number. So for example if scanning for a specific Jade, the number 20532 is scanned into an input field. Also, the quantity for the item has to be entered. If will normally be 1, but could be a multiple number. So would need two fields as Product Number: (20532 is then scanned in) Quantity: Enter the number as say 2, 5, 7, etc. or can just default to 1.
2. Then take this information, specifically the scanned product number (or 20532 in this case) and the quantity (whatever number I entered) and match it to an inventory table. The primary key for the table will be the product number. So therefore will already have 20532 as one to match (along with others) plus a separate field for the current quantity.
3. Finally, will need to print out the scanned bar for the item, basically the tag showing item name, barcode image, barcode product number and name of company. So I am looking at one example as: SUCCULENT CELFIE, barcode image under that name, 22605 as barcode number under the image, and then name of company, under the barcode number.
So far I have a simple input form as:
Barcode Product Number:
(text box to scan in the number)
Quantity:
(text box with the quantity and will just default to 1 if no other number is entered)
Perhaps someone has an example of how this is done. I know I will need some basic code that pulls in the scanned product code number to the inventory table matching the same scanned product code number there and then decrement the inventory count accordingly (with current inventory count as another field).
Thank you for your help in advance.
Larry Staley










35 minutes ago
Reply
|
Quote

Larry Staley
0

Points


Larry Staley Joined Aug 2016 1

Larry Staley's threads
Show activity





0 Points

 

[larrystaley]

Re: Need help to construct simple MS Access DB - read Barcode number & update invento

Uncle Gizmo:

Thanks for the input. One basic question at the very front end. If I add a barcode item, say 24206911, leave quantity as 1 (in another text field), and hit enter, I am fine and can then do another scan for a new number.

However, if I then scan say 35702103, but then change its quantity to say 5 from 1, and hit enter, the item is apparently being retained. If I then scan say 43004951, then the original value, in the bar scanner code box, actually gets concatenated and reads 3570210343004951 and quantity remains as 5 (I did set default value in quantity to 1).

Is there something I can do here with very simple VBA code so when I change quantity to 1, I can insure the first product ID is reset to blank so I only get the new one, say the 43004951, and also insure the quantity is truly reset to 1 in the quantity box. Thanks again.

L. Staley

 

[larrystaley]

Re: Need help to construct simple MS Access DB - read Barcode number & update invento

Also, Uncle Gizmo,

Where does this code go? Would it be under After Update Event for the main barcode item text box? Also, I said I really need the quantity always defaulted to 1. Therefore, in your code, should the statement you have for resetting the rsRecordCount really be:

Set rsRecordCount = 1 ? (to the point of always wanting a 1 to show for a new scan, even if I then decide to change the quantity to some other number, as associated with the newest scan).

Thanks again.

L. Staley