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.
I was doodling this afternoon on the computer and created this calculator. It’s created using CSS and Javascript. The CSS is drawn from http://css-tricks.com/examples/ButtonMaker/# and the javascript from http://www.code-sucks.com/code/javascript/template.php?tutorial=calculator.php. I can’t embed the calendar on here but it looks like this: It’s nothing particularly clever but should allow you to put a simple calculator on […]
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).
I’ve just been importing some records from Excel to Access using VBA. By default the names of the fields of the imported records are “F1”, “F2”, “F3” etc. To make things a little clearer I wanted to rename these imported fields to more meaningful names. Here’s how to do it: CurrentDb().TableDefs(TableName).Fields(“OldName”).Name = “NewName” where: TableName […]
I’ve just been working on an Excel problem that requires one worksheet to be opened at a given time (using the Windows Task Scheduler) and a macro run. However, when testing this I came across the “Personal.XLS locked for editing” message. It seems that this is due to having more than one instance of Excel […]
Often I come across a database which has been designed with multiple address line fields. We usually want to concatenate these multiple address lines into a new field with each of the old fields on a new line. To do this I usually create a new query and use something like the following SQL: SELECT […]
MoveFirst Weblog 