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 Word 2007: Email part of the document as an attachment
What was required
Quite straightforward this one - and a useful example of how well Office 2007 and PDF are integrated.

The solution involves the following steps:-
  • The user completes an area within the document using fill-in fields and document information fields.
  • The user clicks on a "send" button.
  • Code behind the button selects all text between two plain text markers and exports this as a PDF document.
  • Code then creates an instance of Outlook and sets up a message with the PDF file as an attachment.

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