Taking input from user & presenting updated info back to them

[peskywinnets]

When I come to pack an order, I wish to add a bit of functionality to my Access database ....functionality that my existing third party order management system presently provides.

Let's say an order has 3 items to go into an envelope...I don't want to accidentally pack the wrong things into the envelope, therefore I need to scan the product barcodes as I place them into the envelope.

When each item is scanned, an onscreen window updates to visually represent (my present software turn s the item green, but a ticked checkbox would do!) & once the final item has scanned the onscreen window closes. Here's the type of window I get with my existing software...



(the products are fictitious!)

Now the barcode checking aspect I have covered .....each barcode is in my product table listed against the product SKU (product ID)...therefore my line of questioning is how - using Access - best to present the initial (unscanned) data to the user onscreen & then refresh this each time an item has scanned...with a warning if the product scanned is not on the order?

What would be the best mechanism to press into play here?

 

[pbaldy]

Presuming there's a field in the data to signify that the item has been scanned, I'd open a recordset on an SQL statement with criteria for the SKU and order. If found, update the item, if not, warn the user. You can use Conditional Formatting to turn the line green if the scanned field is updated.

 

[peskywinnets]

Presuming there's a field in the data to signify that the item has been scanned, I'd open a recordset on an SQL statement with criteria for the SKU and order. If found, update the item, if not, warn the user. You can use Conditional Formatting to turn the line green if the scanned field is updated.

Yes, that was my general plan of attack for the mechanics 'under the hood' so to speak, ...I guess the cut & thrust of my question is how do I present the data to the user to look like the box above.....such a user interface window needs to take data in (scanning box for the barcode) ...which would normally be a form & data back out (to show which items have been scanned) & that would be a report...how to combine?

 

[pbaldy]

I would probably use a form with a subform. The form would have the scan box and the subform would present the items.