VBA Command Not Working - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

VBA Command Not Working

Kevin Kronemeyer

2 years ago

I cannot get ANY VBA to work. I know that I make mistakes but I have checked, checked and rechecked copying the VBA code over during the seminars but I cannot get anything to function. Is there something I need to check to see if something is turned off in my version of Access?

	Kevin Kronemeyer OP @Reply 2 years ago

	Kevin Kronemeyer OP @Reply 2 years ago
In the picture I am showing the class VBA and the one that I typed in. I don't see anything missing but still it will not work. Any help would be great.

	Sami Shamma @Reply 2 years ago
what is the error you are getting?

	Kevin Robertson @Reply 2 years ago
is your database in a Trusted Location?

	Richard Rost @Reply 2 years ago
What happens when you Debug, Compile.

	Kevin Kronemeyer OP @Reply 2 years ago
I think I have found the problem, I get this message every time I start the DB. I've gone into the Options and made sure the file is in a Trusted folder. Anything else? I still get the same warning message.

	Kevin Kronemeyer OP @Reply 2 years ago

	Kevin Kronemeyer OP @Reply 2 years ago
Here's the message

	Kevin Kronemeyer OP @Reply 2 years ago
I went into the Options and made a few changes so it is working now. I just hope I didn't open myself up to Trust issues later.

	Richard Rost @Reply 2 years ago
For any VBA to work or even a lot of macro actions, you have to run the database out of a trusted folder. Just make sure that you don't download databases from untrusted sources online and run them from your trusted folder.

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

Next Unseen

New Feature: Comment Live View