Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2007 - Why doesn't the VBA work?

Status
Not open for further replies.

Mtlca401

Programmer
Mar 18, 2003
42
0
0
US
I am try to build some code in Access 2007, but can't figure it out. I am not a beginner, but I can't get just a simple code like this:

msgbox "testing"

to work when I add an event procedure. Even when I mark the line to debug it it doesn't go through the event. It does nothing. Is there something I have to set to get the visual basic part to work? I have programmed a lot in 97 and 2000, but 2007 is way different.
 
What is the macro security level ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
I didn't know about that feature, so I changed it to enable all and it works for now.

thanks
 
That's what it was, then, the security feature.

It was under Tools -> Macros ->Security, or some option of that nature, correct? It may be labeled differently in 2007.

--

"If to err is human, then I must be some kind of human!" -Me
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top