This site was originally created way back at the start of 2008 as a way for me to keep to hand little snippets of code (particular VBA) which I created and then might need later. I moved away from VBA a long time ago but left this site up as it still seemed to be […]
Wow! Long time without a post. Anyway, I can’t believe that I’ve never realised how hard it is in the older version of Microsoft Excel to insert multiple blank rows. I searched Google and found a few sites saying press F4 or buy our tools so I wrote quick macro. The macro asks how many […]
On the 28th of October 2012 I went to York Vue to see Hotel Transylvania I thought it was awesome! My family thought it was, well wait a minute, my sister has two things she thought it was: fantastico and excellent.
Just a quick shout out for the Stuart Bell Swim School. (Teaching children to swim in York, UK since 1991). Take a look at http://www.stuartbellswimschool.co.uk.
Wow! typing that heading is more complicated that solving the problem! I have a main for that contains a number of tabs (let’s call the form “frm_MainForm”). The tab is called “tab_MyTab” (but this doesn’t really matter – see below!). One one of those tabs contains another form (let’s call it “frm_FormOnTab”). This form then […]
Here’s another of those things I forget if I don’t use SQL Server for a while. To enter a value of <NULL> into a field in SQL Server just type: [Ctrl] + 0 (Hold down the Ctrl key and press the zero key).