Recent content by mrk777

  1. M

    Solved Dynamic results based on wildcard dates provided with form fields

    Any help/suggestions on this, please...
  2. M

    Solved Dynamic results based on wildcard dates provided with form fields

    Yes!! with mmmm-yyyy format
  3. M

    Solved Dynamic results based on wildcard dates provided with form fields

    @arnelgp, I'm getting the same error. I have pasted the SQL query below for your reference. Note: I have 2 other combo boxes already being used with OR criteria. SELECT Master_DataBase.Function_ID, Master_DataBase.Function, Master_DataBase.Project_Lead, Master_DataBase.Project_Name...
  4. M

    Solved Crosstab Query - Columns are not Updating/Refreshing in the Reports

    If I would like to show the latest 5 Years dynamically... is there any way that I can achieve this?
  5. M

    Solved Dynamic results based on wildcard dates provided with form fields

    Hi Team, I have a form where I have ComboBox with the list of Years (2018,2019,2020,2021) and I have the proper dates in my Database as shown below: Dates 04/01/2021 03/22/2021 07/22/2020 08/16/2019 Whenever I select any year(example: 2020) in the form, the results should populate...
  6. M

    Solved Crosstab Query - Columns are not Updating/Refreshing in the Reports

    How to do that? Any suggestions/help please :)
  7. M

    Solved Crosstab Query - Columns are not Updating/Refreshing in the Reports

    Hi Team, I have created a CrossTab query and SELECT query on the same data where I have Type of Certifications in Rows and Years in Columns as shown below: Certification 2018 2019 2020 2021 2022 Certificate Type 7 1 Certificate Type 4 1 1 1 Certificate Type2 1 2 7 3 1...
  8. M

    Solved Run Time Error while attaching the PDF to the Email

    Sure, I’ll try this... thank you 😊
  9. M

    Solved Run Time Error while attaching the PDF to the Email

    As of now, it is not that necessary, if it is needed, I'll try. Thank you so much for the help. :)
  10. M

    Solved Run Time Error while attaching the PDF to the Email

    I have tried this on all my systems @Minty, it's working perfectly. But it's creating the report in that folder. Is there any way that we can attach the report, but not create the report in the specific path/folder?
  11. M

    Solved Run Time Error while attaching the PDF to the Email

    I'm not picking the file from any location/path, I'm trying to attach the report which is existing in the Current DB file.
  12. M

    Solved Run Time Error while attaching the PDF to the Email

    I have tried this as well. I end up getting the below error:
  13. M

    Solved Run Time Error while attaching the PDF to the Email

    I don't know for some reason, it is now working in my system and when I try the same in the other system I'm getting the below error.
Top Bottom