I try all the ways
onValidate I obtain a new string date, ($xxdate = {mydate}
then format the date in differents formats and replace the original date fields and nothing, the error persist.
I add “#” characters before and after the string date to format the MsAccess date and nothing
I truncate the string date to only the first 10 characters “2012-08-21” and nothing
I don’t know what happen !!
please help me !! I’am waiting for any help
Aquiles
Note: I don’t update via code the table, I’am simply CLICK on “update” button in a form application.
the error occurs in onVALIDATE event, never arrive to save the table.
PLEASE SEE THE ATTACHED IMAGE …
I add a onValidatefailure event with an sc_alert message and the event is executed and display the message “validate fail”
