I am trying to make a Sales Transactions and Stock database
I have so far created a Transactions form that when you scan the barcode it enters the data in to a table (tbltransactions).
What I now require is:
When the order has been complete, I would like a button that opens a new form to open (frmCompleteSale) and show Date, Time, Give a reference number by date (i.e. 14/09/2005-01), show all the sales that have just been entered, Total cost, How they paid (cash, card, cheque) and a complete button that then writes to a table and stores the info.
I need this 2nd form to make sure the imputer can check the sale, and when they click the complete button it will then edit the stock levels on the tblquantity table. The form should like this:
14/09/2005
15:03
Ref: 14/09/2005-001
Product Qty Cost
Cherry Coke 2 £1.80
Twix 5 £1.75
Total £3.55
Payment Cash Card Cheque
Complete Sale
I know this is a big ask, but would appreciate some help. I know a little Access but not enough todo the above.
I have attached the DB
Thanks In Advance,
Danian
I have so far created a Transactions form that when you scan the barcode it enters the data in to a table (tbltransactions).
What I now require is:
When the order has been complete, I would like a button that opens a new form to open (frmCompleteSale) and show Date, Time, Give a reference number by date (i.e. 14/09/2005-01), show all the sales that have just been entered, Total cost, How they paid (cash, card, cheque) and a complete button that then writes to a table and stores the info.
I need this 2nd form to make sure the imputer can check the sale, and when they click the complete button it will then edit the stock levels on the tblquantity table. The form should like this:
14/09/2005
15:03
Ref: 14/09/2005-001
Product Qty Cost
Cherry Coke 2 £1.80
Twix 5 £1.75
Total £3.55
Payment Cash Card Cheque
Complete Sale
I know this is a big ask, but would appreciate some help. I know a little Access but not enough todo the above.
I have attached the DB
Thanks In Advance,
Danian
