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 !

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

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

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

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.
   

EXCEL – Row Number function ROW()

To get the physical row number value in EXCEL, use the formula

=ROW()