Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
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 September 30th, 2005, 11:18 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default Hide application windows when using Pop-Up form

Okay, I think this is easy, but I can't find any documentation yet.

I have an application that is basically one form with lots of dashboard data, and some report drill downs and buttons. Since it is pop up, you can move it off the application window and have it float by itself on the desktop.

What I want to do is have the main form float on the desktop while the application window is hidden or minimized. If I currenly minimize the app window, the form goes with it. So probably hiding it is best.

Any help?

Thanks,


mmcdonal
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old October 16th, 2005, 12:31 AM
Friend of Wrox
 
Join Date: Jul 2005
Posts: 150
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What version of Access are you using?

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
 
Old October 17th, 2005, 08:41 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Filea re typically Access 2000. I am using 2003 to create them.

mmcdonal
 
Old October 25th, 2005, 05:44 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

Not sure if this is doable in VB (it must be), but it is definitely do-able by using a shortcut and then changing the properties on the shortcut... I've used this for a number of mdb's and seems to work well, but I work in a locked down environment so have to use interesting methods like this from time to time!

[u]Suck eggs version:</u>

Right click on mdb, select Create Shortcut
Right click on the shortcut and select Properties
Select Minimised for the Run Property
Click Apply
Double click the shortcut.

Your application will start minimised, but the pop up should still "pop up".

Hope it works,

Lee
 
Old October 25th, 2005, 06:31 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Thanks leehambly, that worked great! I would like to do this programatically, but it is a nice compromise. I want to deliver some apps to my users, and the less interaction they have with the application window, the better. I don't need to totally lock it down, but this is nice.

Thanks again,


mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Pop up Windows with VBA Lars Ronnevig Beginning VB 6 1 February 13th, 2008 03:40 PM
Windows Form Application help tycotrix C# 4 January 11th, 2007 07:15 AM
How to create pop up windows in web application? samlow82 .NET Web Services 4 April 5th, 2005 11:30 PM
Menus and pop-up windows socoolbrewster Access 5 March 4th, 2004 06:35 PM





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