Archive

Archive for the ‘Access’ Category

MS Access query isn’t in the Tableau table list

March 14th, 2017 No comments

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 any explanation, it’s a frustrating head-scratching moment. This article might help solve your problem.

 

My working Access query doesn’t return any records in Tableau

From my testing if there was a LIKE statement in the WHERE clause this caused Tableau to return no records. The query did appear in the Tableau table list but returned zero records. Options are: Read more…

Categories: Access, Tableau Tags:

Remove a line feed / carriage return from a string

August 23rd, 2011 3 comments

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 returns and line feeds in SQL, Excel and Access. Read more…

Categories: Access, Excel, SQL Tags: , ,

Access 2007 Calendar control

July 18th, 2011 1 comment

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 a date from the calendar removing data entry formatting errors. So much easier than using the Active X calendar control in previous versions of Access. I was so glad/surprised to see it I’ve felt the need to write a post about something released 4 years ago 🙂