Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. poppadoc75

    wildcard search: error in null values

    I have a form that uses a wildcard search, the results of the search are places in a subform. But when Input a word into the search that isn't in the table, the search comes up blank. Heres the code Private Sub refresh_Click() Dim x As String If IsNull(Me.find) Then MsgBox "Please enter...
  2. poppadoc75

    wildcard search using visual basic

    I got the search to work now, but now when I input a value that isn't in the table, the screen goes blank. Here's the code as it is now. Private Sub SEARCH_Click() Dim findLibSQL As String If IsNull(Me.SEARCH_DES) Then MsgBox "Please enter search criteria.", , "Natural Catalog"...
  3. poppadoc75

    wildcard search using visual basic

    I tried findLibSQL = findLibSQL + "'*" + Me.SEARCH_DES + "*'", then I got a Syntax error in FROM Clause.
  4. poppadoc75

    wildcard search using visual basic

    In Access, I have a form that uses a wildcard search but i can't seem to make it work. Heres the code Private Sub SEARCH_Click() Dim findLibSQL As String If IsNull(Me.SEARCH_DES) Then MsgBox "Please enter search criteria.", , "Natural Catalog" Me.SEARCH_DES.SetFocus Exit Sub End If findLibSQL...
  5. poppadoc75

    microsoft access: sub forms

    I have a form with a subform in it. And I try to put a command button in it, but when I put the form in form view, all that shows up is the query in the subform. How do I get the command button in the subform?
  6. poppadoc75

    Microsoft Access: transfer data from a form to a report

    I have a form with a combo box with names of library's in it and a preview report button. I created a report to show all the library's with it's data. When I click the preview report button it shows all the data. And a message pops up "The expression On Click you entered as the event property...
  7. poppadoc75

    Microsoft Access Queries

    I am having trouble with a form that I'm doing. I just started using Microsoft Access, so I don't know that much. So in my database I have a table with the fields: Library, Program Names, and Description. In the form you input a word or phase and it searches all the rows in Description, then...
  8. poppadoc75

    microsoft access search macro

    Also when the screen goes blank, it is not an error. It just means there is no matches and the fields are blank. Im thinking I need "if description is null the message "there are no message" will come up", but i have no clue in how I should do this
  9. poppadoc75

    microsoft access search macro

    Here is the the code to find the description in my form Private Sub SEARCH_Click() Private Sub cmdSearch_Click() DoCmd.FindRecord , , acNext Exit_SEARCH_Click: Exit Sub Err_SEARCH_Click: MsgBox Err.Description Resume Exit_SEARCH_Click End Sub
  10. poppadoc75

    microsoft access search macro

    In access i have the macro "requery", that searches for a program name using the description for that program name. The problem is that when you type in a word that cant be found in the description, the form goes blank. How can fix it so that a message comes up and says "there are no matches"?

Part and Inventory Search

Back
Top