I'm almost finishing the point of sales application in ms access , now I have three issues:
(1) While on the form I have developed a code using Dsum that calculate the current stock balance immediately when a user select the stock code,this code give an error before the stock code selection is made , I feel like it will scare the users. The error is caused by the fact that at that point the product ID is not yet select and the code is evaluating a null value. How do I suppress this ? Otherwise the code works well.
(2) I have also tried to include a control called Quantity Sold within Dsum so that when a user punches more stock than on file it should not accept saving
((DSum("QuantityReceived","QryPurchases","[ProductID]=" &[ProductID]) - DSum("QuantitySold","QrySold","[ProductID]=" &[ProductID])) - ([Quantity Sold])) (This is housed in a control called [stock control])
Now I'm trying to attach a code to control called [Quantity Sold] which will not accepted if stock is more than what is on file.
Private Sub Before update_ Quantity Sold( Cancel as integer)
If (Stock Control < = 0) Then
MsgBox " Please check your inventory you do not have sufficient stock"
Cancel = True
The above code is giving an error it does not want to exit, where have I gone wrong????
(3) How do we format our ms application to print on pos printer? example receipt not those A4 pages????????