473,327 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Combo Box Freezes for about 10 Seconds

Hi,

I am creating an Access database form to store invoice information in the same file. This is a single user file, but tested on a few workstations..

I am using a combo box (CboSupplier_List) to display supplier names in the database. I have set the following as its properties:

Limit to list=Yes
Auto Expand = Yes

In the form load event I have the following statement

StrSQL = "Select Supplier_Name from tbl_Suppliers"
cboSupplier_List.RowSource = SQrSQL

In the NotInList Event of the Combo I am using the following code:

Msgbox "Please select a supplier from the list"

The problem I am facing is that, due to the Auto Expand Property of the Combo being Yes, when the users are typing progressively, a correct spelling, then the combo is performing well. But when they type in a spelling not in the list, then the combo takes about 10-15 seconds to process (apparently code), and then throws out the msg. This problem is again not occuring on all the machines I have tested on; It happening only on two machines, and they have the exact same OS and service Packs, as other machines I have tested this with.

I appreciate any help that can be given. Thanks in Advance!

Gautam
Jan 24 '06 #1
0 1869

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: ddd | last post by:
Hi, I am trying to use webclient to download a file from a windows application and I notice that the application freezes while the file downloads. The file is about 300k so it takes a few...
0
by: Bryce Covert | last post by:
Hello, What we're trying to do is develop an application that installs MSDE and sets up a database for distribution of our product. I run the MSDE setup using this code: Dim installer As...
2
by: kiranmn75 | last post by:
I want to dynamically populate a combo box through javascript. Data is coming from a array. Sometimes data list may contain items in excess of 2000. Explorer takes more than 5 seconds to...
0
by: genojoe | last post by:
I am running an application that, when not used, just sits there firing a BackgroundWorker every 20 seconds. Every now and then, the BackgroundWorker freezes between the DoWork and...
0
by: Marcin Szarek | last post by:
Hi! For a few months we suffer mysterious problem with Oracle 10g RAC (more details on server configuration at the bottom). At regular basis (every 5 minutes) nodes of our cluster "freeze" -...
8
by: wpelgrum | last post by:
When I open a webpage with javascript my browser (both IE6 and FF2.0.0.3) freezes anywhere from seconds to more than a minute. During that period, the browser is frozen and windows (XP-SP2) is very...
2
by: =?Utf-8?B?Ymxpbmd0b28=?= | last post by:
hi, my mouse freezes for a couple of seconds and the computer beeps once, this is happening frequently. the beep is coming from the computer not the speakers. i have tried different mice, same...
2
by: raymonj | last post by:
Hi , VS2005 SP1 freezes (for 1-2 minute or so) about 15-20 seconds after it has started. I've cleaned up my FileMRUList and ProjectMRUList in registry. I changed my Help Settings in Options so...
0
by: =?Utf-8?B?RHJlYW1saW5lcg==?= | last post by:
Just recently my desktop PC freezes about 5 minutes after starting. The ctrl alt del keys dont work and the only way to restart it is by using the reset button or the mains switch. After doing this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.