Solved

Disable combobox until it is populated- Access 2000

Posted on 2007-03-28
9
208 Views
Last Modified: 2012-06-21
I have a pop up form on which is a combo box.   Essentially, the user opens the form and selects a value out of the combo box.  Sometimes the data in the combo box is slow-to-load.  What would be a suggested way to disable the user from being able to select a value in the combo until it has populated?  If that isn't possible, how about disabling it until it has a listcount of at least 1?  Thanks.
0
Comment
Question by:snyperj
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18810757
how much items do you actually load to the combobox, and how?
such stuff should be very fast, if it is not, you have some design/coding issues.

posting the relevant code, if any, will help troubleshooting
0
 

Author Comment

by:snyperj
ID: 18810811
They are fast, except when accessed on our remote server which has problems.  Disabling the combo box until it populates is a quick fix.
0
 
LVL 75
ID: 18810829
Yes ... The first question would be:

How many records are you trying to load in the combo box?  And how ... ie ditto angel

mx
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18812757
Snyper,
You're asking us for a hack fix...and we can help with that...but don't like to.

Set the Enabled property = no

Create an on_Timer event for your pop_up. Set the Timer interval to 1000

Inside the timer event, use this

Private Sub Form_Timer()
If Me.MyComboBox.ListCount > 0 Then
Me.TimerInterval = 0
End If
End Sub



0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 34

Accepted Solution

by:
jefftwilley earned 500 total points
ID: 18812765
sorry, missed an important line


Private Sub Form_Timer()
If Me.MyComboBox.ListCount > 0 Then
Me.MyComboBox.Enabled = True
Me.TimerInterval = 0
End If
End Sub
0
 
LVL 75
ID: 18812793
Jeff ... GOOD to see you back !!!!

mx
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18812817
<OT>
Hey Joe,
I'm almost back. They took the chest tube out last night. They've been watching me today and the Doc is supposed to come see me in about an hour and release me from this hell. I'm SO ready.
I get a few days R&R at home now...which will be cool.
J
</OT>
0
 
LVL 75
ID: 18812965
<EE>
And HERE you are ... what trooper!
Lots of new, interesting and exciting threads, as you can see!

So .... how many records IS he trying to load .... still the question?
</EE>
0
 

Author Comment

by:snyperj
ID: 18815078
Thanks for the quick help (it's temporary) and best wishes for your speedy recovery.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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…

920 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

14 Experts available now in Live!

Get 1:1 Help Now