Command Buttons Don't Work in Access 2007

  • Thread starter Thread starter Robert T
  • Start date Start date
R

Robert T

Hello:

I'm sure there's a quick and easy answer to this question.

After doing all of my previous work in Access 2003, I just installed Access
2007. Much to my surprise, the first time I opened a custom form, none of the
command buttons on my form worked. I couldn't open a report, save a record,
run a query, etc. Can someone please explain why.

In addition, can you also take a couple of moments to highlight any
significant changes I should be aware of and kind of point me in the right
direction to make the transition to 2007 go a little smoother.

Thanks,
Robert
 
Robert T said:
Hello:

I'm sure there's a quick and easy answer to this question.

After doing all of my previous work in Access 2003, I just installed
Access
2007. Much to my surprise, the first time I opened a custom form, none of
the
command buttons on my form worked. I couldn't open a report, save a
record,
run a query, etc. Can someone please explain why.
Click to expand...

VBA code is disabled in Access 2007 by default, as a security measure,
unless you explicitly enable it for the database or save the database in a
trusted location. If the database is not in a trusted location, you should
see a message (just below the ribbon, I think) telling you that the code is
disabled. Clicking on that message should give you an option to enable it.

(Note: this is from memory -- my work in Access 2007 is on a database in a
trusted location, so I haven't seen this message in a while.)

You can designate trusted locations via the Trust Center, accessible from
the Office button -> Access Options... -> Trust Center.
 
Back
Top