473,898 Members | 2,481 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access Autocomplete Fails after Compact-and-Repair or Reopening Access

7 New Member
Hello from Pennsylvania, with my first posting. I am just getting back into Access after a long layoff. Now, my Combo Boxes ‘Autocomplete’ work perfectly until “Compact and Repair” or the app is closed and reopened (then “The text you entered isn’t an item in the list” appears). Does anyone know why?
3 Weeks Ago #1
13 181
NeoPa
32,584 Recognized Expert Moderator MVP
Hi there. Welcome to Bytes.com :-)

We may need a little more info from you. Very common when new members start posting. Does the error message appear in spite of the items being in the list? Or is the actual problem that your ComboBox somehow has different data available after a C&R?
3 Weeks Ago #2
W4NMP3
7 New Member
When typing in the combo box (except immediately after creating a form and combo box) the only thing that appears is the letters entered. Hitting tab or enter gives the “The text you entered…” message. After cancelling the error message the list of names appearing starting at the top of the list, as if using the pull-down.

A new discovery: I copied two tables from my new program into a copy of an Access program I wrote a few years ago, then created a new form in it using the two tables (to replicate the problem). The combo boxes worked as designed. Next, after copying the problem form (with the combo box problem) into the older program, the combo boxes in the older program have the autocomplete problem.

Both the new and old programs show “”Access 365 Version 2406 - Build 16.0.17726.2010 8 64-bit. My PC shows: Windows 10 Home Version 22H2 - Build 10.0.19045.4529 64-bit
3 Weeks Ago #3
NeoPa
32,584 Recognized Expert Moderator MVP
Hi again.

I'm still not clear on the precise answer to my question, though I clearly see real intent to give as much info as possible, for which I commend you :-)

I'm trying to determine whether the ComboBox is behaving in a way that is undefined, such that it might be a corruption or some such, or in a way that actually fits the data available - but that data isn't what you expect.

When you see the error message can you see (as opposed to simply expecting it to be there without visual verification) an item in the list that matches what you've typed but which isn't selected when you type it?

The only other item I can think of (other than corruption or data mismatch) is the setting of the ComboBox.LimitT oList property. Not sure even if that would affect this situation.

To be honest, nothing obvious springs to mind other than corruption. Hard to diagnose at a distance, obviously, but assuming all you've told me is accurate the fact that putting the same into another database seems to cause it to work as expected leads me to discount everything else I think of.

I'm happy to look further if you wanted to send me a ZIPped copy of the two different files (Cut down as much as possible please so they only include the basics necessary to illustrate the behaviour.) in a ZIP. Feel free to attach it to a PM if you prefer.
3 Weeks Ago #4
jimatqsi
1,278 Recognized Expert Top Contributor
Well now, this is interesting. Let's get some more information.

It's especially interesting because you refer to combo boxes, plural. So I'm thinking the problem may lie outside those objects. But first, about those objects.

How many boxes are we talking about? Are there some that do not fail?
What is the row source type or types (Table/Query, Value List, or Field List)? All the same type ?
Please share the Row Source of at least one.
Do you have code that dynamically changes the Row Source or any property of the objects?
If the Row Source is a query, try saving that query as a separate object and run it outside the form. Do you get the expected result at all times?
Is the object bound to a field?

Maybe add a button to your form that opens the query, if that's what it is. Click the button before and after you try the combo box. You could use code like this:
Expand|Select|Wrap|Line Numbers
  1. Private Sub CheckComboSource()
  2. Dim qry As DAO.QueryDef
  3. Dim strSQL As String
  4. Dim dbs As DAO.Database
  5.  
  6. Set dbs = CurrentDb
  7. Set qry = dbs.QueryDefs("Temp_qry")  ' create some temporary select query for use here 
  8. strSQL = Me.comboboxname.RowSource  ' get the rowsource of the object
  9. Debug.Print strSQL                                      ' or msgbox strsql if you like
  10. qry.SQL = strSql                                           ' change the sql code of the query
  11. DoCmd.OpenQuery qry.Name                    ' whatever result you get here is what should be in the dropdown combo
  12. Set qry = Nothing
  13. Set dbs = Nothing
  14.  
  15. End Sub
Other points of interest:
Do you have any form level events that might be impacting this, such as On Mouse Down, On Key Press, etc....

You said closing the app creates the problem. I wonder if you mean the form or the database itself. If you close the form and open it again, does the problem present itself?

After reading your second post again, it gives the impression that there are two combo boxes and each uses a table for the Row Source. Is there something in the design of the tables that might be impacting this? Some relationship between the two, some unusual (to me, anyway) element in the tables?

What do you mean by " the combo boxes in the older program have the autocomplete problem."? Are you saying that the problem has spread to other forms with combo boxes?

This is a very curious one. I would also participate in examination of your database if you care to send a copy to me.

Good luck. It's a fascinating situation.
3 Weeks Ago #5
W4NMP3
7 New Member
My "older program": I dug out an Access program I wrote a few years back and opened it. The Combo Boxes worked just fine. Since the program I'm working on now is short and simple I created two of the tables (used in the "new" program) in the "old" program and combo boxes in this form WORK as designed. I will be continuing that process (rewriting the program in a cleaned up copy). Here is a link to ZIP'd (partial) copies of the functioning and non-function form

