Form hangs access displaying caculating when loading

[MikeT]

I have an app written in 2000 that loads a form just fine.

When I try to open it with Access 2007, the form hangs access displaying
"Calculating . . . " in the status bar causing a Not responding state.

The form has 4 tabs, 1 subform and several lookup fields in the primary tab.

I am using the switchboard to manage the app. If I launch access with
suppressing auto startup and launch the form from design mode I get the same
results. I have tried changing several properties on the form with no luck.
Any suggestions are appreciated.

Thanks!
Mike T.

 

[Linq Adams via AccessMonster.com]

Can't actually see your app, so I'm just guessing here, but the first
question to ask when a pre-2007 form has problems running in v2007 is, "Have
you declared the folder holding your database file as Trusted?"

Code in a v2007won't run unless you have.

To trust your folder, click:
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

 

[MikeT]

Linq Thanks for reply

Yes I did trust the location and subdirectories.

What's even stranger . . .

I have a second form that will lock up the same way when I insert a new row
(via add button) unless I first move to the end of the recordset.

Unfortunately, that trick isn't working on this form.

 

[Linq Adams via AccessMonster.com]

Well, if it's hanging on startup, I guess the next step would be to look at
what code it has in the Form_Open, Form_Load and Form_Current subs.

 

[Linq Adams via AccessMonster.com]

Trolling around, I found that "

Access 2007 stops responding when you put the focus on a null date field on a
database form that is created in an earlier version of Access."

I suppose that if the first field to receive focus on your form is a Date
field and in the first record this field is Null, that could be the cause.
Should this be the case, a hotfix is at this link:

http://support.microsoft.com/kb/952699/

Of course, I suppose you also have to consider corruption. You might try the
old create-a-blank-database and import all objects into it and see if that
helps.