The Code Vault doesn't necessarily give you all of the code from all of my courses and seminars... Just stuff that's commonly reusable.
Yashkumar Maradiya 11 months ago
i need only calculation method sample and i find out only one template in your website this is loan amortization, the calculation part is most helpful for my database ,it's not same but calculation method help improve my work, can you help me in calculation part
Scott Axton 11 months ago
See the Calculated Fields video for how to do calculations in Access. It is up to you to determine what those calculations are.
Your being too vague to have us assist you. If you determine your needs and a sample calculation that you can't get to work feel free to post back and we'll help walk you through it.
I see that you have the Learning Connection membership as well as the Gold TechHelp membership. There are literally tons of videos here to watch included in those memberships. The best place to start any journey is the beginning. I don't see that you have even completed the FREE Beginner 1 Course. That would be the best place to start.
What you really need is the PMT function. I haven't done a Fast Tip or TechHelp video on it. A few other members have asked about it though, and I've added it to the list. I'm pretty backed up, however, so it may a week or so until I get to it. If you're in a hurry, I do cover it in the seminar that Kevin mentioned above and also in Access Expert 30.
Yashkumar Maradiya 11 months ago
which method using in loan payment to payment subform set amount, it can me help in purchase of database
i learn about adding payment
in loan amortization use 3 form.... 1st is main form, 2ed is monthly schedule and 3ed is payment form
adding amount in payment form and click on apply payment ,auto set in 2ed form monthly schedule (installment wise)
i want to learn on click apply payment event (i make some other database please note * i don't make same project but you make loan amortization project same vba code or applying format i don't show any project * Please give me same hint for this
i collect same amount for purchase for access export 30. fro know more about the access
The Loan Seminar and Template include multiple forms like you mention (payment schedule, actual payments made). In Access Expert 30, I just show the basics of how to calculate the monthly payments. Yes, as a Gold member, you get a 25% discount. Use the link you were emailed when you signed up.
Yashkumar Maradiya 11 months ago
Please help in payment set part and on click event add to schedual on click apply payment event
That's covered in the Loan Amortization Seminar. It's not something I can just "help" you with here. I show you how to do it in the videos. If, after you watch the lessons, you have SPECIFIC questions, then feel free to post them here.
Yashkumar Maradiya 11 months ago
Only 20% discount show in your sending link
It can be update with 25%
I misspoke. Gold members get a 20% discount, however I've updated your order to give you a 25% discount this time. See my email.
Yashkumar Maradiya 10 months ago
i see expert 30 class, but in this class no any vba through calculation part , i learn how to vba work with vba in calculation part,and also know how to set payment installment wise & set properly with id & payment number
3 years ago
