Thursday, 9 February 2012

Excel 2007 problem printing fix

Recently I have had problems printing spreadsheets from MS Excel 2007, the print preview worked fine but when the spreadsheet was printed out parts of the document were missing. After some research I found the problem was due to a Windows update (KB2596596). Removing this update fixed the problem.

Thursday, 5 January 2012

PS3 Getting 3D working with TV

I recently got a Sony PlayStation 3 and was impressed with the picture on my Samsung TV while playing some games, I also received Tron 3D on Blu-Ray, when I tried to view this it said it was not connected to a 3D TV, but it was. The solution after looking on the net was that the cable that ships with the PS3 is not the correct one for 3D TVs, you will need to purchase a special HDMI cable designed for 3D TVs, I would recommend this as it also improves the picture quality of normal viewing. Expect to pay around £40 ($60) for a good cable. I have seen the Sony HDMI cable for sale at £20 from Sainsbury supermarkets.

Thursday, 29 December 2011

Security Shield - How I managed to remove this nasty fake program

Security shield is a fake anti-virus program that tries to get your credit card details by displaying a well designed and professional looking screen that tries to sell you it's fake software by listing viruses that it finds on your PC which do not actually exist. This is a very nasty virus, which after looking at solutions the way that worked for me to remove it from a Samsung NC10 was to do a CTRL+ALT+DEL while the screen was displayed and locate the .exe that was running, this will be some random letters followed by .exe. Once I located the name of the file I search the registry ('regedit' command from the run menu) for this file, and deleted any reference to it. After restarting the PC everything seemed to work fine and was back to normal.

Sunday, 4 December 2011

Samsung Smart TV - The Good and The Bad

I have now owned a Samsung D6530 LED Smart TV for over 3 months now. I really like the Smart TV option which connects to the internet via my wireless router, here are my views so far with the applications available on the Smart TV option:
1) BBC iPlayer is great, it is the app I use most and works exactly how I want it too, this is so far the best app.
2) You Tube, this is one of the worst apps I have used and it is better to access You Tube from the internet option rather than using the app.
3) Love Film would be good but I decided to cancel the subscription because the choice of films was very limited.

So far the biggest issue I have come across using the Smart TV option is that I need a keyboard for using the internet.

I would like more TV companies like ITV and Channel 4 to bring out apps like iPlayer for the Samsung TVs.

Sunday, 23 October 2011

Samsung NC10 battery problem temporarily fixed

The battery on my Samsung NC10 has gone again, I think this must have fixed the problem temporarily, but after a few weeks the problem has occured again, I think the only real solution to this problem is to buy a new battery.

Saturday, 1 October 2011

Samsung NC10 Battery Problem Fixed

I have owned a Samsung NC10 netbook for the past 2 years, a couple of weeks ago I tried to use it and it was dead, I plug it into the power supply and left it to charge for a couple of hours. I then disconnected it from the mains and tried to switch it on, it tried to start up but after a couple of seconds went dead. I then connected it to the mains power supply again and it worked fine. The battery manager reported 0% charge, and on the front the green light was displayed, so I figured there was a problem with the battery.

The netbook was out of warranty, but I still tried calling Samsung customer support, they were very helpful and we tried a couple of things to fix the problem, but the conclusion was that I needed a new battery. From the link Samsung support gave me to a retail site a new battery would cost about £70 ($100).

I heard somewhere that putting the battery in the freezer might help, I was not sure whether I was getting this confused with rumours that this fixes damaged hard drives, but I thought I would give it a go. I put the battery in newspaper and in a plastic bag and left it in the freezer over night. The next day I took it out of the freezer let it stand for an hour, then tried it. Nothing happened and it did not work, so I thought that's it I need a new battery.

I left the battery on the side for a week, until the following weekend. I was about to look at purchasing a new battery when I thought I would just give it a go again. I started the netbook up without the battery plugged in and with it connected to the mains power supply, I then plugged in the battery and was surprised to see the red light on the front instead of the green, which indicated it was charging. I left it for a couple of hours and when I came back I could unplug the mains power supply and it worked!!!

I still think there is a problem because it seems to report 99% power now, but I can use my netbook without having to plug it into the mains power supply and this also saves me £70 for a new battery.

I cannot say whether putting it into the freezer was part of fixing this problem, or whether just unplugging the battery and leaving it for a week helped, but something weird happened that has fixed the problem.

Monday, 5 September 2011

Sysbase Advantage Database - Using triggers to keep a history

I recently wrote an article about how to use triggers to keep a history of changes made to database records. This is very useful is you want to keep a trail of record changes for example I have used this to keep a trial of stock and where stock has moved from and to, also keeping a history of what has happened to a customer's order. I think most commercial databases would benefit from doing this and because it is done at  the database end it means that once it is done it will always keep a history rather than writing logging into software applications. Click here to go to the article.

Friday, 5 August 2011

iPad - How to take a screenshot of the display

While doing developments for the iPad it is often a user will report an issue or make a request. I've found that asking them to take a screenshot an emailing it a very useful tool on the iPad. To take a screenshot just follow these steps.

  1. Press and hold down the home button, this is the button on the front of the iPad.
  2. Press the power button on the top, this will cause the screen to flash confirming the screenshot has been taken.
  3. Go into 'Photos' and you should see the image of the screenshot allowing you to email the image.