Search results

  1. K

    Displaying entire contents of search results?

    SELECT Enrollee_Data.FirstName, Enrollee_Data.MiddleName, Enrollee_Data.LastName, Enrollee_Data.RegistrationDate, Enrollee_Data.BirthDate, Enrollee_Data.Race_Ethnicity, Enrollee_Data.Country_ofOrigin_Ethinicity, Enrollee_Data.Gender, Enrollee_Data.Street_Adrs1, Enrollee_Data.Street_Adrs2...
  2. K

    Displaying entire contents of search results?

    If so, then how would I be able to include those fields? (Some records have fields that have null values, while others have the same fields filled in, but have null values in others). If I were to show the query, do I show it in SQL format?
  3. K

    Displaying entire contents of search results?

    Nothing changed. I'm still getting no records. That's what I'm trying to aim for - a single query that could search records based on several criteria, where criteria are selectable by the form. Therefore, I thought of using the "Like" statements so that it would select all the records that...
  4. K

    Displaying entire contents of search results?

    I'm trying to make a search form that makes use of queries that search a table based on what fields I have. How would I go about having the query display all the fields for the record(s) that match the search criteria? This is for Access 2010. As far as the query is set up, I have several...
  5. K

    Parameter Prompt keeps on showing up?

    Okay, that part works. Thank you. Now I have another question about the same search form - I'm making this search form search up two forms - one of which is working now. The other I'm trying to use the search form to search up a criteria, but within the search results, display all the fields...
  6. K

    Parameter Prompt keeps on showing up?

    The query works on the search form by itself when not in a navigation form. But when I use the same search form as a subform under a navigation form, it asks me for the value of the textbox, even when I filled it in. I've checked the references - The query is the only thing that has a reference...
  7. K

    Parameter Prompt keeps on showing up?

    I'm using Access 2010, and I'm creating a navigational form with subforms. I have a search subform inside with multiple fields selectable by option buttons. I have the associated queries set up that would run the search in the background (and the forms would show the results of the queries)...
  8. K

    Hello!

    Hey, everyone. This is actually the first time I've used Access for an extended time. Prior to this, I would just muddle through bits and pieces. I hope I can learn lots from here! I don't know if there's really a term for it, but I'm a hobbyist programmer. I know a good amount of Visual...
Back
Top Bottom