problems with saving text that includes quotation marks

[PNGBill]

Hi Forum, access 2000

I thought I was being smart with saving communications and if they can be used in an email, then to do so and then save a new communication string.

Bit confusing to explain but quite simple except that Access doesn't like us to use " in our text as I guess it gets confused with code.

Resolved this with Chr(34) but now, we are onto the next level of the issue....

When we do a followup on a followup we have multi level "" marks and this really gets the saving of the new message text upset.

The email goes off alright with the text but when it is time to append a new record to the communication table it gives up.

Is there a procedure/system that I should follow that better handles storing communication records and following up on same.

The tblCommunication field is Memo.

 

[SpentGeezer]

Yo Bill,

Rather than using SQL and append, you could use VBA. E.g.

Private Sub btn_append_Click()


Dim RdSet
Set RdSet = CurrentDb.OpenRecordset("tblCommunication")

RdSet.AddNew
RdSet!communication = theCommunicationString
'insert all other field props here
RdSet.Update

End Sub

 

[PNGBill]

Thanks SpentGeezer, will try rst and see if that allows the data to be saved.