Thank you for your help

https://drive.google.com/drive/folde...usp=drive_link
3 Weeks Ago #6
W4NMP3
7 New Member
Thia link to the compressed files should work better, I hope
https://drive.google.com/drive/folde...Uw?usp=sharing
3 Weeks Ago #7
NeoPa
32,584 Recognized Expert Moderator MVP
Hi Dick.

We have Jim on board now too, which never hurts.

I'm coming up to a busy few days at this time so while I can confirm I've downloaded your databases, I probably won't get time for a serious delve just yet unfortunately. I'm reassured you have a workaround for now at least, but I hope to dig further when things normalise here.

It may be that it works in the new database because the old one has a corruption somewhere. Just a guess for now but corruptions do happen in Access databases - more frequently than we'd like.
3 Weeks Ago #8
W4NMP3
7 New Member
Yes, I have a workaround so no urgency at this point. I do not understand (but certainly accept) one Access db on my both desktop and laptop having the issue while others do not. Take your time; now it is just a point of curiosity, not keeping me from (slowly) developing the app
3 Weeks Ago #9
jimatqsi
1,278 Recognized Expert Top Contributor
I use listbox every day, or nearly so, but I don't work much with the combobox object.

I could not solve the problem in the database I received from the original poster. I created a new database and imported the forms, tables and macro from the non-working database.

Then I added this code to the GotFocus and OnChange events of the one of the comboboxes
Expand|Select|Wrap|Line Numbers
  1. Me.cbo_Find_ID_Driver.Dropdown
That change works fine in my new database. It did not help in the original database. It could be something is corrupted there. I tried running the form without going through the menu, and also without using the Autoexec macro, but nothing helped.

It remains a mystery.
2 Weeks Ago #10

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

Similar topics

5
404
by: José Joye | last post by:
Hi, Does anyone know if there is a planned support for MS Access in the MS DAAB? Thanks, José
1
7710
by: Gary Dale | last post by:
I have a database that was originally set up in Access 97 (because that was what we had in the office). We had a copy of Access 2000 set up on one machine for a brief period to get at another database that required it. Unfortunately someone used that machine and "upgraded" the Access 97 database to Access 2000. Now I'm trying to get it back to Access 97 but the "convert to prior version" function keeps telling me that it can't convert...
2
5467
by: Puneet Murgai | last post by:
I am trying to run an access query which works when I write it directly in the database. However, it fails when an SQL script containing it is run from C++. It doesn't recognize the Iff and Nz functions when run through ODBC. Query is as follows: INSERT INTO PROJECT_LINK_DEFN (LD_LINKID, LD_FROM_PROJECTNAME,LD_TO_PROJECTNAME, LD_FROM_TASKUNIQUEID, LD_TO_TASKUNIQUEID, LD_LINKTYPE, LD_MODELTYPE ) SELECT
2
1652
by: Wayne Aprato | last post by:
Will Access 2003 open Access 2002 mde files or will it only open mde files that are created with Access 2003? Thanks in advance.
7
3473
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." Interestingly I can open the mdb files of the same 2003 databases in Access 2002 without problems. To my understanding the file formats of 2002 and 2003 are the same and this problem shouldn't exist. And why is it only the mde files that are giving the...
0
1340
by: Wayne | last post by:
Can anyone cast any light on the following. I have a database that I have written in Access 2003 using 2000 file format. Everything was working OK when running it under Access 2003 but when I tried running it under Access 2000 if fell over when I tried to open some of the reports. I then tried opening it in Access 2003 again and it brought up the message about saving a copy and repairing - but it wouldn't repair. I then decompiled,...
0
1131
by: meyvn77 | last post by:
Hello, I wrote an .ADP application in Access 2002 and delivered it to the client. They are not due for an upgrade till January and are running Access 2000. They would like to use the Application. The 2002 enviorment was chosen because they will be using Access 2002 for some time after Jan. My app will not run using Access 2000. I have read that you can not use the objects in 2002 in 2000.
4
6396
by: StefanSerena | last post by:
Hi I'm running Windows 2000 and Office 2003. I want to copy tables from an unknown database format into Access 2.0 and I could do it quite easily if it weren't for the fact that recent ODBC-drivers aren't capable of writing into an Access 2.0 database (only reading). I do have the old Access 2.0 disks including odbc-driver, but it doesn't install on my machine (probably because the newer ones are installed...). And yes, I know that...
3
3864
by: Sheldon | last post by:
I have the following query expression - Like Format((!!)) & "/*/" & (! !) which would translate to e.g. 04/*/2007 if someone is running a report for last month. The above expression is part of a Where clause for a date field. It works fine in Access 2000 and pulls out the appropriate # of records but in Access 2003, this expression (apparently) evaluates differently and no records are extracted. Is this an area that might've changed...
1
5414
by: mikerudy | last post by:
I have an 3rd-party application that uses a SQL back-end, but uses Access 2000 (linked tables all using the same DSN) as an intermediary. We recently upgraded from SQL 7 to SQL 2005, which went fine. Now, however, we want to setup SQL Mirroring to provide automatic failover. The mirroring works fine. In my test environment, the mirror server becomes active automatically when the service is stopped on the principal server. I can see...
0
9993
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9842
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10859
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10487
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9662
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8036
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4297
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3308
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.