In2net Systems Ltd
Case Studies
Home
  1. MS Access 2007: Gantt Chart
Access doesn't have any facilities for conditional formatting within reports so when a client wanted something very like (well, actually, exactly like) a Gantt chart the challenge was on.

The problem was to find a way of shading in the backgrounds of textbox controls depending on their contents.

Surely it couldn't be that difficult...
See It
  1. MS Word 2007: Email part of the document as an attachment
The client required that some code be written to send part of a word document via email.

The solution selects a range within the document, exports it as a PDF file and then sends this as an attachment within Outlook.
See It
MS Access 2007: Gantt Chart
What was required
The idea is simple - record when personnel are on holiday, on sick leave or absent for any other reason and then display this information on a Gantt chart where the user can choose the period covered by the chart. 

The solution involves the following steps:-
  • Record absences in a linked table with one record per absence, storing start and end dates of each absence.
  • Accept start and finish dates for the Gantt chart from the user.
  • Programatically create a table to store data appropriate for the Gantt chart.
  • Populate the temporary table.
  • Programatically create an Access report with textbox controls for each day in the period being displayed.
  • Point the report at the temporary table and format the textboxes so that texboxes' background colours reflect their contents.
Oh, .. and get round all the quirky, illlogical, infuriating and totally daft peculiarities which are what make Access such a joy to use...

See the solution >
In2net Systems Ltd
Company No: 05465182
www.in2netsystems.co.uk