An inventory system

[stew8908]

Ok, what i need to accomplish is a system that can monitor its self and I think with the right code implemented i can make it send out an email to order the parts that are low at the end of the day. the first think i want to try and tackle though is check in check out which will basically my add or subtract one from a selected record in my amount in inventory field by the push of a button. I am just starting to learn vb, so can i get some one to tell me how to apply that trait to my button or buttons

[orange]

If you are not familiar with Database design concepts, there are free video tutorials available online.
see post #2 at
https://www.accessforums.net/showthr...lp-with-design

[JeroenMioch]

Adding or substracting values through VBA is not all that difficult.
Lets presume your inventory field on your form is called fldInventory and the buttom is called btnSubstract

Make the button and right click to see its properties. Then rename the button and set an event procedure to <on click> so it fires the code when clicked.

This would be the code to substract a value of 1 from the value in the field :

Private Sub btnSubstract_Click()
Me.fldInventory = [fldInventory] - 1
End Sub

Keeping track of an inventory is easy but it gets a bit more tricky when you have a table with customers as well. Presuming that when a customer buys a product you add the product to his bill and at the same time substract the products from the inventory of the shop.

[orange]

There is a sample database for INventory as a learning tool at
http://www.access-programmers.co.uk/...tory+data+base