Access problem - can anyone help please

[LisaContractorUmbrella]

Before I can someone please explain what I have done wrong here:

Private Sub Command28_Click()

Me.Filter = "Skills Like '*" & Me.Text26 & "*" '"
Me.FilterOn = True
Me.Requery

End Sub

Is coming up with a syntax error but can figure it out - obviously have a ' or a " in the wrong place somewhere

[TheFaQQer]

Before I can someone please explain what I have done wrong here:

Private Sub Command28_Click()

Me.Filter = "Skills Like '*" & Me.Text26 & "*" '"
Me.FilterOn = True
Me.Requery

End Sub

Is coming up with a syntax error but can figure it out - obviously have a ' or a " in the wrong place somewhere

You've got a single quote before the first * and a double quote after it?

Me.Filter = "Skills Like '*' & Me.Text26 & '*' " 

maybe?? Just a guess, I honestly don't know, but that would seem to tally the ' and " together.

[hyperD]

Not used Access for over a decade (use SQL Server), but quick guess: you need to swap * with % ? Oh and last bit:

& " % ' "

[stek]

Access problem - can anyone help please

Can you not get a man to do it?

(Ducks for cover...)

[LisaContractorUmbrella]

Can you not get a man to do it?

(Ducks for cover...)

Way you go then - what's the answer huh? huh?

[stek]

Access problem - can anyone help please

Way you go then - what's the answer huh? huh?

I'm a girl too, I don't know much about Access, but I do know I love Kittens!!

[LisaContractorUmbrella]

You've got a single quote before the first * and a double quote after it?

Me.Filter = "Skills Like '*' & Me.Text26 & '*' " 

maybe?? Just a guess, I honestly don't know, but that would seem to tally the ' and " together.

Faqqer you are completely wonderful - thanks a lot

[LisaContractorUmbrella]

I'm a girl too, I don't know much about Access, but I do know I love Kittens!!

Oops sorry

[Zippy]

I'm a girl too, I don't know much about Access, but I do know I love Kittens!!

Put the kettle on love

Lisa - I like kittens too and not sure but you might also get a problem if you've got ' or " in Me.Text26.

[stek]

Oops sorry

Don't worry, I am a boy (PM me for proof, I have pictures of parts of me that I don't show on here ) but what you should be doing is using Stored Procedures in Oracle RAC in a RISC virtual environment, right lads?

Access is for lasses, poufs and NLUK.