Buttons have stopped working in my Access 2007 database

[John m]

Thisis my first database in Access 2007, it is in a .accdb file which is
linked to tables in an online SQlServer database as well as having local
tables.

I have imported most of the forms from an earlier Acces 2002 database
configuring them to new data sources as neccessary. All this has worked
satisfactorily in this development phase until quite suddely the buttons
have ceased responding on all my forms. Their function is mostly to open up
forms but they do other things as well.

The buttons open up forms through using a click event to run code in Visual
basic. I am wondering if I have inadvertently changed some setting or other
which disables VB in the database.

If i insert a test button using the wizard to create a macro then that will
open a form but that way of doing things will not meet my needs.

I woould be grateful for any help in getting the original buttons responding
again to the vb code,

Best wishes, John Morgan

 

[Linq Adams via AccessMonster.com]

In 2007 your source file has to be in a "trusted" location for VBA code to
work.

Open A2007, click the "Office" button in the upper left, go to
Access Options/Trust Center

and add the source file of the db to the list of trusted locations.

 

[Pete D.]

You can also sign it with a certificate and then add publisher to trusted
publishers depending on how your network folks lock down your computer.

 

[John m]

Thanks very much, its all working properly now, more to Access 2007 than I
thought,

Best wishes, John Morgan

 

[Linq Adams via AccessMonster.com]

Someone here, don't remember who, made a statement that I thought was rather
telling. They said that people who had used previous versions of Access had a
much larger learning curve with 2007 than people who had never used Access
before!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com