asked on Error 2110 on an example of search as you type
Check this database out:
https://filedb.experts-exchange.com/incoming/ee-stuff/6916-Access--EEQ23210048--filterSear.zip
It was shown to me in a previous post. It is an example of searching a list as you type. However it has a funny problem when you first type an "I" or "i". Try starting the form and before doing anything type an i. It will throw that error. At least it did for me... Any other character no problems???
I was planning on using it as an example to add in to my crm database.
Any thoughts on this one?
https://filedb.experts-exchange.com/incoming/ee-stuff/6916-Access--EEQ23210048--filterSear.zip
It was shown to me in a previous post. It is an example of searching a list as you type. However it has a funny problem when you first type an "I" or "i". Try starting the form and before doing anything type an i. It will throw that error. At least it did for me... Any other character no problems???
I was planning on using it as an example to add in to my crm database.
Any thoughts on this one?
Microsoft Access
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
ASKER
I actually didn't upload it, I think it was boag2000. The query should be in the access file that you downloaded from the link. I just checked it and worked for me.
Also ... I don't get the error for those letters. Seems odd that you would get A 2110 Focus error ... since the list box is never disabled.
mx
mx
qrySearchNames is not in the mdb I down loaded. However it appears that name was changed to qryDisplayNames. I did a Compact & Repair on the MDB which fixed that.
mx
mx
Try doing a Compact & Repair. I do not get the error ... and the error doesn't make sense.
mx
mx
qrySearchNames is not in the mdb I down loaded. However it appears that name was changed to qryDisplayNames. I did a Compact & Repair on the MDB which fixed that.
mx
mx
ASKER
I think it is something strange with my wireless keyboard. I will probably just close this question in awhile. The i key was letting me move from shortcuts on my desktop like an arrow key would... only diagonal. Really strange and makes me upset cause the keyboard is new..
ok the ... I will stop spending time on the Q
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Maybe the i was corrected because an i alone should be capitalized??
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
qrySearchNames
mx