Search as you type

[Farnarkle]

Hi everyone,


I have this code in a search as you type combo box, which I copied from here:

http://blogs.office.com/2012/05/03/u...h-as-you-type/

It works fine on the above site, but I get errors on my system Access 2013 Windows 8.
THe website punctuation is different in that the apostrophes face left and all the double quotes are the same..... I Cannot duplicate them


Private Sub cboFilter_Change()


' If the combo box is cleared, clear the form filter.
If Nz(Me.cboFilter.Text) = "" Then
Me.Form.Filter = ""
Me.FilterOn = False

'If a combo box item is selected, filter for an exact match.
'Use the ListIndex property to check if the value is an item in the list.
ElseIf Me.cboFilter.ListIndex <> -1 Then
' THE FOLLOWING LINE RETURNS A SYNTAX ERROR
Me.Form.Filter = "[Company] = '" & Replace(Me.cboFilter.Text, "'", """ & "'"
Me.FilterOn = True

' If a partial value is typed, filter for a partial company name match.
Else
' AS DOES THIS ONE
Me.Form.Filter = “[Company] Like '*" & Replace(Me.cboFilter.Text, "'", """) & "*'"
Me.FilterOn = True


End If

'Move the cursor to the end of the combo box.
Me.cboFilter.SetFocus
Me.cboFilter.SelStart = Len(Me.cboFilter.Text)




End Sub


any help appreciated...

Farnarkle

[burrina]

Personally, I use the one found here. http://allenbrowne.com/appfindasutype.html

HTH

[June7]

Believe me, you don't want those slanted apostrophe and quote marks - VBA won't like them. I think that site has error. The Replace function is to replace a single apostrophe with 2 apostrophes, not a quote mark. This is so an apostrophe in the text will be read as a literal apostrophe, not as a delimiter character. So a value like: "McDonald's Farm" won't error in the search criteria.

Your code is missing a paren in the first Replace().

Me.Form.Filter = "[Company] = '" & Replace(Me.cboFilter.Text, "'", "''") & "'"

[Farnarkle]

To June7 ... thanks for that, it was a bit easy to miss on a laptop screen. I got the code to validate but the whole thing didnt work for me anyway

Burrina, thanks for the link. I can adapt that for my needs. I am coding an IMDB database ( just for something to do) using this model:
http://www.databaseanswers.org/data_models/imdb/

I have the bare framework working ok and now fleshing it out.

I needed a popup to select actors and the like from the people list and add new ones (NotIn List) to existing table and/or into a new movie, hence the post.

Farnarkle