Issue Tracking Database

[Gibbo_5150]

Hi team.

I've had a bit of a search around the forums and haven't found this anywhere.

Does anyone have a sample issue tracking database for an IT department?

I don't have too much Access experience so am looking for a little bit of a headstart on this. It seems relatively basic though.

The fields I think I will be needing are the following:

Log No
Status
Priority
Type
Project
Raised by Person
Raised by Department
Description of Issue

Status
1 Active
2 On-Going
3 Hold
4 Finished
5 Cancelled

Priority
1 High
2 Medium
3 Low

Type
1 Bug
2 Enhancement
3 Other

Project
1 Lotus Notes
2 File Maker
3 Tumbleweed
4 Windows
5 Microsoft Word
6 Microsoft Excel
7 Microsoft Outlook
8 Adobe Acrobat


Raised by Department
1 Research & Development
2 Customer Service
3 Finance
4 Data Solutions
5 Communication Services
6 Production
7 Stores
8 Operations
9 Other

 

[motleyjew]

I made this real quick mostly with the wizards. See if this can start you off.

 

[boblarson]

Hey motleyjew -

Just a couple of quick hints for you (just in case you didn't know) - you don't need the AutoExec macro. You can set the form to open in Tools > Startup and then if you want it to go to a new record on opening, you could just set the form to Data Entry.

Also, you should get away from using

   DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

and go to

   DoCmd.RunCommand acCmdSaveRecord

instead

But, other than those few things that is a good, quick sample.

 

[motleyjew]

Great tips Bob. I never thought about setting the form to data entry. The save button code is actually the code the wizard builds into it. I'm still a beginner with VBA, so I think I would have probably used your example if I coded it myself due to it being shorter. Thanks again for the pointers.

 

[Gibbo_5150]

Thanks Motley.

I will give it a go...