Minimize a Pop Up Form?

Jim Dudley

Registered User.
Local time
Today, 08:47
Joined
Feb 16, 2012
Messages
81
Access 2010
Windows 7 (Fully Updated)

I have a Pop up form that is used to get user input in two fields. [StartDate] and [EndDate].
The form must remain open for these 2 Parameters to be used in subsequent Queries.
I am still developing this application and testing the Queries and Macros.
The Pop Up Form is constantly in the way when working on other items.
Is there a way to minimize a Pop Up Form so that is still active but not in the way.
I have looked through all the Tabs in the Property Sheet for this Form but cannot identify one that would allow me to Minimize the Form in a Macro after I have obtained the User Input.
Any suggestions?

Thank you.

Jim
 
DoCmd.Minimize - Have a look at this: http://msdn.microsoft.com/en-us/library/ff837032.aspx
also DoCmd.Maximise and DoCmd.Restore.
Why do you say your form has to stay open to use the parameters? You can store the values in public global variables (in another form or in a module) from the form before closing it. I'm assuming you don't need to change the values often, which may not be the case.
 
I appreciate your comment about values in public global variables etc. but I am not that far advanced yet.
Actually, in this case, each time the function will be launched, the variables will change and then stay consistent until the next cycle. At that time a different set of Date Ranges will apply.

For now adding the minimize command to the Macro will solve the immediate problem and as I get better I will change my method of dealing with this type of situation.

Thank you for Input.

Jim
 

Users who are viewing this thread

Back
Top Bottom