Excel’s Concatenate function without limits!

Get over the limitations of the built-in CONCATENATE function in Excel.

In this post we take a look at writing an alternateive to Excel's concatenate function, which both overcomes the limit on the number of values that can be concatenated, and also allows a delmiter to be specified, such as a comma, beteween values.

Advanced Excel conditional formatting video tutorial (part 2)

Creating dynamic forms with Conditional Formatting
In this video tutorial we take a look at using conditional formatting to make Excel forms dynamically respond to user entries.
For example, display "Additional info" fields when users select a particular value, or display multiple sections based on user input elsewhere.

Advanced Excel conditional formatting video tutorial

Get more from Excel's Conditional Formatting tools

Excel's conditional formatting tool really got beefed up with the new options introduced in Excel 2007. But in this video, we show you how to do more with conditional formatting - whether you're using Excel 2010 or Excel 97!
Learn how to... - Highlight a whole row of data based on a condition in one cell
- Change a value with a scroll-bar control
- Make conditional formatting more dynamic

New clients! Welcome to you all!

A chance to say a big thank you!

It's been a packed few months for us at The IT Service. As well as developing multiple database for existing clients, we've had a great time meeting new customers too.

Whether it's an in-depth look at how an existing database can be better structured, or a whistle-stop tour around the key features of Office, an introduction to XML or a look at creating a system to link Outlook and Excel - we've seen it all in the past few months!

Here's just a little of what we've been up to, and who's joined us since the start of the year...

By | 2012-04-26T16:05:36+00:00 April 26th, 2012|News, Uncategorized|2 Comments

A Microsoft Access tool to automatically rename your form controls

I love Microsoft Access. There, I said it. Thare are so many things I love about it that I wouldn't know where to start with listing them all. So, it's just as well that this article isn't about that. It's about fixing one of those things that's just a bit of a pain. Use prefixes [...]

The InputBox Function, the InputBox method, and using strptr

The InputBox is one of the most commonly called functions in the whole of VBA. Whether you're writing a complete database application in Microsoft Access, or just adding bit of functionality to your Microsoft Excel workbooks, the odds are that you won't do much coding before you make your first call to the InputBox function.

So, I thought I'd dedicate this post to getting a little more from the InputBox - particularly in Excel, but also in Access.