Solved

LOAD FORM in Access 2000 WITHOUT OPENING FORM

Posted on 2002-04-10
8
242 Views
Last Modified: 2007-12-19
Hello everyone,

My application consists of Three primary Master Forms. These forms each contain many subforms
so these Master Forms take more than a few seconds to load. I would like to load these forms into memory
when the Application is opened but I can't seem to find the LOAD Form command. Right now I use code in the On Open Property of My switchboard to OPEN the forms and then minimize them, but this looks messy.

What is the command or method to load these forms into memory when the application is loaded  without opening the forms.

Thanks

kan
0
Comment
Question by:kkan
  • 5
  • 3
8 Comments
 
LVL 9

Expert Comment

by:Volibrawl
ID: 6931255
To look less "messy", you could try opening your forms in Hidden mode instead of opening and then minimizing.
0
 
LVL 9

Expert Comment

by:Volibrawl
ID: 6931273
The OpenForm method carries out the OpenForm action in Visual Basic. For more information on how the action and its arguments work, see the action topic.

Syntax

DoCmd.OpenForm formname[, view][, filtername][, wherecondition][, datamode][, windowmode][, openargs]

The OpenForm method has the following arguments......

windowmode     One of the following intrinsic constants:
acDialog
acHidden
acIcon
acWindowNormal (default)
If you leave this argument blank, the default constant
(acWindowNormal) is assumed.
0
 

Author Comment

by:kkan
ID: 6931410
Volibrawl,

Thanks for your comments. Opening the form in hidden mode will work for my purposes. Also given your method and my current set up  I  need to open the form in Add mode AND Hidden mode.

If I understand you, the correct syntax to accomplish this would be:

DoCmd.OpenForm stDocName, , ,[ ,acAdd] [,acHidden]

Please excuse my as yet poor sense of syntax. If I am wrong would you be able to provide the correct syntax?

Thanks

kan
0
 
LVL 9

Expert Comment

by:Volibrawl
ID: 6931583
Actually you don't need the brackets, Access help shows them that way meaning "optional".  Just include the appropriate number of commas:

DoCmd.OpenForm stDocName,,,,acAdd,acHidden
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 9

Accepted Solution

by:
Volibrawl earned 50 total points
ID: 6931624
Here's a procedure I have used for slow opening, frequently used forms.

1. When the application loads, I have an autoexec macro that "opens" these forms "hidden".
2. I have command buttons that open the forms as needed.  When you execute a command to "open" the form, if it is already open (hidden) Access displays it (makes it visible)  quickly.  You can put your open parameters into that command:

DoCmd.OpenForm stDocName,,,,acAdd,acNormal

3. When you want to leave that form, INSTEAD of CLOSING it, you HIDE it again.  eg attach the following code to a command button (say CLOSE).

Forms!MyOpenForm.Visible = False


If all your forms are maximized, the forms just keep opening in front of each other and then "hiding" allowing the previous form to show through.
0
 

Author Comment

by:kkan
ID: 6932266
Volibrawl,

Many thanks!

This is exactly what I'm looking for...

The well earned points are yours
0
 
LVL 9

Expert Comment

by:Volibrawl
ID: 6932425
Glad to help  .. just click the accept answer bar on any of the comments and be sure to give me a grade ...

bye..
0
 

Author Comment

by:kkan
ID: 6938772

Sorry for the delay in accepting your answer. I thought I had already accepted when I had posted the last comment and only realized that I had not when I signed in today.


Thanks again and have a great week end.

kan
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

760 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now