darragh murray

It is not the critic who counts

About

A place where I can write irrelevant anecdotes that make me sound like a pretentious git.

Archive for July, 2006

Useful Access Links

Wednesday, July 19th, 2006

In the absence of any real content, I’ve decided to post a few Access and VBA related links here. Some are rather general, some are rather specific. Regardless, they’ve been floating around in a text file called ‘useful stuff to look at’ on my computer for a while. So why not share the love?
http://www.vb123.com/toolshed/02_docs/classyforms.htm - [...]

Read the rest of this entry »

I recently encountered a problem that I’ve actually encountered millions of times before - trying to run an SQL string from VBA code which makes use of double apostrophe’s (””). Naturally, VBA uses these to break from a string literal, but pure Jet-SQL uses them for functions like Format() and Nz().
So if you do [...]

Read the rest of this entry »

Ms Access Tips

Tuesday, July 11th, 2006

Hello valued reader!
Over the years, I’ve had the pleasure of doing quite a bit of work in Ms Access, and also in Visual Basic for Applications. On countless occasions I’ve benefited from the work of countless others who toil in this Rapid Application Development suite when I’ve encountered a hitch. I’ve always wanted to ‘give [...]

Read the rest of this entry »

Promises, Promises

Tuesday, July 11th, 2006

Its been a while, but….
Like a disgraced samurai, the federal Liberal party leadership seems to feel the need to disembowel themselves. Despite not being a Liberal party supporter, I am amazed that the leadership feels the need to disrupt a ‘winning team’. Despite political or ideological question marks, the coalition’s dominance on the federal scene [...]

Read the rest of this entry »