Search results

Hi, Sorry to bother again same problem, i modified the form and after doing that the auto complete form does not ' work again. I type first letter works fine, then back space to type another letter to search doesn't display anything. somebody helped on this already and it was working...

Thank you very much for you kind help, worked perfectly.

Thank you very much.

Attched now. Thanks.

I attachec a zip file, because exceeded the 2 mb limits. Thank you.

Thank you. I tried when type nothing happen. Here it's the code i copied from your example: Option Compare Database Private Sub Text41_Change() Dim strTextBox As String strTextBox = Me.Text41.Text Me.Filter = "[Vendor Name] like '*" & ESQ(strTextBox) & "*'" Me.FilterOn = True Me.Text41 =...

Can anybody give me a help on this, please. Just want to be able to type first letter and go to vendor, instead scrolling all the way down or up, thanks.

if you see the picture will see check box right now have to scroll down or up and select. i want to be able start typing first letter and select then type again and select next one so on. is there any way to do it with after change code ? the code that i have righ now on click is: Private...

I have this form, how can make it when start typing auto complete name: I attached a picture of it, thanks.

I am new at VBA, how do i bracketed it? thanks

thanks. How do I turn the filter off from the toolbar? Access 2013. thanks.

I found a form in the web downloaded, but when I search for a company get an error and highlight one line: Here it's the code: Private Sub cmdSearch_Click() Dim LSQL As String Dim LSearchString As String If Len(txtSearchString) = 0 Or IsNull(txtSearchString) = True Then...

Listbox auto complete? I have tab listbox with tag button to select vendor to print file folder label, how can i make the list auto complete when start typing a letter. thanks.