Apostrophes in table data

[Dennis]

In Access2002, if I want to allow apostrophies in table data, how can I code
my VBA to allow for that in the "recset.open" command? Sorry to ask such a
n00b question, but it's never come up for me before now.

Thanks for any insight in how to do this.

 

[Douglas J. Steele]

See whether my May, 2004 "Access Answers" column in Pinnacle Publication's
"Smart Access" helps. You can download the column (and sample database) for
free at http://www.accessmvp.com/djsteele/SmartAccess.html

If it doesn't answer all your questions, post back with specific questions.

 

[John W. Vinson]

In Access2002, if I want to allow apostrophies in table data, how can I code
my VBA to allow for that in the "recset.open" command? Sorry to ask such a
n00b question, but it's never come up for me before now.

Thanks for any insight in how to do this.

There's nothing particular about the Open method that would be impacted by
having apostrophes in your field data. What specific problem are you having?

The only concern would be that any query criteria need to be delimited by "
rather than by '.


John W. Vinson [MVP]