Go to Top

How to Open your MS Access Application like a Custom Software Application


Level of Difficulty

Easy

ADVERTISING
ACCESS SAFETY AND TRAINING DATABASE

Applies to MS Access Versions

Access 2000+

Overview:

Sometimes, when we create a full blown application, utility, or departmental tool, we only want to see the opening form pop up on the screen and leave the full MS Access application window at the bottom of the toolbar.

In this MS Access tutorial, we will show you how to open a Microsoft Access database so it appears minimized at the bottom of your screen, and all you see is the first form you declared as the opening form. You will now be able to double-click on the icon to only view the form and not MS Access.

This is easier to achieve than you may think, here are the simple steps:

1.1. Open the form you intend to use as the main form in design view. In the attached example database OpenAccessFormOnly.accdb, I have the same main menu form entitled frmMainMenu. Be sure to set the form property PopUp = True.

Step 1 How to Open your MS Access Application like a Customer Software Application Access Experts Blog IT Impact Jay McCormick

2. In the backstage view, open the Database Options window and choose the “Current Database” tab. In the “Display Form’’ option, drop-down the list and select the form you intend to use as the startup form. In my example, I have selected the form frmMainMenu.

step 2 How to Open your MS Access Application like a Customer Software Application Access Experts Blog IT Impact Jay McCormick

3. Click “OK” to close the database options dialog box.

4. You will see this message box appear

step 4 How to Open your MS Access Application like a Customer Software Application Access Experts Blog IT Impact Jay McCormick

Click ‘ok’.

5. Close the database.

6. Go to your desktop, right click in any blank area and choose ‘New’ then ‘Shortcut’. Browse to the .accdb file you just created. In this example, I choose the OpenAccessFormOnly.accdb database.

step 6 How to Open your MS Access Application like a Customer Software Application Access Experts Blog IT Impact Jay McCormick

 

Then click ‘next’ and ‘finish’ if necessary, creating the icon on your desktop.

Step 6 b How to Open your MS Access Application like a Customer Software Application Access Experts Blog IT Impact Jay McCormick

7. Right click on the shortcut you just created and choose ”Properties.”

Step 7 How to Open your MS Access Application like a Customer Software Application Access Experts Blog IT Impact Jay McCormick

 

8. This second dialog appears as below. Choose the ‘shortcut’ tab and notice a drop-down option called ‘Run’. Drop-down and choose ‘Minimized’ as shown below.

Step 8 How to Open your MS Access Application like a Customer Software Application Access Experts Blog IT Impact Jay McCormick

 

 

9. Click ‘Apply’ then click ‘OK’.

10. Double-click your icon and voila! Now you’ll ONLY see the main form appear, with Access minimized at the bottom of the screen.

,

About Jay McCormick

Jay McCormick is a Senior Access Developer at IT Impact, Inc., and has been working on creating MS Access solutions since 1994. Jay has worked in five states, with dozens of clients building a wide range of applications in a wide spectrum of industries. Jay has excellent skill in understanding a customer’s need and translating that into a very usable application that meets the need. Jay has utilized MS Access with SQL Server, as well has high skills with linking Excel of SQL Server, and linked Access databases with other proprietary technologies. Jay contributes is currently pursuing a professional development path toward full Microsoft certification as a solutions developer, and Access MVP.

