Solved

What is the VBA code to minimize a form?

Posted on 2003-11-04
6
3,936 Views
Last Modified: 2010-08-05
Hi Experts,

What is the VBA code to minimize a form? Thanks
0
Comment
Question by:indyng
6 Comments
 
LVL 18

Expert Comment

by:lludden
ID: 9680366
DoCmd.Minimize
0
 
LVL 10

Accepted Solution

by:
perkc earned 20 total points
ID: 9680390
docmd.SelectObject acForm,"FormName"
docmd.Minimize

perkc
0
 
LVL 1

Author Comment

by:indyng
ID: 9680430
Where is the comment?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 6

Expert Comment

by:bknouse
ID: 9680455
Just a few notes to the solution from lludden....

The object being minimized is the current selected form.  If the current selected form is not the form you want minimized, you must first make the form to be minimized the current selected form.

Minimizing a form puts an icon for the form on the task bar.  You may essentially do the same thing using the visible property of the form or using the hide method for the form.  These versions do not put an icon on the task bar.

Brent
0
 
LVL 39

Expert Comment

by:stevbe
ID: 9680464
from a command button's click event on the form you want to minimize

Private Sub cmdMin_Click()
   DoCmd.RunCommand acCmdDocMinimize
End Sub

from a command button's click event to minimize the entire application
Private Sub cmdMin_Click()
   DoCmd.RunCommand acCmdAppMinimize
End Sub

Steve
0
 
LVL 10

Expert Comment

by:perkc
ID: 9680494
I just assumed you only needed the code.

Sorry to have seemed hasty:)
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Getting Run-time error 91 - Object Variable or With Block Variable not set 20 35
Top 1 of each supplier 55 57
Access Update Query 1 20
Access check if a table is open 4 43
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

803 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