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:
Creating a box and whisker plot in Excel 2007.pdf
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").
However, when the user logged on and opened the
I have adapted the SIMSPERM batch file so that it can be applied as a Startup Script via Group Policy.
@echo off
if not exist "%ProgramFiles%\SIMS" goto end
if exist "%ProgramFiles%\SIMS\doneperm.txt" goto end
path \\[color="red"]server[/color]\netlogon
SubInAcl /FILE %WINDIR%\SIMS.INI /GRANT=[color="red"]domain\group[/color]=F
SubInAcl /SUBDIRECTORIES "%ProgramFiles%\SIMS\*.*" /GRANT=[color="red"]domain\group[/color]=F
SubInAcl /KEYREG HKEY_LOCAL_MACHINE\SOFTWARE\Classes /GRANT=[color=
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"...
[color="#teal"]IWebBrowser2 [/color]browser = ([color="teal"]IWebBrowser2[/col
Posting this code so that I can remember it/ and in case anyone else finds it useful.
First open the database
[color="blue"]string [/color]constr = [color="#8b0000"]@"Provider=Microsoft.Jet.OLEDB.4.0;Data source=database.mdb"[/color];
[color="teal"]OleDbConnection [/color]con = [color="blue"]new [/color][color="teal"]OleDbConnection[/color](constr);
con.Open();
con.GetSchema() will return a list of collections in the database.
CollectionName NumberOfRestrictions NumberOfIdentif
