Can't get any of my code to execute!

[blacksaibot]

I'm simply trying to make a message box display when a user clicks on a button.



I go to the "On Click" section in the properties sheet.
I select Code Builder

I simply put msgbox("This is a test")

I save it

I open the form, I click the botton and NOTHING happens
What am I missing here?

[ajetrumpet]

are you saving the code? save the form, the code, and make sure there is something in the event line of the properties window. like "[event procedure]"

also, I don't believe () are needed when you are manually entering a string in the code for the message. simply put:

msgbox "my message" 

[pbaldy]

Make sure the database is in a Trusted Location (Office Button/Access Options/Trust Center) or that code has been explicitly enabled. Otherwise, no code will run.

[blacksaibot]

Nevermind I got it to work. It was the trust center. Thank you!

are you saving the code? save the form, the code, and make sure there is something in the event line of the properties window. like "[event procedure]"

also, I don't believe () are needed when you are manually entering a string in the code for the message. simply put:

msgbox "my message" 

Yeah I save the code and the form, and the event line of the properties does have that in there. I got rid of the parentheses and it still didn't execute.

Make sure the database is in a Trusted Location (Office Button/Access Options/Trust Center) or that code has been explicitly enabled. Otherwise, no code will run.

How do I "explicitly" enable it?

[pbaldy]

No problemo, glad you got it sorted out.