Solved

Database Window At Start UP

Posted on 2004-09-06
7
217 Views
Last Modified: 2010-05-18
My question is, i have an access app i created most of it in Access 2000 and now have ugraded to 2002 when i was using 2000 i used the startup options and had the "Show database Window" option unticked, now i am using 2002 and the option in startup is still untick, the app loads and shows the startup form but in the task bar you can still click on the database window and it will show, but in 2000 this didnt happen at all? help how can i fix this
0
Comment
Question by:jonoscs
  • 4
  • 3
7 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 11994200
Add this to your opening form.
  Application.SetOption "ShowWindowsInTaskbar", False
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 11994205
Alternatively Tools/Options Windows In Taskbar
0
 

Author Comment

by:jonoscs
ID: 11994229
tools/options is ok but when people unslect that option to use another database, mine will then revert back to showing again once reopened
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 46

Expert Comment

by:tbsgadi
ID: 11994257
So use the code/macro alternative.
You can use an autoexec macro if you don't want to use code.
0
 

Author Comment

by:jonoscs
ID: 11994280
what code should i put in the code/macro section
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
ID: 11994290
The easiest way is to put this behind the first form that you open.

Private Sub Form_Load()

  Application.SetOption "ShowWindowsInTaskbar", False
 
End Sub
0
 

Author Comment

by:jonoscs
ID: 11994312
OK THANK YOU
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

760 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

18 Experts available now in Live!

Get 1:1 Help Now