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

[Andrew]

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]

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]

Thanks. I managed to solve the problem.

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