HelpTrax Helpdesk Application

Posted On 2017-12-29 by VB6Boy
Keywords:
Tags: VB6 Complete Applications VB6 Miscellaneous VB6 Databases Windows
Views: 213

Download Attachment


I was going through some of my old code during a backup process, and I stumbled across this mostly complete help desk application I wrote about 13 years ago. Maybe someone can get some use out of it?

This app began life as most of my code does, to solve one of my own problems. In this case, I needed a way to track client requests, as well as have a place to store useful information. Internet connectivity was not as widespread back then, so it needed to be somewhat portable.

There are two main "modules" for HelpTrax: Case Management and Knowledgebase. Both of these are self explanatory. I'm releasing the source code here as well, so other folks might get some benefit, or maybe even learn what not to do.

There is code in the project to send email, but it is currently disabled. As I recall, there was some issue that I couldn't resolve with emailing, and I never got around to fixing it. So, if you have some insight, give it a shot.

Features

  • Client info maintenance
  • Technician maintenance
  • Basic Reporting
  • Knowledgebase
  • Case ticketing and management

Items and concepts demonstrated

  • Multiple Document Interface (MDI)
  • Custom title bars for windows
  • Database operations (read/write/search)
  • Reading/writing from a text file
  • Opening files with default apps
  • Logging and debugging
  • Working with a grid

Screenshots

click for bigger description
This is a picture of the Create a New Case screen, where you build the initial case record for an incoming call.
This is the case editor. At the top of the window, you get a list of cases, and after you select one from the list, the fields below become populated. Once you have a case selected, update it as needed. Note the use of color-coded fields in the grid for Priority.
The knowledgebase is supposed to be a place where you can store canned responses, processes, and other items that will help you resolve cases. The list of available articles is at the top of the window, and a preview is at the bottom. Clicking the link on the right side of the window will open the article in your default browser.
In the maintenance screen, you can add/change/delete both clients and technical representatives. Clients are shown at the top, while your tech reps are at the bottom. Simply select an existing person to update, or use the Add New button to add a new person.
The reporting is very basic. I wrote this stuff a long time ago, and it shows. Each of the reports simply spits out an HTML file in your default browser, summarizing the requested information.

Maybe I should start updating this software, possibly add some pretty graphs and charts?
The only setting read from disk is the location of the database. All the rest of the information is pulled from a table in the database, and can be upated on this screen.

Requirements

This uses an MS Access database for storage of information, so you'll need the appropriate ADO objects installed on your system.


About the Author

VB6Boy has posted a total of 28 articles.


Comments On This Post

By: AnonymousCoward
Date: 2017-12-29

Excelente, muchas gracias.


Do you have a thought relating to this post? You can post your comment here. If you have an unrelated question, you can use the Q&A section to ask it.

Or you can drop a note to the administrators if you're not sure where you should post.


Your IP address is:54.82.57.154

Before you can post, you need to prove you are human. If you log in, this test goes away.




Code Links