Solved

Disable combobox until it is populated- Access 2000

Posted on 2007-03-28
9
214 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
[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
  • 3
  • 3
  • 2
  • +1
9 Comments
 
LVL 143

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

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

705 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