If you ever get this error 02-0300-00000000-044 SOME FUNCTIONS PROVIDED BY THE OPERATING SYSTEM ARE NOT WORKING PROPERLY, just do a quick system Restore, and if it still does not work, do the system restore again, but dont run KO reinstall it and run it, it should stop giving the error then.
2shared - Online file upload - unlimited free web space.
If when closing a 'dirty' form via the 'X' button or a menu, and the record can not be saved because of table constraints or user constraints (such as setting the Cancel argument in the before update event to true) then an Access message is displayed. Whilst you can trap the error and display your own message, You can't alter the outcome. If you want to stop the form from closing, you have to Cancel the Unload event. You can not easily keep the dirty record and avoid this message. ) Bottom line - cancelling the form before update will not stop the form from closing.
What you can do is, during the error event, trap the failed save error and save all the control values away to an array and optionally set a form level flag.
and make our shared file collection even more complete and exciting.
Join our community just now to flow with the file Xtrap Update!