Access 2007 Form Load Event Not Firing/Working

[Guest]

Hello,

Running Access 2007 on Vista Ultimate.

When creating a new database I'm able to create Form_Load events that work
just fine. Then after saving the database and reopening the it the events
stop working.

I've tested it with the absolute smallest database I could construct: one
form, no tables and only a form_load event. Still no luck - it works but
stops working on reopen. Better yet, once it's been reopened it cannot be
made to work again - I can't rewire the events or anything. It simply looks
like it will work but won't.

It's driving me crazy! Frustrated!

I'm a very experienced VBA programmer but I am new to Access 2007 on Vista.
There have been other versions of Access on this machine but they're all gone.

Does anyone have any ideas on what I could do to fix this problem?

Thanks,
Jason

 

[Guest]

Hi Jason,

Running Access 2007 on Vista Ultimate.

When creating a new database I'm able to create Form_Load events that work
just fine. Then after saving the database and reopening the it the events
stop working.

I've tested it with the absolute smallest database I could construct: one
form, no tables and only a form_load event. Still no luck - it works but
stops working on reopen. Better yet, once it's been reopened it cannot be
made to work again - I can't rewire the events or anything. It simply looks
like it will work but won't.

It's driving me crazy! Frustrated!

I'm a very experienced VBA programmer but I am new to Access 2007 on Vista.
There have been other versions of Access on this machine but they're all gone.

Does anyone have any ideas on what I could do to fix this problem?

maybe you create the database in a trusted location and then move it to
another, not trusted folder? Then execution of VBA code may be forbidden.

André

 

[Guest]

Hi Jason,

Does this help?

Dealing with the Trust Center
http://www.access.qbuilt.com/html/trust_center.html


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

THANKS to both of you! It's fixed.

Basically I was creating the database in the one [default] trusted location
and then saving it elsewhere. This would cause it to run fine when created
and then fail when closed and reopened.

Many thanks...Jason