Hi there,
I need to know if I'm heading in the right direction. I'm creating a (what I thought was simple) access database that handles rentals (clothing rentals).
I have a table that handles all the products. These have barcodes, etc. I managed to get all that working.
I have also created a simple lookup form that has a field that when the barcode is scanned in shows the product information on a subform.
Now here is the tough part. I've thought of a different ways to do it and I would just like some advice.
Mr. Customer brings 4 pieces of clothing up to checkout. I want to be able to scan those for things and add them to one order. Here is what I was thinking, please tell me if I'm way off base.
The form would have a customer dropdown field that you can choose the customer name (with an add new button if they don't exist). The table containing the customer information would have all the normal contact info.
I need a field that I scan the barcode into. The barcode scanner automagically hits "enter" (I think its enter, it just works) after the scan. My idea was to have after update or lose focus to have a table that holds active orders (ones that have not been completely processed) get updated with the customerID,barcode, and rental price (for override purposes).
At the same time I would like a subform showing the running list of things I have scanned in. I think I would need a CLEAR button, a HOLD button, and a CHECKOUT button. HOLD would do just that. Just hold the items in that table. Checkout would append that data into a orders table and delete it from that orders in processing table.
I see a problem with not having a unique order number and going by the customer number (in case they have multiple separate orders).
What do you guys think? Am I on the right track?
And should I use queries or VBA to do the queries?
Thanks for any advice.
Bryan
I need to know if I'm heading in the right direction. I'm creating a (what I thought was simple) access database that handles rentals (clothing rentals).
I have a table that handles all the products. These have barcodes, etc. I managed to get all that working.
I have also created a simple lookup form that has a field that when the barcode is scanned in shows the product information on a subform.
Now here is the tough part. I've thought of a different ways to do it and I would just like some advice.
Mr. Customer brings 4 pieces of clothing up to checkout. I want to be able to scan those for things and add them to one order. Here is what I was thinking, please tell me if I'm way off base.
The form would have a customer dropdown field that you can choose the customer name (with an add new button if they don't exist). The table containing the customer information would have all the normal contact info.
I need a field that I scan the barcode into. The barcode scanner automagically hits "enter" (I think its enter, it just works) after the scan. My idea was to have after update or lose focus to have a table that holds active orders (ones that have not been completely processed) get updated with the customerID,barcode, and rental price (for override purposes).
At the same time I would like a subform showing the running list of things I have scanned in. I think I would need a CLEAR button, a HOLD button, and a CHECKOUT button. HOLD would do just that. Just hold the items in that table. Checkout would append that data into a orders table and delete it from that orders in processing table.
I see a problem with not having a unique order number and going by the customer number (in case they have multiple separate orders).
What do you guys think? Am I on the right track?
And should I use queries or VBA to do the queries?
Thanks for any advice.
Bryan
