Darragh Murray

Author: Darragh

  • Access 2007 After One Hour – Initial Highlights

    —

    by

    Darragh
    in

    I’ve been using Access 2007 for about an hour now, quickly developing a small database to store information on what periodicals I’ve been reading for my thesis, and when I have accessed them. Quick review – it is fairly impressive! Highlights are: The Ribbon Gui common to all Office 2007 products is used very well…

  • Access 2003 – Importing Queries results in bad query aliasing.

    —

    by

    Darragh
    in ,

    This is a quick little tip. I came across a minor annoyance the other day when I was importing Access saved queries from another database and using link tables. If you import your queries before you link your tables, then try run the queries with no tables link – Access will complain that it can’t…

  • Ms Access – The Upgrade

    —

    by

    Darragh
    in

    I’d never thought I’d ever say something so geeky but I must comment that I don’t think I’ve ever been as excited about downloading a product as I am right now. And right now I’m downloading Ms Access 2007. I’m taking advantage of the http://www.itsnotcheating.com.au offer, and buying the new version of Office 2007 Ultimate…

  • Ms Access – Percentage Field Formatting

    —

    by

    Darragh
    in

    A quick tip to fix what shouldn’t be a problem! Occasionally, Access can act rather confusingly. I ran into a typical example early this morning, when I was trying to get Access to allow entry of percentages correctly. I’ve done this about one thousand times before and probably solved this problem one thousand times as…

  • Useful Access Links

    —

    by

    Darragh
    in

    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…

  • Running SQL from Visual Basic Code – Apostrophe problems!

    —

    by

    Darragh
    in ,

    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…