Show Desktop with VBA

[Learn2010]

I have looked everywhere and cannot find the answer. I need to minimize the MS Access 2010 application. DoCmd.Minimize and DoCmd.RunCommand accmdappMinimize does not work. It closes the current form, but not the app. I need the app to minimize to an icon on the Taskbar. Can you help?

Thank you.

 

[Beetle]

Just tested with Access 2010 -

DoCmd.RunCommand acCmdAppMinimize

- minimizes the application window (not just the form, the entire application)

Are you saying that the above line is only minimizing the form for you?

 

[Learn2010]

DoCmd.RunCommand acCmdAppMinimize doesn't work at all.

DoCmd.Minimize minimizes the form and leaves Ribbon and the icons exposed.

However, I am using Peters Software ShrinkerStretcher. Could that be causing a problem?

 

[Beetle]

I wouldn't think that using a third part add-in module like that would have any effect on the ability to use standard Access commands. I've never used any of Peter's Access products, so I couldn't really comment on it, other than to say I don't recall ever hearing of anyone having any problems like this related to any of Peter's third party modules.

Have you checked your References to see if anything is missing? Missing references can cause odd behavior, including standard Access commands not working.

 

[Learn2010]

These are the references I currently have checked.

Visual Basic For Applications
Microsoft Access 14.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 2.1 Library

Any suggestions?

 

[Beetle]

Can you post a sample db that duplicates the problem? That doesn't mean the problem will manifest when I open it on my end but it may help eliminate some possibilities