Handling Apostrophes

History:

Took over development of Access project after half of app was
developed. Continued the second half using same coding style as first
developer, but improved upon code and flow, etc. Almost all of the
insertions and deletions were done as DoCMD.RunSQL strSQL.

Our current problem:

All of our prototyping for the business tool was done in with
insertions and deletions, as above, without regard to the problem
introduced by apostrophes.

Rather than rewrite code, I considered using a replace function to
intelligently replace apostrophes with accent marks (underneath tilde).
There are more complex ways of handling this problem, but most require
extensive reworking of existing code.

Any ideas?

.

Relevant Pages

  • Re: Handling Apostrophes
    ... Continued the second half using same coding style as first ... insertions and deletions were done as DoCMD.RunSQL strSQL. ... intelligently replace apostrophes with accent marks. ...
    (comp.databases.ms-access)
  • Re: a union is always a join!
    ... that I'm not allowing arbitrary deletions and insertions. ... serve to identify something else at a different time. ... forgets his badge, he is issued one of five temporary badges, so more than ...
    (comp.databases.theory)
  • Re: change of random state when pyc created??
    ... Keys and values are listed in an arbitrary order which is non-random, ... history of insertions and deletions from run to run. ...
    (comp.lang.python)
  • Re: How hash tables work
    ... Hash tables have some properties that are quite useful but also some ... Insertions and deletions are quite fast. ... Trees can have very fast lookup times and low insertion and deletion times. ...
    (alt.comp.lang.borland-delphi)
  • Re: Cant see tracked changes
    ... assuming you are in Final Showing Markup view. ... you should see insertions underlined and deletions struck ... Word MVP FAQ site: http://word.mvps.org ...
    (microsoft.public.word.docmanagement)