Search results

Hi KitaYama, I've been trying to incorporate your code into my db, but am having a problem. I'm sure it's my ignorance as I'm completely new to vba programming. In the first procedure the type is not mentioned, but I'm assuming "function". So do I add Function (???) at the top, and End...

Thanks so much KitaYama. I'll try your suggested code; seems exactly what I was looking for.

Yes, I've linked our Gmail account to Outlook, using imap and smtp server settings.

I'll try the shell(), but I'm also quite unskilled in such matters. This command would be inserted in my vba email routine, right? Can you tell me what the arguments would be for launching Outlook and then minimizing it?

No, I haven’t. I’ve only used shell:Startup and shell:AppsFolder to get Outlook to open on Windows 10 startup. But it opens in maximum view. What does Shell() do, and does it need an argument? Thanks!

Background: I manage an Access 2016 db for our local food pantry, which is staffed by (mostly senior and mostly PC-neophyte) volunteers. I mention this since my approach is to make the db interface as user-friendly as possible. Problem: I've recently added a feature that allows our volunteers...

Don't have any O'Connor in our client pool, but have an O'Riley which worked as expected (no run-time error).

Wow! It worked, it worked, it worked. You provided such an easy-to-follow and elegant solution. Really appreciated. Thanks so much for your help!

Not yet fixed -- most likely due to my inexperience. I inserted the 2 new code lines you suggested (searchstring = "" & SearchFor.Text and searchstring = "" & SearchFor.value). But I still get the same runtime error 2110, when I enter small "i". Am I also to include the code (changing to...

Please help me locate precisely where the new code should be inserted in the existing code. Does it go right before the line Me.SearchResults.SetFocus?

Yesterday, a forum member, Shanemac51, suggested a work-around by converting Ascii characters to upper case, using the code below. I tried inserting the code into the offending procedure, and it seemed to solve the small "i" problem, but I got other error messages. I suspect that I inserted...

Yes you did it correctly. What a puzzle! When I do the same thing, even on other computers (home, food pantry, wife's) I get the funny "i" behavior. A virus perhaps buried in the code, that somehow disappeared at your end???

Whatever time you have to give is appreciated. As I mentioned earlier, I'm a complete novice when it comes to modifying the code, and even some of the properties/macros. My role before I took over maintenance of the db was formatting and other simple changes. So, I'm not really sure how to do...

Attached are 2 zipped files: db structure with code and (anonymized) data tables for our local food pantry. To reiterate the issue: I'm trying to solve a problem that occurs in the Existing Client Name search box: Whenever a small "i" is typed as the leading character in the search string, its...

That would be wonderful. I'll provide a dummy set of client data. Shall I zip the files and attach to this thread, or can I email it to you?

I entered (by copy-paste) your suggested new code just after the line End If (See following). This seems to have stopped the leftward shift of the "i", but now I get these messages when I enter any and all characters into the search box. I suspect I entered the new code in the wrong place...

I've just entered all combination pairs of letters into the search box and it is only the lower case i that creates the problem. Could it be a virus problem rather than a coding issue? What is a "handler" for the characters, and how might I investigate this?

Can you suggest what and where in the code I would enter this?

To clarify: The purpose of the client search function is to allow the user to enter any string of characters that may be present anywhere in the client's name. The displayed results, which continuously shrink as more of the string is typed, will be a list of clients' full names. E.g. if "man"...

Really appreciate your help, but I'm confused how to do what you suggest: "Can you set focus to a control that already has the focus?, as you do it further up within the If block?." As I mentioned, I'm a total neophyte at coding and at 78 years old, my learning curves tend to be steep. Can you...