Search results

  1. J

    Searching a subform.

    Is there any way to have a query box on one form and have it "filter' persay a list of entries in a form/query in a subform below? I can't seem to get it to work or find any help on the subject.
  2. J

    Boolean searches? Possible?

    Is there any way I could do a boolean though, say I'm searching for a project name. The name is "Josh's Awesome project" and I want to be able to put "Josh*" and get that project to come up.
  3. J

    Boolean searches? Possible?

    Meaning place that as the code on my text box and leave the code the same on the button?
  4. J

    Boolean searches? Possible?

    Private Sub cmdSubmit_Click() Dim strSearch As String If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!" Me![txtSearch].SetFocus Exit Sub End If DoCmd.ShowAllRecords...
  5. J

    Boolean searches? Possible?

    I have a search tool, but right now it is 100% case sensitive in the sense that if i search for "test" and my entry is "Test" it will not return any results. is there any way to setup so I could say search for "Test" and it would find "test" properly? Or even to the extreme where I searched...
  6. J

    Deleting Subform records based on Checkbox

    Ah, figured it out. Next question!
  7. J

    Deleting Subform records based on Checkbox

    I have a form with a subform inside of it. On the subform I have created a field for a check box. I wish for the user to be able to click 1 or more check boxes in the subform and then click a delete button that removes all selected entries. I have this code from a seperate post regarding this...
  8. J

    Removing Navigation Bar from Forms

    Thanks, found it right after I posted.
  9. J

    Removing Navigation Bar from Forms

    I have a form imbedded in another and would like to remove the navigation bar from the form being imbedded so 2 do not show in the final product. Is there a way to do this and if so, how would I do it. Thanks!
  10. J

    New Records on Multiple Tables with one Form

    Hey Guys, I have 2 tables (tblSET, tblPROJECT) that have a relationship between them in the form of strPROJID (Project ID) I need to make a form that has all empty fields in it, and when filled in distributes the entered data to the corresponding field in the corresponding table. I have tried...
Back
Top Bottom