Search results

heres what i done I created a blank form with a text box and 2 buttons ok and cancel here is the code the ok button Private Sub Command2_Click() If Text0 = "Password" Then DoCmd.RunMacro "Macro1" Else: MsgBox ("Please Renter Correct Password"), vbOKOnly, "Error!", 0, 0 Exit Sub End If End Sub...

Fine But.... Is there some way to edit the layout of the password form??

It says missing syntax from "Table_Books.Book Title" do i need to rename the "Book Title" Field Book_Title??

Thanks It looks like it will do but i dont understand the VBA part of it have no idea how to convert it to my database

Huh? doesnt work on my computer, do you need any add-ins for it to work??

what do you mean like [Forms]![Search Form]![Search_Book] in the critiea??

I am creating a catalogue for 300+ books lying around my house. On a form there are 2 text boxes called Search_Author and Search_Book and a combo box called Search_Genre When The Fields are all empty the query brings back the entire database but whenever any field is not blank the query brings...