Anup Saund

🇬🇧British Expat 🇨🇦Vancouver ❤ Gardening 💰Founder of gitSQL

In Sky Design – Website Launch

“I’ve opened up a web design business”

After many years of freelance web development, I decided to bite the bullet and “open up shop”.

In Sky Design is an association of designers and developers working together to create user friendly websites. We offer web design, graphic design and web application development; for start up business and established businesses who need internet solutions.

Please take a look at www.inskydesign.co.uk

We have set packages along with a price guide to show what our customers most commonly ask for.

If you can’t find it on the website, no problem, please ask.

Vista Compatibility Mode

Here’s a nice neat trick to get Windows XP application to work in VISTA.

[HKEY_CURRENT_USERSoftwareMicrosoftWindows NTCurrentVersionAppCompatFlagsLayers]"$path"="WINXPSP2"

Replace $path with the absolute path to your program;

i.e.

c:\program files\myapp\myapp.exe

Make sure you add double back slashes.

Stop the Microsoft Office 2007 Logo / toolbar / ribbon from blinking / flashing

The Issue Microsoft Office 2007 has a wonderful new interface with ribbons, which other developers are adopting as a windows standard. However, when office is installed and used for the first time, the Microsoft Logo (shown below) flashes until the user clicks it.

Microsoft Flashing Logo

So what’s the problem?

I have been using the Microsoft Access 2007 object in Visual Basic at work, and attempting to open an instance of Access as hidden. The issue comes up when we distributing the application that we have created.

When the user installs Access 2007 – Run Time Edition, and then runs our application, the Access Window pops up, with the flashing logo.

How do I stop it from flashing?

This is the million dollar question that I’ve been trying so hard to find the answer to.

– Brielfly, I ran a registry comparison tool (RegFormApp) to see what happens when the user clicks on the microsoft logo in an office program.

The program showed that the following registry key was being updated.

 [HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0CommonGeneral]
"OfficeMenuDiscovered"=dword:00000001

Okay, for those of you who use windows registry edit, follow the following steps;

How to change the setting

1) Navigate through the tree menu on the left, until you get to the right place.

2) Double click on “OfficeMenuDiscovered”.

3) Change the setting from 0 to 1. Click OK to save the changes.

The .REG File Method
Stick the following into notepad, and then save the file as a .reg extention.

[HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0CommonGeneral]
"OfficeMenuDiscovered"=dword:00000001

This will make it into a Registry update file that you can use in installers, etc, to get the setting set!

All I can say is that it’s been a journey.

I hope this post saves you a lot of time and effort in your developments.

Internet Explorer 7 – Accessibility Options

These settings are a web developers worst nightmare…. what happens if a web browser ignores the website FONTS? or worst still the STYLESHEETS?

Well – i guess if the website is built with accessibilty in mind, then there is no problem;

The page will render correct, no matter what browser or platform… but… if you have to use absolute positioning, and specific font sizes… then please please bear these settings in mind.

IE7 Accessibility Options

Tools | Internet Options | Accessibility.

Happy coding people!

Split a Price (FLOAT) into Pounds (£) and Pence (p)

Whilst working on an E-commerce website, written in PHP i came across and issue where i had a price stored in a table as a float.

I wanted to split the pounds, and pence into two variables to make it easier to work with, but then save the results back into 1 field. So this is what i did.

http://uk2.php.net/manual/en/function.explode.php#63110

//If you want to split a price (float) into pounds and pence.
//or dollors and cents etc etc.

$price = "6.20";

$split = explode(".", $price);
$pound = $split[0]; // piece1
$pence = $split[1]; // piece2

echo "&pound $pound . $pencen";</span></code>

Enjoy 🙂

Logmein Desktop Shortcuts (Bypass Logmein Website Login)

www.LOGMEIN.com

Step 1: Log into logmein.com

Step 2: Click on “My Computers”

Step 3: Click on “Edit Computer”

Step 4: Click on “Desktop Shortcut”

Final Step: You can now drag the [Compuer Name] onto your desktop, to create a desktop shortcut.

When you click on this shortcut, it will go directly to the login page for the COMPUTER, instead of having to login to the logmein website.

Great HUH!

You can also right click, and copy the URL, and then do what you want with it. At work we have collated a list of all our computer connections, and published it in a central place, so that everyone in the office can access any machine, directly.

