Solved

LOAD FORM in Access 2000 WITHOUT OPENING FORM

Posted on 2002-04-10
8
250 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

739 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