got running error - Check Register in Microsoft Access


	Back to Check Register Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

got running error

Nathan Shepard

2 years ago

I made a few transactions. See attached. It gives me a error for running balance.
I did modify the Table name to reflect the name of the financial institution. Besides that the database file name is the name of the financial institution. I am using this one till I set up the Check register template and get the errors figured out.

	Richard Rost @Reply 2 years ago
You didn't attach an image.

	Nathan Shepard OP @Reply 2 years ago
There is some thing wrong with the upload. You choose a file and it comes back with no file chosen. Its a caught in a loop and you press Upload and it comes back with no file selected. You chose the file and press upload and comes back with no file chosen

	Nathan Shepard OP @Reply 2 years ago

	Nathan Shepard OP @Reply 2 years ago
Correction there is nothing wrong with the upload. I had to shrink the file down and chose Jpeg.

	Richard Rost @Reply 2 years ago
Does this problem occur in the stock database as it's downloaded from the site? If you've made changes, without knowing EXACTLY what you've changed, I can't tell what the problem is. #Error can be anything.

	Nathan Shepard OP @Reply 2 years ago
This occurs in the stock database. I changed the name of the database to the name of my financial institution With the ending of the file being ckreg

	Kevin Robertson @Reply 2 years ago
I just checked the database and it works fine for me. Please walk us through EXACTLY what you did to generate this error.

	Nathan Shepard OP @Reply 2 years ago
Running balance is not defined in the table. The running balance and clear work fine in the report. The problem is in the check register. that is where the issue is. Its not defined or no field exists for the running balance. Nathan

	Richard Rost @Reply 2 years ago
You would not store the running balance in the table; it's a calculated field, either on the form or the report.

	Nathan Shepard OP @Reply 2 years ago
It does not work. It gives an error. I checked the code. I do not see any calculations. The code must be invisible.

	Kevin Robertson @Reply 2 years ago
RunningSum is a calculated field in the CheckRegQ Query. You say you modified the Table name. You also need to change it in the DSum function that is used in the RunningSum calculated field.

	Nathan Shepard OP @Reply 2 years ago
Thank you for suggestions. Will try fixing this over the weekend.

	Nathan Shepard OP @Reply 2 years ago
Thank you everyone. The error has been fixed. Nathan. Nathan Shepard is my pen name. I have one book published and 3 which are collecting dust. This post is now closed.

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

Next Unseen

New Feature: Comment Live View