Loan Payment - Loan Payments in Microsoft Access


	Back to Loan Payments Comments List

Upload Images Link Email

Loan Payment

Anthony Kritzinger

3 years ago

Hello
I got a problem with the formula some how?
The Payment Process Form is ignoring, displaying the amount after the comma and therefore the paid amount is 4.50 out.
Help...
The second part is the VBA. I had to add 'IsPaid' to the INSERT INTO, to get it to display, but now it ticks all the paid boxes when running the 'Create Payment Schedule' button.

	Kevin Robertson 3 years ago

	Scott Axton 3 years ago
Hi Did not get a Upload Images in the top right corner. How do I send the Images? Anthony - You must first submit your initial question. Then, when it is posted, you will get the Upload Images (Like Kevin gave you above). Please use the Reply to this Conversation rather than the Start a NEW Conversation box. I went a head and deleted the other post.

	Richard Rost 3 years ago
Are you using MY database, or did you rebuild it yourself. Since you're a Silver member, I'm guessing you built it from following along with the video... and you know what I'm going to say... you typed something in wrong. Start over. :)

	Anthony Kritzinger OP 3 years ago
Hi, Yes built it myself. but would like to know where it is wrong if possible. Going to try to upload images.

	Anthony Kritzinger OP 3 years ago

	Anthony Kritzinger OP 3 years ago

	Alex Hedley 3 years ago
Why are there 4 fields needed but only 3 provided? IsPaid isn't sent.

	Anthony Kritzinger OP 3 years ago
The only way I could get the Create Payment Schedule to run. If I take IsPaid out, and run it, it gives me a error code "...fields do not match..." If I add IsPaid in then it works, but it in then adds the tick in all the Paid boxes.

	Anthony Kritzinger OP 3 years ago
Hi All Found the problem. Had to change my window currency settings to from a 'comma' to a 'dot'.

	Anthony Kritzinger OP 3 years ago

	Richard Rost 3 years ago
Yeah, you definitely have to have the same number of fields in the query that you define.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Loan Payments.