Search results

  1. K

    Converting Access to Excel

    Is it possible to convert an entire access file containing vba/ sql to excel? I know I can import/ export data to excel but what I'm looking into achieving is just moving the entire access program I've built into excel format due to the company system no longer wanting to support access on every...
  2. 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...
  3. 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 =...
  4. 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...
  5. K

    Opening attachments in a report

    Never mind I figured out what I did wrong.
  6. 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...
  7. 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...
  8. 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