Nice One LOGMEIN.

Baked Cassava Chips (Healthy Option to Fried Cassava Chips)

Baked Cassava Chips (Healthy Option to Fried Cassava Chips)

Ingredients

  • Cassava, 2 – 3 large pieces.
  • Salt,
  • Pepper,
  • Red Chilli Powder,
  • Lemon Juice

Step 1

Peel away the red skin using a potato peeler or sharp knife
Peel away the red skin using a potato peeler or sharp knife

Step 2

Cut the ends off the cassava. Now cut the cassava into large pieces around 3 inches in length.
step 2

Step 3

Bring a large pan of water to the boil. Add a teaspoon of salt.
step 3

Step 4

Cook the cassave in the water for around 30 – 45 minutes. It will start to split when it is done.
step 5

Step 5

Drain the water out from the pan and place the cassava on a chopping board.. (careful, its hot)
step 6

Step 6

Slice it up into “chip” sized pieces. Place the pieces onto a baking tray, oven proof pot or similar (I used a piece of foil on a oven shelf)
step 7

Step 7

Sprinkle some red chilli powder over the chips. You might want to add a little more salt here, and cracked black pepper. (I used garam masala instead of red chilli powder)
step 8

Step 8

Sprinkle some lemon juice over the chips. The lemon juice helps the chips to become crisp and glazed.
step 9

Step 9

Place the chips into a pre-heated oven at 220 degrees centigrade. Leave it for around 15 minutes or until the chips are turning golden around the edges.
step 10

Step 10

Serve.

The picture shows from left to right:

1. Boiled cassava, with seasoning

2. Baked cassava with seasoning.

3. Plain boiled cassava.
step 11

A nice alternative to regular chips hey?.. Enjoy. x

Disable Microsoft Access 2007 Security Warnings (Macro, Office 2007)

Disabling Security Warning Box
The easiest way to do this is to add a registry key to turn VBA Warnings Off:

1. Open Notepad

2. Paste in:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USERSoftwareMicrosoftOffice12.0AccessSecurity]
"VBAWarnings"=dword:00000001

3. Save as filename.reg

4. Run filename.reg, and say YES when it asks if you want to add the registry key.

As you may have guessed, you can add the same DWORD to the other directories like WORD, EXCEL etc.

Version 12 is for Office 2007, but this also works with 11.0, 10.0 versions of OFFICE.

Enjoy Hacking!

Website Copyright Date

Have you noticed that some websites have a copyright date which is wrong?

For example:

www.somecompany.com (I appologise if you own this site)

then on the site, you have, Copyright SomeCompany Ltd 2002-2006

Now, if your lucky, your site is designed so that the footer can be changed once, so the entire site is updated. Well done.
For the others… shame on you. – Redesign your site.

Anyway.. heres a way to crack it on the head once and for all.

//PHP
2003 - < ?php echo date("Y"); ?>
//ASP
2003 - < %= year %>

This way, as long as your server date is correct, your website will always be up to date. In fact, consider using date more in this way, to save yourself manual intervention.

Antivirus Software

What do we look for when chosing antivirus software?

Personally, I’m looking for something that doesn’t,

i) Scan every mouse click, making the PC unusable
ii) Is affordable, and easy to use

We use Norton Antivirus 2006, and F-Prot at work. Both do what they say on the Tin. (*cough* no slander)

… I’ve been looking at home for something and came across C.O.M.O.D.O’s offering.

(PLUG)
http://antivirus.comodo.com/

  1. Eliminates Viruses, Worms and Trojans from desktops and networks
  2. Detects and eliminates viruses from desktops and networks
  3. Constantly protects with real-time On Access scanning online
  4. Proactive Heuristic analysis intercepts unknown threats Daily, automatic updates of virus definitions
  5. Isolates suspicious files in quarantine preventing infection
  6. Simple to use: install and forget

FREE SOFTWARE – NO LICENSE FEES EVER
Comodo AntiVirus 1.1 beta, all subsequent beta versions and the final release version will each be available free to both home and business users

Bid farewell to viruses and kiss license fees goodbye.
Download today for out-of-the-box protection at no cost.

(END PLUG)

If you want the complete package, you can install their Internet Security for firewall protection.

I don’t need to hype it up anymore, try it out.

Page 2 of 2

Powered by WordPress & Theme by Anders Norén