Microsoft Office Downloads & AddIns can be found here

excel03.gif Down Right? This add-in for Excel 2003, 2007 & 2010 adds two buttons to your toolbar, one to change the enter direction from down to right and vice versa, and another to change the enter key behaviour from shift [to another cell] to static (remains on the current cell) and back again.

excel03.gif Show/Hide Formulas Adds an Excel 2007 style Show/Hide Formulas button to Excel 2003 (though it can also be used in the later versions). This is a per sheet action meaning that you will need to activate on each sheet that you need to see the formulas.

excel03.gif Count Worksheets This neat little tool provides a quick way to count the total number of worksheets in the active workbook and also displays the numbers of visible, hidden and very hidden sheets. Also offers an option to unhide all sheets if required.

excel03.gif Convert to Number How often does this happen to you? You've just imported a file but all the numbers are stored as text, the only fast method is to group select the affected cells and choose convert to number from the first selected cell. Using this tool, select 1 or many cells, groups of cells (a range), columns, rows or even the whole sheet, press the button and you are sorted. Even works across rows where cells contain actual text.

excel03.gif Fiscal Date Converts your date to that of the corresponding fiscal year - excellent for date formulas. (UK Only)

Compound Interest Caclulator Picking-up where other built-in interest calculations (nper, pv etc) left off, this calculator provides 4 different calculations: 1. Your value less your payment with the interest;  2. Amount of interest charged on your value less your payment; 3. Your value PLUS your payment, plus the interest; 4. The amount of interest earned from your payment when added to your value. Other options include the ability to change the default APR from 12 to any period that suites you. Unlike other calculators, this calculator does not require a fixed end-date typically required for loans and mortgages. PLEASE NOTE Due to the way in which compound interest is usually worked-out, there may be a discrepancy between this calculator and that of your statement, this is because this calculator is based on the WHOLE balance whereas your statement is most likely calculated applying the interest rates to each transaction then summed and payments made by you are deducted from the oldest transaction first as opposed to from the whole balance.

 Database Connections Manager. This configuarble Basic (*.bas) file contains all you need to be able to connect to SQL Server, MS Access & Oracle, and with the right drivers most other db providers (drivers not included); whats more, this tool also avoids the need to utilise the Oracle TNSNames.ora file and you don't even need the Oracle client installed on your pc.

Highly configuarble, you shall need to do some config of the servers & db functions on initial setup on your network so as to ensure that you can connect to them though once this is complete, you shall be able to configure using the setting config's at the top of the module. You may not need to configure all variables (just the ones that you need), included is the DSS (Dynamic Server Selection), using some or all of these variables in your subs (DO NOT FORGET to add an entry to the ClearDSS function at the end of your sub) enables you to bypass your default server setup, a typical application would be almost all of your data shall be coming from the main Oracle db, but some of the sales data needs to come from a Microsoft Dynamics CRM on an SQLServer db, just for the sub that is pulling in the data, use the DSS values.

Also included is a both a connection test - this returns True if a connection is made, a query test, this makes a connection and executes a simple query, and an example script allowing you to add a table name to the query (please try to limit to less than 60k rows, you don't want to be hammering the server and killing the corporate network by bringing down 10Gb data). Any problems or issues, drop me a message to steve@arcticsponge.co.uk 

access03.gif MS Access Login Form: A simple login form, username & password are "test" [without inverted commas] and the shift bypass is "test1"; all can be amended from the table tblAccess. If no password or the wrong password is entered into the Shift Bypass, the Shift Bypass is disabled on next login.

To use: From code view, change the Do.Cmd open "frmMain" to your default form from within frmAccess and either transfer your db to this one or, transfer the following to your database: