Command Buttons Don't Work in Access 2007

[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

 

[Dirk Goldgar]

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.

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.

 

[Robert T]

Hello Dirk:

Thanks for the timely and informative explanation.

Robert