19 Responses to "How to Open your MS Access Application like a Custom Software Application"

  • Aftab Hussain
    September 10, 2017 - 5:41 pm Reply

    Once you minimize the pop out form and then go back into it, the Access window itself gets opened at that point. Is there any way around that?

  • Matt
    August 4, 2017 - 3:00 am Reply

    I like it…except, when I close the pop-up form (e.g. MainMenu), Access remains on my taskbar, it doesn’t close?

  • Maria Favereaux
    January 19, 2017 - 1:46 am Reply

    Thank you soooo very much!

  • Brian
    August 4, 2016 - 9:06 pm Reply

    Once you minimize the pop out form and then go back into it, the Access window itself gets opened at that point. Is there any way around that?

  • Shahram Vesali
    June 12, 2016 - 4:19 am Reply

    Perfect. worked very well for me. Thank you

  • Mandy
    June 3, 2016 - 4:23 am Reply

    It’s easy and great? thank u

  • Affiq Arip
    June 1, 2016 - 9:02 am Reply

    is it possible if i want my forms to run out of access? i mean that i dont need to open access to run the forms no matter it is minimized or not. is it possible? this is my task to try to run the forms without opening access.

  • wonder stars™
    April 9, 2016 - 7:02 pm Reply

    thank you very much.
    worked on win7 very well

  • Anthony Gyasi
    February 12, 2016 - 5:53 pm Reply

    Thanks very much………….. works so great

  • Sanjay
    November 25, 2015 - 7:36 pm Reply

    Good Work. I am able to open the main form but when I press the button I created for my record, it does not show me the form for the record but the main form only. please guide how to move forward from the main menu ?

  • AccessGuy
    June 6, 2015 - 8:53 pm Reply

    Nice. Except… Now none of my right-click shortcut menus display anymore. No errors. They just wont display. Any idea how to fix that and still keep the Access window minimized?

    • Jay McCormick
      June 8, 2015 - 7:31 pm Reply

      AccessGuy – interesting…… didn’t know simply opening access minimized would result in causing the shortcut menus to not display anymore – bummer. There are a few workarounds – one accessed based workaround is to highjack a ‘right mouse click’ type event in the vein of a blog post at http://www.access-programmers.co.uk/forums/showthread.php?t=104970, and to create a form to appear at the point on the screen of the mouse pointer – a form that has no border, looks just like a pop up menu, etc. Another approach is to use API’s – there are lots of different articles like http://access.mvps.org/access/api/api0019.htm that have a great API type function to hide the actual access window. My blog post here was meant in the spirit of ‘low tech’ simple no coding solution. Obviously you have shown that it sort of wipes out the shortcut menus, so it wont work on apps that have short cut menus.

      • AccessGuy
        June 8, 2015 - 7:51 pm Reply

        Thanks. Yeah that mvp routine you link to is the first thing I tried. Same problem. If the Access window is minimized by any means I have tried, shortcut menus silently just fail to display. Bummer indeed. So far my resolution is like the old doctor joke: “Well, don’t do that…” But I would love to find a better one.

        • Jay McCormick
          June 8, 2015 - 7:54 pm Reply

          You will have to go with the first link I supplied, simulate a right mouse click event combined with actually opening up an access form that looks like a right mouse click menu. A hack workaround but I’ve seen people use forms for right mouse click menus before. That is your only hope before you hit the wall of the old doctor joke of “Well, don’t do that…..”

  • Paul Cook-Giles
    March 20, 2015 - 9:09 pm Reply

    I’m feeling awfully dim; I’ve been working in Access for 20 years, and always wanted to have my users see only the forms (or other created objects) at runtime, and not the full db window. I’m running Access 2010, have followed these instructions several times– both with your downloaded db and my own– and I’m still seeing the full db window. Any suggestions?

    • Jay McCormick
      March 20, 2015 - 11:01 pm Reply

      You have to have the shortcut set to open the database MINIMIZED. Without that little checkbox checked ‘open minimized’ in the icon that is on the desktop, it won’t work. It has to be a SHORTCUT pointing to the actual database. Also, the opening form you have set must be pop up. Again, it has to be a shortcut and the shortcut has to open minimized.

      • Paul Cook-Giles
        March 21, 2015 - 12:11 am Reply

        I’m just stumped. I have a shortcut on my desktop, the Run: option in the shortcut is “Minimized”, and the database’s DisplayForm is frmMainMenu, with the PopUp property set to Yes.

        • Jay McCormick
          March 21, 2015 - 12:36 am Reply

          you could have the maximize property set on the form itself – have you checked that? my example is proven to work.

  • Andy Rice
    February 5, 2015 - 11:19 pm Reply

    I like that, thanks.

Leave a Reply

Your email address will not be published. Required fields are marked *

 

Contact Us
[gravityform id="16" title="false" description="false"]