benrwb

Excel doesn't have a built-in Box and Whisker chart type, but it's possible to make something similar-looking using a Stock chart.

I have created a PDF detailing how to do this:

Just leaving this here in case anybody comes up against the same problem in future....

I wanted to give a member of staff read-only access to Staff Contracts in SIMS.net. (Autumn 2012 release, 7.148)

None of the built-in groups in System Manager seemed to offer the level of access I wanted, so I created my own.

I granted the group read-only access to staff details (by selecting "Staff" from the permissions list and clicking "Set View"). ...

I have adapted the SIMSPERM batch file so that it can be applied as a Startup Script via Group Policy.

Code:

@echo off

if not exist "%ProgramFiles%\SIMS" goto end

if exist "%ProgramFiles%\SIMS\doneperm.txt" goto end

path \\server\netlogon

SubInAcl /FILE %WINDIR%\SIMS.INI /GRANT=domain\group=F
SubInAcl /SUBDIRECTORIES "%ProgramFiles%\SIMS\*.*" /GRANT=domain\group

...

I've been playing around with the WinForms WebBrowser control this morning, and after lots of experimentation have finally figured out how to use some of the printing functionality.

First of all, Add a Reference to SHDocVw. (Project > Add Reference > Browse > C:\Windows\System32\shdocvw.dll)

Secondly load a document into the browser using webBrowser1.Navigate(url).

Then,
to do "Print Preview"...

Code:

IWebBrowser2 browser

...

Posting this code so that I can remember it/ and in case anyone else finds it useful.

First open the database

Code:

string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data source=database.mdb";
OleDbConnection con = new OleDbConnection(constr);
con.Open();

con.GetSchema() will return a list of collections in the database.

Code:

CollectionName        NumberOfRestrictions NumberOfIdentifierParts
--------------------- --------------------

...