Solved

Disable combobox until it is populated- Access 2000

Posted on 2007-03-28
9
211 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 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

809 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