Darragh Murray

Data visualiser and analytics professional

All posts by Darragh

Useful Access Links

Posted on Author DarraghPosted in Ms Access TipsLeave a Reply

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 – Forms as Class Modules
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html – “Not Another Access Page” Albert D. Kallal page on random Access related tips. The section on implementing simple mail merges is recommended.
http://www.tek-tips.com/faqs.cfm?fid=5010 – Looping through Form Controls.
http://www.fontstuff.com/access/ – Martin Green’s Office Tips. Great section on Access.… Read the rest

Running SQL from Visual Basic Code – Apostrophe problems!

Posted on Author DarraghPosted in Ms Access Tips, VBA2 Replies

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 something like this:

strSqlCode = “Select format([field1], “Currency”) from table1″
db.execute strSqlCode

You will get a nice friendly Access message indicating that your SQL is faulty. Surely that ain’t the case!

There are several different solutions and here is one I find the most handy … Read the rest

Ms Access Tips

Posted on Author DarraghPosted in Ms Access TipsLeave a Reply

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 back’ some ideas in regards to my Ms Access experiences.

Therefore, I’ve decided to put some effort in putting up a few ‘tips’ or ‘shortcuts’ is an easy to access manner (no pun intended). These will be sometimes a few generic code snippets, sometimes … Read the rest