Access 2007 Form Load Event Not Firing/Working

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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?
Click to expand...

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é
 
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
 
Back
Top