Dear All,
I am very new person to development in Access 2013.
Need help for the following:
I am trying to create a Stock Register. In the Stock Register, I want to maintain the daily latest stock status. I receive stock periodically and also have to issue items and have to maintain the stock as well as a minimum quantity. I had created the field as follows:
Stock Balance = StockBalance + StockReceived - StockIssued.
Also wanted to maintain an alert if the stock goes below the minimum stock level. Can anyone help me by providing a VBA code for the same
Thanking in advance
PKG25
I am very new person to development in Access 2013.
Need help for the following:
I am trying to create a Stock Register. In the Stock Register, I want to maintain the daily latest stock status. I receive stock periodically and also have to issue items and have to maintain the stock as well as a minimum quantity. I had created the field as follows:
Stock Balance = StockBalance + StockReceived - StockIssued.
Also wanted to maintain an alert if the stock goes below the minimum stock level. Can anyone help me by providing a VBA code for the same
Thanking in advance
PKG25