Access

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

2020-03-18T20:33:59+00:00August 23rd, 2011|Access, Excel, SQL|

This article describes how to remove the carriage returns and line feeds in SQL, Excel and Access. 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. These unwanted characters can cause multiple problems, therefore removing or replacing them is [...]

Access 2007 Calendar control

2020-03-07T08:31:16+00:00July 18th, 2011|Access|

Today I used Access 2007 for the first time. In the past I was an Access 2000 developer. In Access 2007 found a nice thing for entering dates into a text box. Formatting the text box as a date automatically shows a calendar control. Therefore the user can select a date from the calendar, thereby [...]