Tracking Loan Payments in Microsoft Access. Calculate Amount Paid, Due. Loan Management. Updated!

[@jungjungdelosreyes4147]

I like how you explain your video you and Steve Bishop are both amazing. i have just renew my membership and soon wanna be a gold member. :)

[@599CD]

Awesome. Thanks!

[@ptzzycool]

Hi Richard, I love what you're doing regarding the tutorials that you are posting up here. They are helping a lot of us so much. I actually followed through your tutorial and put together something similar to what you are showing and it is working fine. However, I just felt that if the calculation of Interest is included here, it would be so much helpful. I tried adding that myself but can not really get it right. Can you help with a quick video just to add that bit? Thanks

[@599CD]

599cd.com/qq

[@fazlinsyafina9996]

hi richard. why my sum for amount paid error? 11:25

[@johnschulte5820]

I'll have to add this to the checkbook database! Wish you had a full Ledger system for us accounting types.

[@599CD]

Workin' on it. :)

[@johnschulte5820]

@@599CD I'm officially off Quicken and moving to Access! Wish importing was easier.

[@agustinsimone3277]

Great work. I'm fascinated. I have a question: 14:55 ¿why when I do exactly as seen (maybe it is not but I think I checked everything), my tables do not appear connected? Thank you so much :)

[@599CD]

I need more information to tell you what's wrong. Post your question in the Forums and some screen shots of what's happening: 599cd.com/AF

[@agustinsimone3277]

@@599CD is what I said, when I click one table and then the other, the connection is not set as it is on yours. Thank you for your time.

[@599CD]

Are the parent/child properties set? Again, tough to tell on here. Post in the Forum.

[@agustinsimone3277]

@@599CD no, that is what i'm saying. When I click on both tables to set them on the query, there is no connection shown as it's default in your case (the one you clicked and then changed some settings).

[@jamesoliver7398]

This is very helpful thank you very much.

[@599CD]

You're very welcome!

[@moodkn]

lot of Thanks: Excellent Trick... Helpful

[@599CD]

Most welcome

[@samiraljohani]

The three sum fields at the bottom of the sub form, how do I put them on the LoanF form (the main form) instead of the sub form? Thanks

[@599CD]

I have a video coming out on this soon.

[@9856CB]

I was just about to make that comment. 🤪. Great video👍

[@599CD]

Thanks

[@mosjany]

How do I take excess amount to the next installment? Example i was supposed to pay 5000 but i pay 6000 , how will i take 100 to next payment

[@599CD]

599cd.com/Ask

[@gkennethkarl]

Hi Richard, Will start a small lending/loan business soon. I think this will help me a lot. I want to get a copy of this database but I don’t have a credit card to secure payment for gold member. What else can I do? Hope you notice this :)

[@599CD]

599cd.com/Payments

[@agustinsimone3277]

When setting the first Query, I have an error message because the comma is wrong in the syntax. I tried with ";" and it is the only way it works, do you know why? Or it does not matter? Thank you R

[@599CD]

I'd really have to see it to tell you what you're doing wrong. Post this in the forum on my website with some screenshots. I know that regional settings can cause problems with commas and semicolons and all that stuff depending on your currency format and your date format and lots of different factors. That's one of the reasons I switched to the ISO date standard because of problems with date formatting. Currencies can be an issue too if you are in a country that uses a comma for your decimal separator.

[@themagniranthine]

9:30 how to make the fields automatically added

[@599CD]

Huh?

[@thequest5678]

I am a teacher. So, I need to create a full responsive marksheet of the students' result. I am hoping that you will help me showing marksheet in ms access. Thank you

[@599CD]

It's on the list.

[@syuhadaathirah4292]

hi, i need help. Can you do a video tutorial to create a simple supplier debt list payment in microsoft access. Pleaseee noticee me. thankyouuuuuuuuu

[@599CD]

599cd.com/qq

[@freedompacific1257]

would you have a full blank loan system

[@599CD]

I've got this: 599cd.com/Amort

[@jungjungdelosreyes4147]

wow amazing

[@599CD]

Appreciate it.