Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / April 2006

Tip: Looking for answers? Try searching our database.

Open permanently a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GL - 30 Apr 2006 14:11 GMT
Hi,

I use forms with few combo boxes that populate from thousands of records.
When I open this form it takes a couple of seconds to be drawn.
I have two questions.
• How can I make the form opened during start up and stay invisible or
hidden and how can I reveal it on demand?
• In case the form stays always open, is there any other expense except the
increase in memory use?

Thanks
GL
Ofer Cohen - 30 Apr 2006 18:59 GMT
1. After the form is open you can  set it to visible False

Forms![FormName].Visible=False

2. Instead of openning the form later on, all you need to do is set the form
to visible True
3. Create a close button on the form, that will  set the form to visible False

================================
The problem with this approach is that the data on the form won't be
refreshed, so and data that was entered after the form was loaded wont be
displayed on the form.
To display the data you'll need to refresh the form, and it will be just as
loading it again.
================================

The approach I'm using is, The combo's don't have any RowSource defined, on
the Got Focus event of each combo I assigned the RowSource for this specific
combo.
In that way the form open quickly, and only the nesecery combo's got
RowSource assigned to them.

Me.[ComboName].RowSource = "Select Field1 From TableName"

Signature

Good Luck
BS"D

> Hi,
>
[quoted text clipped - 8 lines]
> Thanks
> GL
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.