Recent content by kmhoyt14

  1. K

    Option to leave field blank in form

    Below is the SQL of what I had before using the is null. This worked when I tested it on 3 criteria but then I extended it to all 6 criteria the search results would show nothing. Any and all help is appreciated. SELECT [FM Data].Zone, [FM Data].Mixer, [FM Data].Line, [FM Data].Equipment, [FM...
  2. K

    Option to leave field blank in form

    I want the query to return results that are selected from the form and if there are blank criteria then I want it to not use the criteria in that box. I was getting an error when I tried the Where function when I extended it to more than 1 criteria. When I had the Where (fld1 =...
  3. K

    Option to leave field blank in form

    It's been a few years (longer than I care to admit) since I've done VBA or access and I'm trying to relearn what little I knew so bare with me. I have a query that is based on unbound boxes in a form. I want the user to have the option to leave some of those boxes blank and the query just use...
  4. K

    Opening attachments in a report

    Never mind I figured out what I did wrong.
  5. K

    Opening attachments in a report

    I have a report that has a column for attachments. When I run the report I know that there should be attached jpegs and pdfs on some of the data but it's not populating on the report. I'm not sure where I even need to start on troubleshooting this and I thought that I could open attachments from...
  6. K

    Help needed on Search Query.

    So just to make sure that I understand. When the user fills out the form and pushes a search button to run the query, the results from the query should then be filtered into a report. If this is correct then for each search will the user need to close the report and query before starting a new...
  7. K

    Help needed on Search Query.

    I'm trying to create a query that's based on unbound text and combo boxes (6 boxes total) on a form. On this form I also want the option for a box to be left blank and the query only use the boxes that are filled in. I thought I had the correct criteria for the query but what I didn't notice...
Top Bottom