Inventory with Bar Codes

[theperson]

I'm just curious if there's a way that if a user zaps a barcode with say "01234" as the part number, that access automatically looks up that part number in an "Inventory" table and subtracts or adds the next value that the user will zap on another barcode. I'm not sure how the user will tell access if its a subtraction or addition to inventory.

[Dal Jeanis]

There is undoubtedly a way, but that way isn't an Access issue. It's an external app. You have a hardware item (phone, hand scanner) running an app to do the "zap".

That app needs to send a message to Access, (a remote query of some kind), and will receive a message back from Access, then process that return message.

The app must control what the message to Access is telling Access to do, and must understand the return code the app gets from Access.

If you define exactly what the app is doing, then you can ask for help making Access respond to that app approopriately. Until you know that, and tell us, there's not a lot that anyone here can do for you.

[Access_Blaster]

I'm just curious if there's a way that if a user zaps a barcode with say "01234" as the part number, that access automatically looks up that part number in an "Inventory" table .

This part I have done, I use barcoded serial numbers of computers to search to find if they are still active. This works in Access and third party software as well.