software-help

Outputting CSV from an ASP page

Mar 16, 2011 · 1 min read · microsoft · visualbasic · vb.net · excel · asp.net ·

I’ve recently had the need to write an ASP page which reads a SQL database and outputs into Microsoft Excel- a user clicks on a link to this ASP page and Excel opens up with a new spreadsheet of the data. This is how I did it

Network Commands in VB.NET

Feb 28, 2011 · 1 min read · microsoft · visualbasic · vb.net ·

Share on:

A couple of useful network commands in Visual BASIC .NET (2005). These are the equivalents of doing ping and nslookup from the command prompt. The variable sIPAddress in these examples is a string containing the IP to test, i.e. "127.0.0.1"

Using Cron to automate a Rsync backup job

Feb 21, 2011 · 2 min read · linux · rsync · cron ·

Share on:

The rsync tool in Linux is very useful for backing up files from one machine to another, and coupled with the Cron scheduling tool it can be used to make a simple yet efficient automated backup. This post outlines how. Authenticating with the remote system It is necessary to save your credentials on the remote system, …

Scripted silent install of Visual Basic 6.0

Feb 16, 2011 · 2 min read · microsoft · windows · visualbasic ·

Share on:

I recently had a need to install Visual Basic 6.0 Enterprise Edition on a number of machines using a batch file script and a silent -unattended - installation process. Given the age of the application I thought this would be quite straightforward and well documented, but there were a number of hurdles to clear on the …

The Print Screen key, forgotten tool of the Windows desktop

Feb 16, 2011 · 2 min read · microsoft · windows ·

Share on:

The Print Screen key, usually located above the number pad to the right of the keyboard, is an invaluable tool when working with images in Windows. Pressing it will copy a picture of the entire screen to the Windows clipboard,

Missing Facebook updates?

Feb 11, 2011 · 1 min read · facebook ·

Share on:

Users of Facebook may have noticed that they’re missing some updates from their friends on their homepage (News Feed). This is a feature designed to show you only the most relevant info- posts from the users and applications you have interacted with most recently. If you want to change it so that all updates are …

Error trying to Install Expression Studio 4.

Feb 8, 2011 · 1 min read · microsoft · expression ·

Share on:

When installing Microsoft Expression Studio 4 on Windows XP Professional, double clicking on the setup application brought up the following error:

Your computer is scheduled to restart. Restart your computer and run Setup to continue installing this Expression program.

Turning a page round in Word 2003

Feb 4, 2011 · 2 min read · microsoft · word ·

Share on:

Often when writing a long document or report there is a need to switch from portrait (vertical) to landscape (horizontal) orientation for an individual page, for example to include a full-page table that is wider than it is high. This short “How To” explains how to do this using Microsoft Word 2003.

Microsoft Word 2003 Quick Tip #1

Jan 28, 2011 · 1 min read · microsoft · word ·

Share on:

You can select a whole sentence (including the full stop and following space) by holding down the CTRL key whilst clicking on the sentence.

New Years Day TimeStamp

May 5, 2008 · 1 min read · mysql ·

Share on:

Some work I’ve been involved with (see here and here) with UNIX Timestamps threw up another challenge today- getting the timestamp for midnight on January 1st of the current year. This is what I came up with: