I got the screen dimmer code over 10 years ago & couldn't remember the source.
I've just looked the source you mentioned here:
http://blog.nkadesign.com/2008/ms-access-modal-dialogs-with-transparent-backgrounds/
Its exactly the same effect as 'mine' but the code is totally different - Rob's is much more concise so I may adopt that (or the newer version)
I see you've used that code in your example
Anyway, I've just knocked up an alternative where the following things are hidden when the message box is displayed:
- entire Access application window (title bar/nav pane/ribbon)
- taskbar
- desktop icons
- minimises all other open application windows
The effect is for the message box to be 'floating' on the desktop
When the user clicks OK to close the message, everything returns to normal including the minimised application windows
Your thoughts?
I'll also have a look at your code later this evening if I have time
The obvious question is why is it necessary to involve the use of Excel?
If you could do it all in Access, it would be much quicker
------------------------------------------------------------
This is the rather odd effect I get with your example on a dual monitor setup:
As you can see, its merged both desktops into one image which is what happens whenever I capture the screen in Windows
Unfortunately its then distorted that showing part of both screens
Maybe you could adapt to capture just the primary monitor window ...
OR have a 'blurred image' stored in the same folder and load that behind the message box when it is displayed.
It would be far faster as you wouldn't need to copy the screen to clipboard etc ...