MS Access Code was working but now gives error message. Please kindly help. Thanks a lot

[tamtoronto]

Hi Supers
Attached are the codes with error. These codes were fine did not give me any error, now it does.
Thanks a lot
-------

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks

[sandy666]

nobody want to retype text from the picture
Attach the example file, maybe someone will be interested

[tamtoronto]

thanks a lot Sandy.
Code that has error (never had error before)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

However, if you continue to not use code tags, you can expect to have your thread BLOCKED until you add them yourself.

[tamtoronto]

Thank you so much Alan for adding the [code] for me as per rule. I will keep this in mind.

[rorya]

What is the error and on which line(s)?

[tamtoronto]

Thanks Rory for asking. I dont know why it caused the error despite no changes when I opened the program. It was working smoothly for some time. Now the problem had just disappeared itself. I am not sure if that is because of MS bugs?
Now it is ok. Thank you very much Rorya. Did i forget to attach the error in previous question? I will close this issue.