Blank receipts in Ms access

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc used Ask the Experts™
On our point of sales receipts (Ms Access) form we are using on current event to capture the following automatically:

(1) Date
(2) "Cash receipt"

Now the problem is that when closing the form, its leaving a blank cash receipt which making the serial number having gaps because of the same blank receipts. Is there another event to use other than the current event to archive the same results:


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
John TsioumprisSoftware & Systems Engineer

Usually this kind of checking involves the use of BeforeUpdate event on the form to provide validation to the data recorded Current event populates the necessary data...but on BeforeUpdate the data are validated and if they don't not meet the necessary rquirements gets dumped.
Another possibility is on the Close event to check for blanks and simply delete these entries..
The other way is to use unbounded fields for Date and Cash receipt and write data to table with append query only when there are valid values.
I think deleting them we may have issues with auditors , that is why are tracking them by using a report. I will see how the append query can be done.


Most Valuable Expert 2015
Distinguished Expert 2018
It is because you generate and save a serial no. at the OnCurrent event.
If you really have to do that, simply include these in the list of invoices. The reason they exists is easy to explain, and it is much to prefer than to delete them and leave gaps.
Mark EdwardsChief Technology Officer

A properly designed system (especially one involving money) would only save/allow valid records.  Junk records should not be generated in the first place.
Time to hire a professional....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial