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...
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...
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?
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...
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...
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"?
