By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,937 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,937 IT Pros & Developers. It's quick & easy.

How to Unhide DB Window w/VBA?

P: n/a
Applications I work with routinely hide the database window on Startup,
which, once open, return this value:
CurrentDb.Properties![StartUpShowDBWindow] = False

During maintenance, I use a special keystroke to close the main form and
leave me in the DB Window, but I always have to then unhide it before I can
work. I can use this to bring up the Unhide dialog box, but I still have to
hit enter to OK the action:
DoCmd.RunCommand acCmdWindowUnhide

Is there a better way to do this? For example:
SomethingDBWindow.Visible = True ??
Or a way for SendKeys to complete the action for me? (The SendKeys syntax
I've tried doesn't work.)

--Vic
Oct 3 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
victorcamp wrote:
Is there a better way to do this?
DoCmd.SelectObject acTable, , True

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

Oct 3 '06 #2

P: n/a
Ooooh! That's it! I knew there was a better way. Thanks!

"Granny Spitz via AccessMonster.com" <u26473@uwewrote in message
news:6739e27f2b181@uwe...
victorcamp wrote:
>Is there a better way to do this?

DoCmd.SelectObject acTable, , True

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200610/1

Oct 3 '06 #3

P: n/a
victorcamp wrote:
Ooooh! That's it! I knew there was a better way. Thanks!
You're welcome, Victor. I'm happy to share those *quickie* tricks!

--
Message posted via http://www.accessmonster.com

Oct 3 '06 #4

P: n/a
Granny Spitz via AccessMonster.com wrote:
victorcamp wrote:
>>Ooooh! That's it! I knew there was a better way. Thanks!


You're welcome, Victor. I'm happy to share those *quickie* tricks!
Check out these two URLs for a full-featured solution.

--
'---------------
'John Mishefske
'---------------
Oct 4 '06 #5

P: n/a
John Mishefske wrote:
>
Check out these two URLs for a full-featured solution.
Well I could have sworn I had pasted the URLs in...

Let's try this again:

http://www.mvps.org/access/general/gen0031.htm
http://www.mvps.org/access/api/api0069.htm

--
'---------------
'John Mishefske
'---------------
Oct 4 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.