Search results

Modified Code Here is what I am trying to do now. Is this anywhere closer to what I was. Or am I just running in circles. I made my old code comments so If it was correct I can still use it. I am getting an error code of incorrect query syntac (#3450) Function BuildSQLString(strSQL As...

There will only be one user. But there are approximately 1500 business license owners in the database. Thank you for your response. Can you explain the flag more or send me to a site that has an example. Thank you, Liberti

Thank you in advance. I have been searching the forum with no answers. Here is the situation. I am running a query based on 4 different criteria on my form entered by the user (Company Name, Business Title, First Name and/or Last Name). The user can choose any of the four criteria to run...

It worked, thank you for the wonderful help. Thank you, Liberti

I have created a form that when a user enters a keyword a list of ordinances is listed in the listbox. On the bottom of the form is a textbox. I would like that when a user double clicks an ordinance in the listbox (lstordinance) it is displayed in the textbox (txtordinfo). Because when the...

I need to print the contents of the listbox. I have created a report that works on its own when it prompts you for the parameter. When I am in the form when you click the print button it still asks for the parameter that is already entered in the textbox. How can I just print the list in the...

OK I am really starting to hate this database stuff. When I try to compile the language the VB program will not recognize ".recordset" as a command. WHY????? Liberti

I already have "Microsoft DAO 3.6 object library" checked Is that the one?

The closest thing was "Microsoft Jet & REplication objects 2.1 library" Is this the one that needs to be checked. Thanks, Liberti

I do not understand why I am getting an object required error when I click my command buttons. Is that related to the record set? Thank you

I am getting the error "object required" when I click the search button. However when i change from design view to form view the keyword that was in the textbox is searched and the correct items are displayed. Here is sample of my code. Any suggestions would be helpful. Liberti Private Sub...

Here is some of my code.Private Sub cmdSearch_Click() On Error GoTo Err_cmdSearch_Click Const AposAst As String = "'*", AstApos As String = "*'" Dim Target As String Forms!frmordinanceinfo!Txtkeyword.SetFocus If Txtkeyword.Text <> "" Then 'Do Nothing Else Txtkeyword.Text =...

OK now the set focus is OK. but now it is saying object required. Do I have to define my database and field names? THank you so much for your help Liberti

Thank you very much. Now when I go from design view to form view the keyword is searched. However when I click the Search button an error message occurs. "You can't reference a property or method for a control unless the control has the focus." How do I set the focus, and where in the code do...

How can I base a query on a keyword input by the user. I have code in the criteria field however it is unsuccessful. Here it is Like [frmOrdinanceInfo] & "'*" & [txtKeyword] & "'*" Is this proper?

I am doing my first Internship and I have built a database of city ordinances. I have created a form that allows my users to enter a keyword to search by. I have this connected to a query but upon opening the form the keyword is asked, I would like the user to be in the form when they enter...