MS Access query isn’t in the Tableau table list

2017-08-31T07:54:31+00:00March 14th, 2017|Access, Tableau|

Using MS Access in conjunction with Tableau isn’t always a painless experience, especially when it comes to the Access query. You might notice your Access query doesn’t appear in Tableau for you to choose. Alternatively you might find an Access query that returns records in Access returns zero records in Tableau. All of this happens without [...]

Remove a line feed / carriage return from a string

2018-05-07T08:25:35+00:00August 23rd, 2011|Access, Excel, SQL|

If you ever have to deal with long strings of freetext it’s likely you’ve come across random line feed and carriage returns in that text causing you headaches when it comes to manipulating the text. Once you know how it’s quite a simple problem to deal with. This article describes how to remove the carriage [...]

Access 2007 Calendar control

2011-07-18T18:56:44+00:00July 18th, 2011|Access|

I was developing in Access 2007 for the first time today (I was using Access 2000 the last time I developed in Access) and found a nice thing for entering dates into a text box. If you format the text box as a date it automatically shows a calendar control so the user can select [...]