Collection Form

[Nowee101413]

Hi,

I am still new to MSAccess and I need your help.

I have the UI below for a form that populates the Collection Register:

Here are the things I need to do.

1) There should be a subform that shows "only" the record of outstanding invoices per customer. (The Invoice No., Invoice Amount and the Outstanding Balance were taken from a Query), Records with "0" outstanding balance should not appear.
2) The Payment portion should be filled side by side with the invoice record and updates the CollectionRegister Table
3) The Outstanding Balance to appear in every record should be the balance at the time of payment.
4) Payment should not be higher than the outstanding balance at the time of payment
5) Include check boxes if the outstanding balance will be paid in full

The Collection Register Table fields are [CollectionID], [InvoiceNo], [DateofCollection], [Payment], [PaymentMethod], [Reference]

I will appreciate if you have better ideas.

Thanks,

 

[theDBguy]

Hi. Are you able to post a sample copy of your db?

 

[Nowee101413]

Can I just email it to you? I am just using it to learn more about DB and Microsoft Access so its kinda rough and a bit all over the place. I will upload the clean data in the DB once I complete it.

 

[theDBguy]

Can I just email it to you? I am just using it to learn more about DB and Microsoft Access so its kinda rough and a bit all over the place. I will upload the clean data in the DB once I complete it.

Of course you can, but I can't promise an immediate response. The good thing about posting it here is more people can take a look and provide their input. If you want me to post it here for you, I can do that too.

 

[Nowee101413]

I can send it to you and you can upload. I cannot attach it because I do not have WinZip and can't install it as I need admin access. Please send me your email address.

 

[strive4peace]

hi Nowee101413,

Welcome!

> "I cannot attach it because I do not have WinZip"

Zipping is built-into Windows. You shouldn't need WinZip. Right-click the filename in Windows Explorer and use the shortcut menu.

Send to > Compressed (zipped) folder

 

[Nowee101413]

Here you go