Search

Monday 28 February 2011

Ministry Of Transport (MOT) test links

 

To check for the existence of an MOT on a vehicle, you can check online via the link below:

http://www.direct.gov.uk/en/Motoring/OwningAVehicle/Mot/DG_10020539

 

Ebay Store - LotsMore-4-Less

Lots More 4 Less Ebay store.
Get great items at great prices, grab a bargain !

Sunday 27 February 2011

Skoda Fabia – Boot Strut fitment guide

(credit to : http://www.tailgatestruts.com/gas-strut-fitting-mounting)

How to Fit & Remove Tailgate Struts

Band Type Ball Sockets

Removing and installing gas struts on your car is often a quick and simple job which does not require a mechanic.
If your gas struts have a ball and socket fittings then the only tools required are flat blade screwdriver and someone to hold the boot for you.

Look at the end of the gas strut for a rectangular plastic block with a metal band running around the back.
Some struts use metal fittings but the band will be in a similar position.

  • Slide a flat head screwdriver down the groove along the back of the fitting and under the metal band.
  • Lever the band back and pull on the gas strut to remove it from the car. You do not need to remove the band to do this – just lever it back.
  • Your new gas struts will simply push fit back onto the ball studs.


Replacing car tailgate struts is a two person job.
 
Do not remove one strut and rely on the other to hold the tailgate.

 

Pin Type Ball Sockets

If your gas struts have a dome end fitting with a small metal pin -

  • Unclip the pin from around the base of the fitting and totally remove it from the fitting.
  • Once the pin is removed the gas strut can be pulled off, leaving the ball attached to the vehicle.
  • To fit your new struts remove the pin, push fit them onto the ball stud and replace the pin.


Skoda Fabia – Boot Strut

Model: Skoda Fabia Hatchback Gas Strut
Body: Hatchback
Year: 1999 - 2007
Part#: 6Y0827550A 7969MW

 

 

http://www.tailgatestruts.com/gsc2142-skoda-fabia-tailgate-strut

 

 


 

Other suppliers: SGS Engineering £13.99

Thursday 17 February 2011

SQL – Simple way to return messages at runtime instead of using PRINT

Care of David Poole of SQLServerCentral: http://www.sqlservercentral.com/articles/Documentation/72473/

 

 

RAISERROR ( 'DATA DICTIONARY: %i tables & %i fields added', 10, 1,

    @TableCount, @FieldCount ) WITH NOWAIT




The "10" parameter is the SEVERITY of the error message raised.

10 : this is more of a notice message, or minor alert

16 : this is reserved for true error messages


You can find more via:
http://www.sqlservercentral.com/articles/SQL+Puzzles/quickhintsforusingtheraiserrorcommand/2114/

http://msdn.microsoft.com/en-us/library/ms178592.aspx

Friday 11 February 2011

Internet Explorer IE Shortcut Keys

Care of http://support.microsoft.com/kb/306832

How to View and Explore Web Pages Shortcut Keys


To view and explore Web pages with shortcut keys:


To
do this


Press this key


Display
Internet Explorer Help or to

display context Help about an item in

a dialog box


F1


Toggle
between full-screen and other

views in the browser


F11


Move
forward through the items on a

Web page, the Address box, or the

Links box


TAB


Move
through the items on a Web page,

the Address box, or the Links box


SHIFT+TAB


Go
to your Home page


ALT+HOME


Go
to the next page


ALT+RIGHT ARROW


Go
to the previous page


ALT+LEFT ARROW or BACKSPACE


Display
a shortcut menu for a link


SHIFT+F10


Move
forward between frames


CTRL+TAB or F6


Move
back between frames


SHIFT+CTRL+TAB


Scroll
toward the beginning of a


UP ARROW


document


 


Scroll
toward the end of a document


DOWN ARROW


Scroll
toward the beginning of a

document


PAGE UP


Scroll
toward the beginning of a

document in larger increments


PAGE DOWN


Move
to the beginning of a document


HOME


Move
to the end of a document


END


Find
on this page


CTRL+F


Refresh
the current Web page


F5 or CTRL+R


Refresh
the current Web page, even if

the time stamp for the Web version and

your locally stored version are the same


CTRL+F5


Stop
downloading a page


ESC


Go
to a new location


CTRL+O or CTRL+L


Open
a new window


CTRL+N


Close
the current window


CTRL+W


Save
the current page


CTRL+S


Print
the current page or active frame


CTRL+P


Activate
a selected link


ENTER


Open
the Search box


CTRL+E


Open
the Favorites box


CTRL+I


Open
the History box


CTRL+H


In
the History or Favorites boxes,

open multiple folders


CTRL+click






How to Print Preview With Shortcut Keys


To Print Preview Web pages with shortcut keys:


To do this


Press this key


Set printing
options and print the page


ALT+P


Change paper,
headers and footers,

orientation, and margins for this page


ALT+U


Display the first
page to be printed


ALT+HOME


Display the previous
page to be printed


ALT+LEFT ARROW


Type the number of
the page that you

want displayed


ALT+A


Display the next
page to be printed


ALT+RIGHT ARROW


Display the last
page to be printed


ALT+END


Zoom out


ALT+MINUS


Zoom in


ALT+PLUS


Display a list of
zoom percentages


ALT+Z


Close Print Preview


ALT+C



How to Use the Address Box Shortcut Keys


To use the Address box with shortcut keys:


To do this


Press this key


Select the text in
the Address box


ALT+D


Display a list of
addresses that you

have typed


F4


When in the Address
box, move the cursor

left to the next logical break in the

address (period or slash)


CTRL+LEFT ARROW


When in the Address
box, move the cursor

right to the next logical break in the

address (period or slash)


CTRL+RIGHT ARROW


Add
"www." to the beginning and ".com"

to the end of the text that you type in

the Address box


CTRL+ENTER


Move forward
through the list of

AutoComplete matches


UP ARROW


Move back through
the list of

AutoComplete matches


DOWN ARROW


How to Work With Favorites By Using Shortcut Keys


To work with Favorites by using shortcut keys:


To do this


Press this key


Add the current
page to your favorites


CTRL+D


Open the Organize Favorites dialog box


CTRL+B


Move selected item
up in the Favorites

list in the Organize Favorites

dialog box


ALT+UP ARROW


Move selected item
down in the

Favorites list in the Organize Favorites

dialog box


ALT+DOWN ARROW


How to Edit With Shortcut Keys


To edit with shortcut keys:


To do this


Press this key


Remove the selected
items and copy them

to the Clipboard


CTRL+X


Copy the selected
items to the Clipboard


CTRL+C


Insert the contents
of the Clipboard at

the selected location


CTRL+V


Select all items on
the current Web page


CTRL+A

Sunday 6 February 2011

Android ADB Wireless

http://www.androidcentral.com/android-quick-app-adb-wireless

 

With the "adbWireless" app, you can connected to the android phone, over WIFI, as though you were connected via a USB cable.

 


(image care of AndroidCentral)

 

The "adb" command is usually part of the "Android SDK" (software development kit) which can be downloaded here.

 

A great article on the SDK can be found on AndroidCentral also, click here to be re-directed.

Installing Android 2.3 GINGERBREAD to Android HTC DESIRE

There's full instruction list on HOW TO INSTALL GINGERBREAD (Android 2.3) onto the HTC DESIRE over at BrightHub.

Some of the important steps are:
  1. Download (from MARKET) Rom Manager - by ClockworkMod
  2. Download the HTC Desire Android 2.3 Gingerbread ROM "update-oxygen-2.0-RC5-signed.zip" Download Oxygen 2.0 Gingerbread ROM for your HTC Desire. Note where you save the file on the phone, or tansfer the file to your phone from the pc and note the location.
  3. In ROM MANAGER, select the Flash Clockworkmod Recovery option. It will install the recovery image and backup the current ROM on your HTC Desire.
  4. In ROM MANAGER, select "Install ROM from SD Card" option.

    Select the Android 2.3 Gingerbread ROM (ocation previously noted) and click on install it.
    NOTE: Make sure to select the Wipe Data and Cache options before you install it.

  5. Wait whilst ROM MANAGER performs the install.


  6. In case of any problems with ROM Manager on your Desire,
    just boot your rooted HTC Desire into recovery mode and install the ROM via recovery directly.

Thursday 3 February 2011