Solved

Disable combobox until it is populated- Access 2000

Posted on 2007-03-28
9
213 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
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.

 
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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

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

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

732 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