Hi,
Friend I am send two file MBD and note jpg,
when I want to take output some from stock it must check if i have enough balance ?if i am out of balance MSN must appear.
thanks
Hi,
Friend I am send two file MBD and note jpg,
when I want to take output some from stock it must check if i have enough balance ?if i am out of balance MSN must appear.
thanks
A simple bit of code is all you need but it depends on how the balance gets updated as to where you put the code.
E.g. If the balance only gets updated when you add a new item then put the code on the AfterInsert of the item. The code will be something like this (Note:you will need to edit with your own field/form names)
Sub On afterInsert..
If forms!balanceform!balcne < 0 then
msgbox("Your balance is less than 0")
end if
End Sub
Hi,
friend u have in attached my file can plz add ur code to my file
and send me again that MDB
thx
hi this is something you requested
Hi,
I check ur file,I want to keep color when i close database access file.
I mean when I click and became red when i close and open again it must give red color
thx