Useful for converting Outlook Express DBX files to MBX (mailbox) format and import to Mac Mail.
DBXCONV.exe - had trouble finding it to download as original author's site not available. Click here to download from iTQ9 server
Friday, 16 July 2010
Excel spreadsheet do not display zeros
To hide zero values in a cell:
1. Select the cells that contain the zero (0) values that you want to hide.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Custom.
4. In the Type box, type 0;-0;;@
1. Select the cells that contain the zero (0) values that you want to hide.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Custom.
4. In the Type box, type 0;-0;;@
Thursday, 24 June 2010
Windows Vista Black Screen Startup change disk permissions
A long, long path to the fix!
After following every fix including registry edits, startup repair, boot from DVD repair, etc, etc. Removed hard drive and connected to working PC, double-click hard drive was 'access denied'. Change permissions to give 'Everyone' full control, re-installed hard drive, restart, job done!
One error reported with the recycle bin after logging in but machine and applications running correctly.
Wish I had done that 3 hours earlier!
After following every fix including registry edits, startup repair, boot from DVD repair, etc, etc. Removed hard drive and connected to working PC, double-click hard drive was 'access denied'. Change permissions to give 'Everyone' full control, re-installed hard drive, restart, job done!
One error reported with the recycle bin after logging in but machine and applications running correctly.
Wish I had done that 3 hours earlier!
Sunday, 20 June 2010
Skype Signing in Slow and Fails
Had a problem with a client's PC where Skype logging in takes a long time and then fails. Tried many things including disable firewall, anti-virus, re-install network, etc. Final fix was to delete (or rename) the following folder:
C:\Documents and Settings\%username%\Application Data\Skype
* If you don't see the Application Data folder then Tools > File Types > Display Hidden Files
%username% is the name of the logged in user. Make sure Skype is not running before you attempt this.
Restart skype, re-enter login details and works a treat!
As ever with a computer fix: time to fix = 1 minute, time to find the fix = 2 hours!
C:\Documents and Settings\%username%\Application Data\Skype
* If you don't see the Application Data folder then Tools > File Types > Display Hidden Files
%username% is the name of the logged in user. Make sure Skype is not running before you attempt this.
Restart skype, re-enter login details and works a treat!
As ever with a computer fix: time to fix = 1 minute, time to find the fix = 2 hours!
Wednesday, 16 June 2010
Excel Name Box edit
CTRL + F3 will display the Name Manager in Excel.
To create - add list on separate sheet, highlight list and type name in cell name (top left corner).
To link to a drop-down choose Data > Data Validation, in pop-up box choose =listName in the source field.
To create - add list on separate sheet, highlight list and type name in cell name (top left corner).
To link to a drop-down choose Data > Data Validation, in pop-up box choose =listName in the source field.
Subscribe to:
Posts (Atom)