Ok, I’m working on this inventory/POS project for school. Right now, I have a form to enter a sale, with all customer info, etc. There is a subform for the list of products in the sale, on each line of the subform, you enter the product ID, and quantity, it displays the extended price (retail x quantity) on each line, then in the subform’s footer calculates the sum of the extended prices. The main form reads that control, which is not visible, subtracts any discounts added, and displays the subtotal on the main form (No taxes, since I won’t be hooking it up to a register, the process is you enter in the subtotal, and cashout that… customer recieves a copy of the sales form with the list of products/prices).
There is a SALES table which holds information on date/time of transaction, employee entering transaction, and customer making the transaction. Then a SALES-PRODUCT table with the sale-ID, Product-ID, and Units-Sold. Here’s a pic…
Problem I have is I need some way to update the product’s stocklevels when the sale is completed. Currently I have a “stocklevel” field in the PRODUCTS table, and I want to be able to just read the units sold from the form, and adjust the stocklevel on each product accordingly. I could just put a button on it to take care of that, but if someone didn’t push the button, the sale would be there, but the stock not adjusted. Also, if someone decides not to buy half way through, you’ve got to delete each field in the subform, then the sale record itself. Is there any way to keep it from updating ANYTHING, even creating the records, until you hit something like a “Complete Sale” button?
Any other thoughts would be greatly appreciated (as well as decent places to get info on the net… I had a hard time finding stuff).
One other question I have… I created a form to make it easy to search through the customers, and find the right one (if they don’t have their membership card… it’s a homebrew store, the memberships are for newsletters, taking brewing courses, and workshop access). I didn’t want the fields to be edited, so I tried just disabling them, unfortunately, they tend to turn gray anytime they’re re-drawn when doing things like sorting or applying filters. Any way to keep it from doing that? I do it now by simply locking them, and keeping them enabled, but then it functions like a text box… I’d prefer for it to work more like a label (too bad you can’t bound labels… or can you?).
Thanks in advance if there are any Access gurus here,
Oh, and if anyone is wondering, all the name/address stuff is stored in multiple fields (fname, mname, lname, etc.), they just display together in calculated controls.