Access Shutting Down - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Shutting Down

James Hopkins

5 years ago

Hey Richard, I been working on our company's database for a while. I just ran into a problem when writing VBA Code. I keep getting an error message and then Access Shutdown. How can I do to fix this problem.

	Richard Rost @Reply 5 years ago
It would help to know what the error message is, and perhaps a few screen shots. Also see the Troubleshooter.

	James Hopkins OP @Reply 5 years ago

	James Hopkins OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
My advice would be to run down the Troubleshooter... compact, repair, reboot, recompile, etc. If you're not getting a specific error message, something "weird" is going on.

	James Hopkins OP @Reply 5 years ago

	Richard Rost @Reply 5 years ago
Sounds like something is missing (deleted?) or spelled wrong. Compile the database and see if it stops you on a specific line of code.

	James Hopkins OP @Reply 5 years ago
Oh okay, thank you, Richard. You are the best, I will start running through the Troubleshooting Checklist now.1

	James Hopkins OP @Reply 5 years ago
Thank you Richard, the Troubleshooting techniques worked. I found out that I had written same VBA Code for a Form twice. Causing the ERROR message to occur. Thanks again for the help.

	Richard Rost @Reply 5 years ago
You're very welcome. When in doubt, compact and compile. :)

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

Next Unseen

New Feature: Comment Live View