Category: #Tips and Tricks

GoDaddy Hosting | Connect with FileZilla

Open FileZilla program. Go to File and select Site Manager Click the New Site button and […]

Div OnClick instead of a href | Quickie

Instead of using the “<a href=” tag to go to another page, you can use the […]

Create your favicon.ico easily

To easily create a favicon.ico to be used on a website, you can use the following […]

SQL Server 2005 | Add days, months and years to GetDate()

To get the current date in Sql Server queries and stored procedures, you use the GetDate() […]

Error 29506 | SQL Server 2005 Management Studio Express

When i binged (yes I’m using bing :P), i found the following fix: Search for Command […]

Foxpro | Import table to Excel Error

Tried to import a foxpro table to an excel file but the following errors loaded…

Excel | Print First Row on every page

To be able to print the first row on every page, you need to do the […]

Convert String to GUID | Quickie

To convert a string to GUID you have to do the following: string text = “6937e459-f1bd-4a20-ab10-28ff0010c15b”; […]

Get a Double Random Number | Quick Tip

This is useful since the Random() object can only export a double number between 0.0 and […]

Convert degrees to minutes for Google Maps in Excel

Normal Formula =”N” & INT(H2) & ” ” & ROUND(((H2 – INT(H2)) * 60), 6) Advanced […]