Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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"...
  8. I

    Creating Multiple Appointments from one form

    I have been putting together code from bits I have found online that will create an appointment in Outlook from a date field in my form. My form has a number of dates and I need to create appointments for each one. Is there any way I can incorporate that into the existing code? Or will I...
Top Bottom