kinsey
asked on
Wrong Window Closes
I have an Acceess 1007 database
When the user duoble click a control on my menu form the DblClick event open a query with
DoCmd.OpenQuery ObjName, acViewNormal, acReadOnly
The query opens and displayes normaly, but when you click the CloseBox on the Query the Menu forms unload event fires and the Query window dows not Close
Why? and how do I stop it.
When the user duoble click a control on my menu form the DblClick event open a query with
DoCmd.OpenQuery ObjName, acViewNormal, acReadOnly
The query opens and displayes normaly, but when you click the CloseBox on the Query the Menu forms unload event fires and the Query window dows not Close
Why? and how do I stop it.
Hamed Nasr
Attach a sample database that reproduces the issue. Tell us what to do to replicate the effect.
Have you compacted your database? In 07, click the Office Button - Manage - Compact.
Make sure your Office/Windows installs are fully up to date.
Was this a database that was upsized from 2003 or earlier? If so, you'd be well advised to build a new, blank db in 2007 (you can still use the .mdb format) and import everything into that new database.
Make sure your Office/Windows installs are fully up to date.
Was this a database that was upsized from 2003 or earlier? If so, you'd be well advised to build a new, blank db in 2007 (you can still use the .mdb format) and import everything into that new database.
ASKER
The database is an MDB being used in Access 2007.
I was'nt able to find a solution to the original problem but was able to work around it by setting the 'Overlapping Windows' option for Access.
Now when I switch back to 'Tabbed Wndows' I no longer have the problem.
I was'nt able to find a solution to the original problem but was able to work around it by setting the 'Overlapping Windows' option for Access.
Now when I switch back to 'Tabbed Wndows' I no longer have the problem.
Your workaround should have no impact on your issue. I'd strongly suggest you insure that you are not working with a corrupt database, as the behavior you report would indicate troubles with your project.
If this were mine, I'd immediately build a new, blank db in 2007 (use the older format) and import everything into that new database. Now Compact the db, then Compile, and then Compact again.
If this were mine, I'd immediately build a new, blank db in 2007 (use the older format) and import everything into that new database. Now Compact the db, then Compile, and then Compact again.
ASKER
I have imported to a new database and the problem stil exits in the tabbed windows mode.
Never have a problem in the overlapping windows mode.
I spoke too early when I said I no longer have the problem. After opening a few windows in tabb mode the problem re-surfaces.
I'll just use the overlapping windows. I like it better anyway.
Never have a problem in the overlapping windows mode.
I spoke too early when I said I no longer have the problem. After opening a few windows in tabb mode the problem re-surfaces.
I'll just use the overlapping windows. I like it better anyway.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.