Search results

  1. N

    How to search entire table through form

    Hi there I have a form with two unbound text boxes: HireMovieID and HireCustomerID, and a button HireButton which runs my query: HireHistoryQuery. Then I have a table: HireHistory. In my HireHistory table, I have my CustomerID's along the top as column names. Then the records for those columns...
  2. N

    Use form to edit records in 2 seperate tables

    Hey guys! I've got a problem which I can't seem to figure out the code for. I have the logical process, but I just don't know how to put it into code. I have a form with two boxes HireMovieID and HireCustomerID, with a button HireButton. The two tables which I have are CustomerInfo and...
  3. N

    Form filter Between in two instances, to still work without values?

    :banghead: ^That's exactly how I feel right now. The thing I've been trying to do is make it so that my form filters my records, and I'm trying to make a between function for it. My form is shown below in the attachment. What I need to do is make it so that my form filters my records Between...
  4. N

    Filter records between two numbers IF a number is present

    Hi, I have two text boxes and I'm wondering how I can filter my records of my table (through my query), between two numbers on my form. So for example lets call the two text boxes Num1 and Num2, the logical process is: IF Num1 or Num2 IS empty THEN filter records with "*" ELSE IF Num1 and Num2...
  5. N

    Form search BETWEEN

    Hi there, I'm relatively new to Access and I have a problem which I can't seem to figure out! I have created a form for a table which contains ~600 movies and their name, genre, rating, director, year it was made, and length (min). Here's what my form looks like: imgur .com/Mwu7qV4 I need to...
Back
Top Bottom