Can't get any of my code to execute! (1 Viewer)

[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?

 

[SOS]

If you are in Access 2007 then you need to set the location of the database to be a trusted location. See here for more about that.

 

[PKJ]

If your database be Access-2007 - You may locate a bar below the Ribbon showing the message -

"certain content in the database has been disabled" and a button besides it giving you option to allow it. I hope it should do if your database location/path has not been declared 'trusted location' which you can set in "Access Options". Visit this link to know how to do it -

http://www.access-programmers.co.uk/forums/showthread.php?t=189817

 

[blacksaibot]

THANKS! It runs now.

 

[smig]

it should be either:
myMsgBox = msgbox("This is a test")

or:
msgbox "This is a test"

 

[vbaInet]

msgbox "This is a test"

This is the one. The other one is when you're testing for the value returned based on the user's response.

 

[smig]

This is the one. The other one is when you're testing for the value returned based on the user's response.

sure
Only wanted to give him both options

 

[vbaInet]

sure
Only wanted to give him both options

Was just clarifying smig