Use the Folder HelpDesk buttons to delete a ticket both from Outlook and from the database.
From the ticket list in the Folder HelpDeskfolder you can delete a ticket from Outlook and from the database by using the
Delete button in the Folder HelpDesktoolbar in the Outlook ribbon.
From inside the ticket you can delete it from Outlook and from the database with the X button in the Toolbar strip.
If you have deleted tickets only in Outlook, and wish to delete them from the database later, you have two alternatives:
Access:
Delete from tblTickets where strTicketID=”[TicketID]”
Delete from tblTicketMsgs where intTicketID= [TicketID]
Delete from tblWork where intTicketID= [TicketID]
SQL:
Delete from tblTickets where strTicketID='[TicketID]’
Delete from tblTicketMsgs where intTicketID= [TicketID]
Delete from tblWork where intTicketID= [TicketID]
Replace “[TicketID] with the ID of the ticket you want to delete.
Note that tickets that are deleted from the database cannot be seen in the Excel reports.