Recent content by Integrate

  1. I

    Adding working days to a date, not calculating correctly every time

    Perfect. Thank you! :)
  2. I

    Adding working days to a date, not calculating correctly every time

    Thanks for this, I have tried this code but it is now not picking up any of the holidays. I tried different formats in the DCount but to no avail
  3. I

    Adding working days to a date, not calculating correctly every time

    Yes, the date is in the table as this: ID HolidayDate 19 2020-06-01 00:00:00.000
  4. I

    Adding working days to a date, not calculating correctly every time

    I picked up the functions below for adding working days (excluding holidays) to a date based on a lag. This has been working perfectly until now. I have stepped through the code and the dates look to be formatting in the same way and everything else looks to be doing what it should (however I...
  5. I

    Refresh reports on "Dashboard" form

    Perfect, thank you very much :)
  6. I

    Refresh reports on "Dashboard" form

    I have set up a type of dashboard by adding reports to a form that stays open. Links from the form are used to navigate to other forms/reports in the database. The user exits these subsequent forms/reports and returns to the dashboard. I am trying to get the reports on the dashboard to...
  7. I

    Access, WaitShell not finishing before rest of code runs

    Thanks a lot for the replies. I have used JHB's suggestion which seems to be working great. I thought I had searched everywhere but seems my google missed the obvious. Really appreciate your time :)
  8. I

    Access, WaitShell not finishing before rest of code runs

    I am clearly missing something in my code but it seems to one of the many options I have tried that vaguely works. My client added a Shell function to open an excel file that updates from some other software. But the file was taking too long to finish even with a pause and wasn't updating the...
  9. I

    Make Table SQL with Percentile parameter

    Yay! Got it working using your solution and holding my tongue the right way... Thank you so much for you help and patience
  10. I

    Make Table SQL with Percentile parameter

    I can't get anything to come up adding the debug (having a brain fart about where to put it) But when I hold the mouse over RstName it shows RstName = ""
  11. I

    Make Table SQL with Percentile parameter

    Thank you so much for your time and help. I am sharing your feelings on syntax. I have tried both of your suggestions and received errors on both. The first was another runtime 3078 error saying it cannot find the input table or query ". When I click debug it takes me to a line in the...
  12. I

    Make Table SQL with Percentile parameter

    I get a Compile Error: Expected: end of statement I have attached a screen print. Cheers Mel
  13. I

    Make Table SQL with Percentile parameter

    Hi, I am struggling with what may be a simple issue. I am using a function to calculate the quartiles from an existing query and enter the corresponding EqNum and EDescription into a table. When I run the code below it asks me for a value for SysAssetCritRankQ from the rstPercentileRST...
  14. I

    Loop to add appointments from datasheet form

    Hi, I have a datasheet form that the client uses to enter multiple appointments into that will then be added to outlook calendar. I have been looking for a way to add this into my code but am not sure how to do it. I found the option of using .movenext but it seems it needs to be used with...
  15. I

    Type Mismatch on Check Box Control

    thanks for your help Mihail. I will repost as a new thread and see how I get on. Really appreciate your input :)
See more
Top Bottom