Windows In Taskbar

Posted on 2005-04-21
Last Modified: 2006-11-18
Gotta love this place...found an answer to my question ~ BUT it caused me to have a question I couldn't find the answer too (I admit I didn't look REAL hard).

I found that using:

application.setoption "ShowWindowsInTaskbar", true

Will turn the windows in the taskbar on and:

application.setoption "ShowWindowsInTaskbar", false

will turn them off.

My question is how do I return them to what the person had Access set to before they opened my database?  Is there a way to look and see what their setting is and store it before I fire the code to turn them on or off?  If so, how?

Question by:LenaWood
    LVL 26

    Expert Comment

    You can turn them on even if they're already on - you needn't check for a value.
    If you want them off all the time, you simply have

    application.setoption "ShowWindowsInTaskbar", False

    In a startup form's OnLoad event
    LVL 34

    Expert Comment


    Dave :-)
    LVL 10

    Author Comment

    What I want to do is make sure that I reset the option to the way it was originally set.  I don't want to turn it off or on without being able to put it back the way it was.  How does:

    ?Application.GetOption("ShowWindowsInTaskbar") help me do this?

    I have been working with Access 97 and was just upgraded to 2000 yesterday, so please bear with the transition stage :-)

    LVL 34

    Accepted Solution


    will return what its currently (originally if you use it on open) set to.

    Thought it may help
    LVL 10

    Author Comment

    This is what I did to make it work:

    Public blnTaskWindows As Boolean
    blnTaskWindows = Application.GetOption("ShowWindowsInTaskbar")
    Application.SetOption "ShowWindowsInTaskbar", False

    Then when I close the database (have to use a Quit button as X is disabled)

    Application.SetOption "ShowWindowsInTaskbar", blnTaskWindows

    This appears to set it back to the way the person had it just before they opened my database.

    Thanks for the help!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now