I have found and adapted code that will shrink the main Access window behind my startup popup form, so that the user is not distracted by the underlying Access window. The code uses user32 library functions and ultimately uses SetWindowPos to reduce the Access window size to 5% of its full size. When closing the startup form, code includes the user32 library ShowWindow function to maximize the Access window. It works like a charm, except that the small Access window can be seen if one moves the currently visible popup form.
I've also seen similar code that claims to HIDE the main access window while still showing the popup form. That code uses user32 library funtions and ultimately uses the user32 library function ShowWindow function with the SW_HIDE (=0) paramater. The claim is that this hides the Access window and still allows the active form to be used. An example I've seen in several places on the web is at http://access.mvps.org/access/api/api0019.htm
(code by Dev Ashish), where the key claim is: "This same function can also be used to completely hide Access window and just show your form on the desktop. Make the form popup and from it's Open Event, call the fSetAccessWindow function with SW_HIDE as the argument."
I'm using Access 2010. When I follow these suggestions to the letter, both the Access windows and the popup form disappear, and I have to run a stand-alone module, outside the code that's supposed to run in the application I'm developing, to re-show both the Access window and the pop-up form.
Did the code to HIDE the Access window work prior to Access 2010 (or prior to Access 2007)? Or was the original "solution" not a working solution at all? Or is there something else I can do?