is there a way to minimize other apps when access db opens 1

[Mindy343]

I used some info from this site to have the MS Access window to minimize when my database opens showing only the forms on the desktop. The only problem is that unless I maximize the screen other apps show on the desktop. Is there a way to minimize all other windows automatically when I open my database?

 

[Remou]

You can use the code below, however, if I were a user of an application that did this, I might find it annoying.

'From: blogs.msdn.com/oldnewthing/archive/2004/05/28/143771.aspx
Set wshshell = CreateObject("Shell.Application")
wshshell.MinimizeAll

 

[Mindy343]

Thanks Remou...glad you added the annoying tip...after opening the db a few times I decided to remove it although it worked great. It's one of those "You have to be careful what you wish for" things..not always what you expect!