Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Automatically generating handling of issues

This is more an observation than a real question: MS-Access (and VBA in general) is desperately missing a tool where error handling code can be generated automatically, and where the line number can be displayed when an error occurs. Did you find a solution? What is it? I just realized how many hundreds of hours I spared since I found the right answer to this basic problem a few years ago, and I'd like to see what are your ideas and solutions on this very important issue.

like image 489
Philippe Grondier Avatar asked Dec 10 '08 22:12

Philippe Grondier


People also ask

How do I create an automatic issue in Jira?

Go to Project settings ( ) > Automation. Go to Create Custom Rule. Configure when this rule will be triggered by choosing an option for the WHEN action. Choose the properties of the Jira Service Desk requests that will trigger linked issues using the IF action. Under the THEN action, select Create issue.

Can Jira auto create tickets?

2 answers. Yes. JIRA supports creating issues from emails.

How do I change the auto assignee in Jira?

Admins can change the project's Default assignee by going to a project and then selecting Project settings > Details.

How do I view a Project in Jira?

You can access the project Activity page by selecting the Project drop-down, and selecting your project from the list. If your project is not listed, select View all projects to search for your project. Once you're viewing the project, click the Summary link to view the Activity page.


1 Answers

What about using "Erl", it will display the last label before the error (e.g., 10, 20, or 30)?

Private Sub mySUB()
On Error GoTo Err_mySUB
10:
    Dim stDocName As String
    Dim stLinkCriteria As String
20:
    stDocName = "MyDoc"
30:
    DoCmd.openform stDocName, acFormDS, , stLinkCriteria    
Exit_mySUB:
    Exit Sub
Err_mySUB:
    MsgBox Err.Number & ": " & Err.Description & " (" & Erl & ")"
    Resume Exit_mySUB
End Sub
like image 90
BIBD Avatar answered Oct 15 '22 05:10

BIBD