Access 2010 in Windows 7 woes

G

Gary Wardell

Hi,

I have an Access application that I'm upgrading to Access 2010.

The problem is it seems to work correctly when running on Windows XP Pro.
But several forms fail when running on the clients machine which is running
Windows 7 Pro. Both machines are 32bit with the latest service packs.

I've poked and prodded and haven't come up with anything conclusive other
that one of the forms runs if I remove the two subforms that are on it. No
go if I only remove one of the sub forms. Both of them have to be removed.

What happens when it fails is the form displays correctly the first time.
But after closing the form and rerunning it form the main menu it fails
with:

Run-time error "3420":

Object invalid or no longer set.

When pressing "Debug" the highlighted line is:

DoCmd.OpenForm "Member", acNormal, , , acFormEdit, acWindowNormal

However this line just ran and the form is still there.

Also, after this occurs every menu item then files with the same error, even
calls to other menus and forms that have always worked.

It's like some object within Access has been closed that shouldn't have
been.

It certainly seems like sub-forms don't work on Windows 7, but that doesn't
make sense.

I'm out of ideas.

Gary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top