How to find and edit field text in VBA without using SQL?

Andrew · Mar 31, 2008

Hi,

I need to find and edit a field in VBA, without using SQL.
The reason for this is because the field contains the apostrophe " ' ",
which messess SQL up. Therefore, I need to edit through the table directly.

Any help is appreciated.

Cheers

Allen Browne · Mar 31, 2008

Andrew, it might be better to learn about how to handle embedded quote
marks.

See:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

It is possible to OpenRecordset on a table.
Here's a basic coding example:
http://allenbrowne.com/func-DAO.html#DAORecordsetExample

Andrew · Apr 1, 2008

Thanks. I managed to solve the problem.

Allen Browne said:
Andrew, it might be better to learn about how to handle embedded quote
marks.

See:
Quotation marks within quotes
at:
http://allenbrowne.com/casu-17.html

It is possible to OpenRecordset on a table.
Here's a basic coding example:
http://allenbrowne.com/func-DAO.html#DAORecordsetExample