Search results

  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 :)
  16. I

    Update or Delete Multiple Appointments in Outlook

    I have a code that adds 11 appointments to outlook for each stage of a job. As each stage is complete the client clicks on the tick box next to the stage date and the After Update procedure deletes the appointment in outlook and replaces it with basically the same appointment but with...
  17. I

    Type Mismatch on Check Box Control

    I have tried to attached the db but the files are too big, over the 2mb I'm allowed. Is there any other way I could send them? I attached a screen print of the db for now. Originally (WBT v3) all dates are added to outlook by clicking the button at the top of the form next to the Added to...
  18. I

    Type Mismatch on Check Box Control

    Do you possibly know if it is possible to replace or delete existing appointments within this code? Jobs are added to the calendar as appointment then a check box is ticked when each stage is complete. The client wants the appointment to change from the job type to have "Complete" added to the...
  19. I

    Type Mismatch on Check Box Control

    Thanks :o so simple but I guess I'd been looking at it for too long. thanks for your help
  20. I

    Type Mismatch on Check Box Control

    I may missing the obvious but I can't seem to figure out what it is. My code works fine in updating Outlook but after it has 'finished' running and I go back to VBA there is a "Run-time error '13': Type mismatch." Highlighting the line Set comp = Me.Controls(Choose(i, "tMade", "tTopCut"...
Top Bottom