Monday, May 26, 2008

Tips on Controlling the Access Application Window

You can use some simple API calls from VBA to manage the Access Application window when you want finer control on how your Access application opens or is displayed:
  1. Make the Access application window invisible, so your application looks like an executable. Note: All menubars/toolbars/ribbons will also be hidden.

  2. Resize the Access application window to fit your start-up form and place it at specified screen co-ordinates.
I have prepared two sample MDB's (for Access 2000 or later) to display each of these techniques, and they are available for free download here.