Re: ADO Recordset FIND problem

• Previous message: Michael A. Covington: "Repost: System load, no. of users, etc., for non-administrators"
• In reply to: VBDave: "RE: ADO Recordset FIND problem"
• Next in thread: Bob Barrows [MVP]: "Re: ADO Recordset FIND problem"
• Messages sorted by: [ date ] [ thread ]

Date: Sat, 29 May 2004 14:16:35 -0500

Hi VBDave,

Yes, I did try that but it still produced an error. Bob's suggestion
does work.

Thanks,

Charles

On 5/29/2004 8:06 AM, VBDave wrote:
>
> ----- Charles E Finkenbiner wrote: -----
>
> Hi All,
>
> Well, 1 small bug came up to bite me in the rear. When I do a text FIND
> I enclose the text in single quotes. So, the FIND string would be:
> Description = 'John MacDonald'. Works great until I ran into trouble.
> I found that some descriptions have single quotes (could be any special
> character) in them. So, my FIND string is now: Description = 'John
> Mc'Donald'. This causes an error that I can not seem to get around. I
> tried using double quotes instead like, Description = "John Mc'Donald",
> but I still get the error message.
>
> How do you FIND text when the text contains special characters?
>
>
> Thanks for any help,
>
> Charles
>
> Hi Charles
>
> Assuming you are using VBScript, have you tried setting the recordset.find criteria equal to a variable?
> For example:
>
> strDescription = "John Mc'Donald"
> recordset.find (Description = strDescription, otherArguments)
>
> Best,
> VBDave
>

• Previous message: Michael A. Covington: "Repost: System load, no. of users, etc., for non-administrators"
• In reply to: VBDave: "RE: ADO Recordset FIND problem"
• Next in thread: Bob Barrows [MVP]: "Re: ADO Recordset FIND problem"
• Messages sorted by: [ date ] [ thread ]