Tab Content
No Recent Activity
About benrwb

Basic Information


Please login or register to view this members information

Statistics


Total Posts
Total Posts
1
Posts Per Day
0.00
Total Thanks
Total Thanks
0
  • Thanked 0 Times in 0 Posts
Wiki
Total Edits
0
Pages Created
0
General Information
Last Activity
9th January 2014 12:54 PM
Join Date
3rd March 2011
Referrals
0
View benrwb's Blog

Recent Entries

Creating a box and whisker plot in Excel 2007

by benrwb on 31st January 2013 at 12:05 PM
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:
Categories
Uncategorized

SIMS.net - read-only access to staff Contract details

by benrwb on 22nd January 2013 at 12:34 PM
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").

Read More

Categories
Uncategorized

SIMSPERM!

by benrwb on 23rd May 2011 at 09:35 AM
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=F
SubInAcl /KEYREG HKEY_LOCAL_MACHINE\SOFTWARE\Classes

Read More

Categories
Uncategorized

Winforms WebBrowser control

by benrwb on 11th April 2011 at 01:06 PM
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 = (IWebBrowser2

Read More

Categories
Uncategorized

Getting a list of tables in an Access database (C#)

by benrwb on 4th March 2011 at 11:13 AM
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
--------------------- -------------------- -----------------------

Read More

Categories
Uncategorized

25th May 2011


23rd May 2011

  • 09:35 AM - benrwb mentioned echo in post SIMSPERM!
    ...cript via Group Policy. echo off if not exist "%ProgramF...