Recently I had been working on the database for monitoring outstanding payment. One of the feature is that it enable to printout Reminder Letter to customer on outstanding payment. I had assign a code in the Close event procedure of the Report (Reminder letter) that will run the Update Query on the source table that contain field name Reminder Date that is actually the PC system date. So if a reminder is printout today, on close, the field will be updated with today date through manipulation of the Update Query. This will eliminate the need to update manually that field and I no longer bother about forgetting to update the field for future reference to check the date the Reminder letter had been sent out. However, I would like to suppress the generic access message box when the Update Query run when the report (Reminder letter) and replace with a custom message box that will read more or less like this "13 reminder had been generated" if 13 reminder printed out. I had managed to suppress the Update Query message box by unclick the Action Query checkbox in the Option menu of the Tool menubar but do not know how this can be done by assigning code that will both suppress the default Update Query message box and popup the custom message box.
Any sample code on this will be greatly appreciated.
Thanx in advance.
Any sample code on this will be greatly appreciated.
Thanx in advance.