Archive for the 'Technology' Category

Solved- Microsoft Excel printing to multiple PDF instead of a single one

Excel will do this if the DPI(print) setting are not consistent.

If this is the case for you, select all sheets and go to page layout and change to make sure the DPI settings set to the same.

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Quick Microsoft Excel Tip: To find the last used cell in a column

Just use the cell’s .End(xlDown).Select

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Import data into SQL Server using VBA

Import data into SQL Server using VBA

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Solution: Dell Latitude E6400 poor Sound quality bug

Solution: Dell Latitude E6400 poor Sound quality bug

After playing with the settings found the issue- the difference is night and day.

1) Open Volume Control (double click on the volume icon in the botton right corner of your screen)
2) Click on the ‘Advanced’ button at the bottom left of the volume control.
3) Tick the box nect to ‘1 PC Mute’

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

Business Objects- Report scheduling bug

Discovered a strange Boxi bug today

Share and Enjoy:

Full list of sharing options

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

DTS: The login already has an account under different user name

SQL server error: The login already has an account under different user name

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

ADO Late binding note – avoid missing reference & compatibility issues.

ADO Late binding example

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

How to sort Wordpress plugins page by ratings

On the normal Wordpress plugins page (http://wordpress.org/extend/plugins/) , you will see the options: Most Popular, Newest and Recently Updated. But what if you want to sort by ratings?

Simple- use this this link Top Rated plugins It is undocumented but a easy hack ;-)

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

How to set up a back up routine for your wordpress database

This article will have in mind the most common admin type -ie a novice user with limited rights on the server, The best option here is to backup the tables by using

Share and Enjoy:

Full list of sharing options

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot

3 stopping 15gb mobile broadband- Get in quick

As you may have noticed, 3 are stopping the 15gb mobile broadband packages. However on their website it is still showing business deal available so get in quick!

Share and Enjoy:
  • email
  • Print
  • Digg
  • Facebook
  • Twitter
  • del.icio.us
  • Sphinn
  • Google Bookmarks
  • Blogplay
  • Add to favorites
  • Diggita
  • LinkedIn
  • Live
  • MySpace
  • Reddit
  • RSS
  • StumbleUpon
  • Technorati
  • Slashdot