Darragh Murray

Category: Ms Access Tips

  • 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…

  • Ms Access Tips

    —

    by

    Darragh
    in

    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…