Which video are you talking about?

I'm asking the same question.   It would be nice to know because a project I'm working on needs something like that.

Help Desk Kevin

Help Desk

Hi Kevin did you manage to come up with a Solution? I tried changing the two variable names  rst1, rst2 and it worked , but have gone back into running the Invoicing and have once again got the same Runtime 91 Error - Object Variable or With Block Variable not Set. So I changed the variables back to the original as per the code in the Help Desk Bonus Video and still have the same issue

This error is occurring  when there are no tickets to process.
If you open TicketBillableHourQ there will be no records if none of the tickets are set to Closed (StatusID 5)

Add something like this after the variable declarations to check if there are tickets to process:

    If DCount("*", "TicketBillableHourQ") = 0 Then
        Status "No Tickets to Process"
        Exit Sub
    End If

Thanks Kevin much appreciated