rs.FindFirst question

[Shyguy]

Is there a way to use this when entries have an apostrphe in them?

Like Joe's Bar and Grill.

[Tom van Stiphout]

On Wed, 26 Oct 2005 00:02:06 -0400, Shyguy <sh****@aol.com> wrote:

Yes: double-up on them:
rs.FindFirst "LastName='O''Brien"

-Tom.

Is there a way to use this when entries have an apostrphe in them?

Like Joe's Bar and Grill.

[lylefair]

I think your answer is correct.

[Shyguy]

On Tue, 25 Oct 2005 21:21:06 -0700, Tom van Stiphout
<no*************@cox.net> wrote:

On Wed, 26 Oct 2005 00:02:06 -0400, Shyguy <sh****@aol.com> wrote:

Yes: double-up on them:
rs.FindFirst "LastName='O''Brien"

-Tom.

Is there a way to use this when entries have an apostrphe in them?

Like Joe's Bar and Grill.

Thank you for the reply.

I guess there are other ways to use "rs.FindFirst" . ;-( I am using it
behind a combo box and the full line is -

rs.FindFirst "[Organization] = '" & Me![cboOrg] & "'"

Some of the names hgave an apostrophe but some don't. The ones that
don't work fine. When one is selected that has an apostrophe I get a
runtime error 3077 and syntax error (missing operator) in expression.

[Tim Marshall]

Shyguy wrote:

I guess there are other ways to use "rs.FindFirst" . ;-( I am using it
behind a combo box and the full line is -

rs.FindFirst "[Organization] = '" & Me![cboOrg] & "'"

Don't mean to jump in on Tom, but don't use the single quotes where
you're using them now. Do this:

rs.FindFirst "[Organization] = """ & Me![cboOrg]) & """"

Or, as doubling up on double quotes can get hard to keep track of for
long strings (the chr(34) is a ":

rs.FindFirst "[Organization] = " & chr(34) & Me![cboOrg]) & chr(34)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Shyguy]

On Wed, 26 Oct 2005 14:56:41 -0230, Tim Marshall
<TI****@PurplePandaChasers.Moertherium> wrote:

Shyguy wrote:

I guess there are other ways to use "rs.FindFirst" . ;-( I am using it
behind a combo box and the full line is -

rs.FindFirst "[Organization] = '" & Me![cboOrg] & "'"

Don't mean to jump in on Tom, but don't use the single quotes where
you're using them now. Do this:

rs.FindFirst "[Organization] = """ & Me![cboOrg]) & """"

Or, as doubling up on double quotes can get hard to keep track of for
long strings (the chr(34) is a ":

rs.FindFirst "[Organization] = " & chr(34) & Me![cboOrg]) & chr(34)

Thank you very much. It worked fine, after I removed the extra )
;-)

[Trevor Best]

Shyguy wrote:

Thank you very much. It worked fine, after I removed the extra )
;-)

Until you get one with a double quote in it, say the organisation is the
over 6'5" club :-)

Try:
rs.FindFirst "[Organization] = '" & Replace(Me![cboOrg]"'","''") & "'"