Dear All,
i need urgent help, i have field in form & based on the data i will put in the form i need vba to check if this data is within the range see attached sample
Dear All,
i need urgent help, i have field in form & based on the data i will put in the form i need vba to check if this data is within the range see attached sample
You could try the InStr function.
http://office.microsoft.com/en-gb/ac...001228857.aspx
Dear Alex,
thanks for your reply but i need the following:
check type of material in table if Yes/no then
chack welding progress in table yes/No
check the wtpipedaimeter in table if is greater the dia in table
the check if thik is within the range of Thik Min & max in table
all these has to be in 1 vba code
sorry but that is the requirement i hope you can help me in this issue
You could use DLOOKUP
http://www.599cd.com/tips/access/dlookup-function/Code:=DLOOKUP (Field, Domain, Criteria)
http://www.599cd.com/tips/access/130...o-programming/