Wrox Programmer Forums
|
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 June 8th, 2006, 07:18 AM
Authorized User
 
Join Date: May 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default Start Up Help needed

I unchecked the startup options for toolbars, shortcuts ect.
Okay, my goal was to remove access to the database window so no
one could get directly into table or make changes.
Well, It removed the "tools" option on the pulldowns and the database window is still showing up.
How can I get back into the tools option and how can
I hide the database window?
Please Help fast!!! Yikes!!
Thanks

John Paul
__________________
John Paul
 
Old June 8th, 2006, 10:33 AM
Authorized User
 
Join Date: May 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was able to fix the first part of the problem.
Answer: hold the shift key down when opening the database to by-pass
         the start up options.
Still working on the second problem. to hide the database access window.
Whew!
Thanks

John Paul
 
Old June 8th, 2006, 10:42 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Tools > Startup...

Uncheck "Display Database Window"

If you need to unhide the database window once in the database, hit F11.

You may also want to change the properties on each object in the database to Hidden. Then if you need to see them go to Tools > Options > View tab, check Hidden Objects.

Some users know how to show the database window with F11, but most don't know how to unhide objects.

HTH

mmcdonal
 
Old June 8th, 2006, 11:47 AM
Authorized User
 
Join Date: May 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks, That helped.
One question, I have 2 databases. On one, these options worked. Database window is hidden. One the other, even If I uncheck the view database window
and check the hidden objects, it still displays the db window.
I'm wondering if there is something in the code that overrides the setting.
Thanks

John Paul
 
Old June 8th, 2006, 11:48 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Check the code for any forms that run when the database opens. That's all I can think of.

mmcdonal
 
Old June 8th, 2006, 12:01 PM
Authorized User
 
Join Date: May 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

one other option that I found was in the macro Autoexec.
First runcommand was "windowhide".
Even though it was there, it still wasn't hiding it.
So, I added a second runcommand with the same command
(windowhide). That worked. Wow. I don't know why the first
wasn't working, but there is more than one way to skin a
Access command.
Thanks again!

John Paul





Similar Threads
Thread Thread Starter Forum Replies Last Post
Where to start if also new to C# merlin89 BOOK: ASP.NET Website Programming Problem-Design-Solution 2 March 17th, 2011 05:09 AM
don't know where to start timbal25 Access VBA 1 October 18th, 2007 02:17 PM
how I start it?? italimeme JSP Basics 2 May 28th, 2007 02:07 AM
Where do I start? Michele_Haywood Access 1 November 2nd, 2006 09:39 AM
Where to start? jerush Dreamweaver (all versions) 1 August 12th, 2003 07:03 PM





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