Button Commands

[JayX]

I am trying to run a database that keeps track of inventory coming in and inventory going out of the building. I have 5 columns: column 1 is the product ID, column 2 is the product description, column 3 is Amount of products received, column 4 is amount of products taken from inventory, and column 5 is quantity on hand.



I want column 3 (Amount of products received) to be a button command which will +1 to the quantity at hand (column 5) as well as having column 4 (Amount taken) be a button command which will -1 from column 5 (quantity at hand) I am having trouble running a macro or command that will do this.


Any suggestions....

[Robeen]

Are you wanting to do this IN the TABLE?

[JayX]

yes, when I go to form view I want to be able to click one of the buttons so it adds it to the quantity on hand or subtracts it to quantity on hand

[JayX]

There are going to be 2 buttons, one thats add +1 and one that subtracts -1 to the quantity on hand

[Robeen]

Ok. So you have a Form on which you want to put these buttons?

[JayX]

yes, I added the command buttons in column 3 and 4 in the design view but I need the button in column 3 to +1 to column 5 and column 4 to -1 in column 5 which it will then hopefully work when I run it in the Form view.

[JayX]

Unless you have an easier way to do this..I am open to suggestions!

[Robeen]

When you say:

I have 5 columns: column 1 is the product ID, column 2 is the product description, column 3 is Amount of products received, column 4 is amount of products taken from inventory, and column 5 is quantity on hand.

in your first post - are you talking about columns in your TABLE - or are you talking about fields on your FORM??

Did you build your Form based on your Table - using a wizard perhaps?

Is every field on the Form bound to a column in your Table?

[JayX]

yes I built the form based on my table using a wizard.

[Robeen]

I'm seeing a problem here.

Are these two:
1. Amount of products received
2. Amount of products taken from inventory

Columns in your Table?

[JayX]

Right, so one column which is named Amount Received (column 3) is going to be a button showing +1 for all 31 products in the storage room. So lets say 4 bottles of soap come in I want to push the button 4 times so the Quantity on hand in Column 5 goes from lets 15 to 19.

Or

In column 4 (Amount Taken) when an employee comes in and takes 6 bottles of soap. I want the button in column 4 to subtract from the quantity on hand.

So overall if 4 bottles of soap come in I need to press the button 4 times to add it to my inventory in the 'Quantity on Hand' column. But then if an employee comes into the storage and takes 6 bottles I need the one button in column 4 to -1 and it will show its value in the "Quantity on Hand' column.

[JayX]

Please feel free to give any suggestions if there is a much easier way to do this...I have minor experience with access.

[Robeen]

Do you think you'll be able to post a copy of your db here?

[dblife]

I guess accounts are going to take an interest at some point.
Accounts like to know that you paid $0.65 per item for last mays batch but only $0.59 per item for this months batch.
You have to store what you paid for each batch.
And let the user choose what batch they are booking out from.
That way, you can calculate how much REAL value you are losing from stock.