Recent content by cambonner

  1. C

    Open/Close Outlook within Access

    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...
  2. C

    Open/Close Outlook within Access

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

    Open/Close Outlook within Access

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

    Open/Close Outlook within Access

    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?
  5. C

    Open/Close Outlook within Access

    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!
  6. C

    Open/Close Outlook within Access

    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...
  7. C

    Strange Gremlin in Search Field

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

    Strange Gremlin in Search Field

    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!
  9. C

    Strange Gremlin in Search Field

    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...
  10. C

    Strange Gremlin in Search Field

    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?
  11. C

    Strange Gremlin in Search Field

    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...
  12. C

    Strange Gremlin in Search Field

    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???
  13. C

    Strange Gremlin in Search Field

    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...
  14. C

    Strange Gremlin in Search Field

    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...
  15. C

    Strange Gremlin in Search Field

    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?
Top Bottom