In answer to part of your question (I hope), I offer the following.
Here is some VB Script that you can use at the object level for validation.
' Entry required...
sub txtCallerName_OnBlur()
if len(frmLineDetail.txtCallerName.value) = 0 then
alert ("Caller Name is required")
frmLineDetail.txtCallerName.Focus
end if
End Sub
' Numeric validation...
sub txtQuantity_OnBlur()
if len(frmLineDetail.txtQuantity.value) > 0 then
if not IsNumeric(frmLineDetail.txtQuantity.value) then
alert ("Not a valid number")
frmLineDetail.txtQuantity.focus
end if
end if
end sub
' Date validation...
sub txtQuantity_OnBlur()
if len(frmLineDetail.txtQuantity.value) > 0 then
if not IsNumeric(frmLineDetail.txtQuantity.value) then
alert ("Not a valid number")
frmLineDetail.txtQuantity.focus
end if
end if
end sub
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only