Search results

  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.
  14. M

    Solved Run Time Error while attaching the PDF to the Email

    Hi Team, I use the below code to attach the Access Report in the email. It was working fine earlier, but now I'm getting Run Time Error "cannot find this file verify the path" I'm facing the issue when the attachment is added (Attachments.add filename). Private Sub Send_Mail_Click() Dim...
  15. M

    Solved Sum of Specific field based on multiple conditions from a Table data

    @Gasman, That was just mentioned for an example. :)
  16. M

    Solved Sum of Specific field based on multiple conditions from a Table data

    Thank you @plog, I did try and it worked well. And I'll try replacing the reserved words. :)
  17. M

    Solved Sum of Specific field based on multiple conditions from a Table data

    Hi Team, I have been trying to solve this. I have 2 Tables Table 1: Master Database Date Function Savings Status of Project 01/01/2019 ABC 1000 Completed 01/01/2019 BCD 900 On-Going 01/01/2020 ABCD 1500 Completed 01/01/2021 BCGA 1500 Completed 01/01/2021 HCFD 1000 Completed Table...
  18. M

    Solved Unable to Stop the bounded form from adding unwanted records

    Hi @Pat Hartman, you are absolutely right. But here my concern is to stop the record saving into a table if it is not clicked on the save button. As it is bounded form, as soon as the data is entered by the user, it was saved into the table. So this code helps me avoid entering the data into the...
Top Bottom