Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 15th, 2005, 08:40 AM
Registered User
 
Join Date: May 2005
Location: Philadelphia, PA, USA.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2000 "Windows in Taskbar"

How do i turn of the "Windows in Taskbar" options setting with code? I had written a function that used sendkeys to go and change the value of the windows in taskbar checkbox field located in tools->Options->Windows in Taskbar, but this doesn't seem to work all the time. Does anyone know how to access the Options Menu from VBA Code? Theirs got to be a way. Any help would be great.

 
Old July 15th, 2005, 12:08 PM
Authorized User
 
Join Date: Jun 2005
Location: , , .
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Application.SetOption "ShowWindowsInTaskbar", False


 
Old July 15th, 2005, 01:05 PM
Registered User
 
Join Date: May 2005
Location: Philadelphia, PA, USA.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for the info it works great.

I was just curious, but how do u find out the list of "OptionName's" for the "Application.SetOption" command?

The object browser gives you the list of members for the application class, but it doesn't give you a description of what the members do or anything else. Do u know a good online resource that would help describe the various Access classes and associated members?


 
Old November 14th, 2006, 09:35 PM
Registered User
 
Join Date: Nov 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

And how would I go about writing an If statement for that?

' If Statement
If Application.SetOption("ShowWindowsInTaskbar",False ) Then
strWIT = "Off"
Else
strWIT = "On"
End If

' Do it the way I want
Application.SetOption "ShowWindowsInTaskbar", False

' Set it back the way it was before quitting
If strWIT = "On" Then
Application.SetOption "ShowWindowsInTaskbar", True
End If

DoCmd.Quit
 
Old April 3rd, 2007, 11:38 AM
Registered User
 
Join Date: Apr 2007
Location: Springfield, MA, USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default


 To view the members of the Application.Setoption command visit:

http://msdn2.microsoft.com/en-us/library/bb256546.aspx









Similar Threads
Thread Thread Starter Forum Replies Last Post
ACCESS 2000 Report problem on Windows 2003 scourge Access 1 April 19th, 2006 05:36 AM
HELP - Access 2000 Runtime w Windows XP Compiled.. chasidim Access 2 April 3rd, 2006 11:06 AM
Windows taskbar from Excel VB scognet Excel VBA 0 July 7th, 2005 08:16 AM
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM
Windows 2000 and SQL 2000 in Korean Language mipo SQL Server 2000 0 February 19th, 2004 12:50 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.