Highlight key search result

[orange]

Did you do a compact and repair on your database first? That will remove unnecessary storage in the database.
Then zip it. If it's still too large, you can post your zip file to a free storage site box.net 4sharing and I think you're using mediafire.

I have 2003 and can only read an mdb format database. Can you save a copy in that format?

Can you tell us more about the search as you type graphic in your post? Did you just mock this up or did you see a sample code somewhere?

Why is the colored text highlight so important?

I did some additional research since starting this post.

See the 2007 Access text highlight database by Allen Browne
http://www.everythingaccess.com/tuto...in-Access-2007

I don't have 2007, so you'll have to work with the download sample from Allen's site, and let uis know how you make out.

[alansidman]

Orange;
Nice find. I had not seen this site before. Lots of Access "candy" here.

Alan

[uronmapu]

I find this site before but my examply is listbox, not sub form

Could you edit in my file???

P/S: my file (HelpMe.mdb) is MS Access 2003 file

orange .......please see attached file and help my file?

Many thanks

[uronmapu]

Please hepl me

[orange]

I would like to help, but I still am unclear on
a) what you are really having difficulty with
b) what exactly you are working with - what did you write -what did you modify etc?

I can see comments about what you should include in your code, but I don't see the original.
I don't know what you wrote or what OpenGateSW wrote. I have no idea what worked or what didn't work.
, or even what you have working/had working/ need to work. It looks like code has been copied and possibly modified.

I do note that the code has line numbers , so it has been processed by someone/something.
to

The search you are using will only find text strings that are in the FirstName OR the Lastname.

Try searching for Eduardo Cano -- you can Search for Eduardo OR Cano, but not Eduardo Cano.

I don't know where your data came from, but your First and Last names seem to be reversed (at least from my perspective).

You say you have seen Allen Browne's example. What did you do with it? Did you use that to modify the code you posted in Help.mdb?

[uronmapu]

I have a HelpMe.mdb file include:
Table: tblNames
Form: frmContactDetail, frmSearchExample

(Please download file via: http://www.mediafire.com/?i7aoewle7c3cep7)


I want when to open frmSearchExample, in type to search, enter any key search (Ex: uron)

In lstItems Unbound will show key search result (First row below)
I want the texts hightlight color (yellow) - Please image illustrate



Please see the images for information detail ...

[orange]

I find this site before but my examply is listbox, not sub form

Could you edit in my file???

P/S: my file (HelpMe.mdb) is MS Access 2003 file

orange .......please see attached file and help my file?

Many thanks

Allen's example does not use a subform. He uses 2 combo boxes to select
a) the field to look in (choice of 3) and
b) the search string to look for.

And 3 text boxes to display results. Only 1 field can be searched at a time.

He also uses the AfterUpdate event of the second combo.

He then displays the non-Null found strings with appropriate html/rich text formatting. He updates the controlsource of the field to be displayed
using

 'Control Source for the text box to display matches.
        strControlSource = "=IIf(" & strField & " Is Null, Null, " & _
            "Replace(" & strField & ", """ & strSearchValue & """, """ & _
            strcTagStart & strSearchValue & strcTagEnd & """))"

where the variables are dimmed as

 'Purpose:   Filter, and highlight matches in txtSearchDisplay.
    Dim strField As String              'The field to search
    Dim strSearchValue As String        'The value to find
    Dim strControlSource As String      'ControlSource for displaying match.
    Const strcWildcard = "*"            'Some other back ends use %
    'HTML tags for highlighting matches. Could be just "<b>" and "</b>".
    Const strcTagStart = "<font color=""""red"""">"
    Const strcTagEnd = "</font>"

I haven't had time to look into your database in any detail and won't be looking at it today.

Can you work with text boxes? Why must it be ListBox? What have you been doing regarding this issue and the sample code you have?
Perhaps someone following the thread may offer advice.

[uronmapu]

Many thanks, I want to using with ListBox

Thanks all, ......

[turk]

Examine
perhaps gives an idea
Sample

[orange]

Examine
perhaps gives an idea
Sample

Is there something different at your "sample" site, than at the link in post #16?

[uronmapu]

Thanks for you answer

[turk]

Is there something different at your "sample" site, than at the link in post #16?

Sorry Sorry

[orange]

turk, I wasn't complaining really. I was just trying to see what additional info was being posted and I couldn't see any.
No need to apologize.

[uronmapu]

Can I help me?????