Search results for query: *

Can you see anything wrong with this code, I am getting a "2001 you cancelled the previous operation" error message. On Error GoTo errRequerySubForm Dim strActorSQL As String Dim strWHERESQL, strFullSQL As String If (Me.SearchText) <> "" Then strActorSQL = "([Fname] Like '" &...

I have a list box and a text box on a form. The form loads the list box from a table and the text box is used for searching the list box. The code for the text box search is: On the Change event property: Private Sub SearchActorTxt_Change() Dim s as string Dim i as integer s =...

How do you go about searching a list box? I know by pressing the first letter, it will go to the first occurrence. What I like to do is near the search, like in a combo box, as you type the word it near down the search for that word in the combo box.

I have a filter button when click, puts the form in filter by form mode. I have a button on the form which is not visible, but I want it to be visible in the filter by form mode. How can you do this, I tried: Me!frmEdit.cmdApplyFilter.visible = true got a an error message. Thanks in advanced

I have two tables, same structure, trying to update one of the field from table B to table A. In table A the field in question have missing data, whereas, in table B there is no missing data in that particular field. I create a update sql statement that goes like this: UPDATE client1 INNER...

I split my database, and now the Filter by form is not working. I check the query table and it display the data, but in the form when I select Filter by Form, the fields only have Is Null and Is Not Null. Where is my data? Thanks in advance

I know there are a lot communication on this topic with security. All I want is a simply login screen that works with the switchboard menu. When a user login, depending on the access, it will either enable or disable buttons on the switchboard. For example in the staff table there is admin...

Is there a way to stop the report from displaying or printing, when there is no data. I have created a dialog form, where there are two options: first option is All and the second option is specific which have a combo box for the user to select. On the report there is a nodata event option...