How to look for double quote character in the InStr() function

Posted on 2011-04-26
Last Modified: 2012-08-14
These don't work in Access 2007.

Marker = InStr(StartPoint, !PIPnotes, """)
Marker = InStr(StartPoint, !PIPnotes, "chr(34)")

What does?
Question by:David_W_R
    LVL 85

    Accepted Solution


        Marker = InStr(StartPoint, !PIPnotes, "chr(34)")


        Marker = InStr(StartPoint, !PIPnotes, Chr(34))


    Author Closing Comment

    I'd like to think I would have thought of that eventually, but you saved me however long that would have taken.
    I'm back in  business after a lunchtime nap.
    Thanks again.
    LVL 85

    Expert Comment

    by:Mike Tomlinson
    Naps make everything better!  =)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Suggested Solutions

    This article shows how to make a Windows 7 gadget that extends its U/I with a flyout panel -- a window that pops out next to the gadget.  The example gadget shows several additional techniques:  How to automatically resize a gadget or flyout panel t…
    This article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now