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.
Thursday, 10 December 2009
Miva Merchant 5.5 add to basket display confirmation
Added to:
1) Pages > Category Display > Category Display List Layout (for adding when viewing all items in category)
2) Pages > Product Display > Product Display Layout (when viewing individual product page)
(add < > before and end of mvt lines):
mvt:if expr="(g.action EQ 'ADPR') AND (l.settings:product:quantity GT 0)"
This item was just added to your basket
Please click the Basket or Checkout links at the top right when ready
/mvt:if
This will display on the same page after clicking 'add to basket'
1) Pages > Category Display > Category Display List Layout (for adding when viewing all items in category)
2) Pages > Product Display > Product Display Layout (when viewing individual product page)
(add < > before and end of mvt lines):
mvt:if expr="(g.action EQ 'ADPR') AND (l.settings:product:quantity GT 0)"
This item was just added to your basket
Please click the Basket or Checkout links at the top right when ready
/mvt:if
This will display on the same page after clicking 'add to basket'
Monday, 23 November 2009
Dreamweaver Crashing Randomly Fix
Dreamweaver CS3 crashing has been getting worse over recent weeks. I remember fixing this before and thanks to a reminder from: http://www.netevolution.co.uk/blog/?p=49 it is now fixed again.
The problem is due to a corrupted cache. Delete the following and all is well again:
The corrupted file is called WinFileCache-[random_numbers].dat.
On Windows XP, it’s located at
C: Documents and Settings Application Data Adobe Dreamweaver 9 Configuration.
On Vista, it is found at
C: Users AppData Roaming Adobe Dreamweaver 9 Configuration.
The problem is due to a corrupted cache. Delete the following and all is well again:
The corrupted file is called WinFileCache-[random_numbers].dat.
On Windows XP, it’s located at
C: Documents and Settings
On Vista, it is found at
C: Users
Subscribe to:
Posts (Atom)