Windows In Taskbar

Posted on 2005-04-21
Medium Priority
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
  • 2
  • 2
LVL 26

Expert Comment

ID: 13836286
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

ID: 13836583

Dave :-)
LVL 10

Author Comment

ID: 13837374
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

flavo earned 500 total points
ID: 13837414

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

Thought it may help
LVL 10

Author Comment

ID: 13858424
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!

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

840 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