VBA not executing

  • Thread starter Thread starter wmdmurphy
  • Start date Start date
W

wmdmurphy

I have an Access 2007 app that has run successfully on two different
computers in the past. On computer one it still opens and runs as expected.
Computer two had a hard disk crash recently, and most data and programs have
been restored to the newly installed hard disk.

However, the Access app will not open properly on computer two, and it
appears that VBA is not executing. The main form does open, but no command
buttons on the form will execute the underlying VBA code. I also set a
break in the open event of the main form, and this does not execute when the
app is opened. No data is displayed on the main form, although it has a sub
form which should display data in a grid (this displays properly on computer
one).

I have compiled the app on computer two, and I have compacted and repaired
it there.

I would appreciate any thoughts on how to resolve this.

Bill
 
I just started with 2007 but I'm guessing it has to do with the program
opening is disabled mode and you need to address this in the truct center,
located under teh msft button in the upper left of your window.
 
Mike,

You were absolutely right! I added the folder on drive C to trusted
locations in the Trust Center, and afterwards the app opened as expected and
VBA executed normally.

Thanks for your help.

Bill
 
Back
Top