10 questions to ask before you build a database Access does amazing things. We can use it to store, analyse, report on, and manage data. We can get it to automate our business processes, to download CSV data from an FTP site and upload it again as a PDF. To...
Read more
Category Archives: Microsoft Access
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...
Read more
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...
Read more
Microsoft Access Database Design courses
Learn to build a database by building your database!Many of our customers come to us to ask for an Access training course. We talk about the sort of topics that they would like to cover, and it becomes clear that in very many cases the customer actually needs to learn...
Read more
Conditional format a Microsoft Access form
Conditional formatting forms in Microsoft Access
Conditional formatting is made easy in Microsoft Access - there's a simple dialog box to complete, and your fields will change colour as soon as your crieteria is met.
But what if you don't want to colour code the text boxes but...
Read more
Conditional formatting is made easy in Microsoft Access - there's a simple dialog box to complete, and your fields will change colour as soon as your crieteria is met.
But what if you don't want to colour code the text boxes but...
Microsoft Access VBA – object variables
Early binding versus late binding in VBA
When you create object variables - that is, variables that refer to an object, such as an ADO recordset, or Microsoft Excel, rather than a data type such as Integer - there are two ways in which it can be done: through...
Read more
When you create object variables - that is, variables that refer to an object, such as an ADO recordset, or Microsoft Excel, rather than a data type such as Integer - there are two ways in which it can be done: through...
Why use a database?
What is the point of Microsoft Access?!
Most people who have Microsoft Office use Word, and very many use Excel. Some use PowerPoint, and a good proportion use Outlook.
But comparitively few people use Microsoft Access. So why is that? Partly because it's not perhaps as simple to...
Read more
Most people who have Microsoft Office use Word, and very many use Excel. Some use PowerPoint, and a good proportion use Outlook.
But comparitively few people use Microsoft Access. So why is that? Partly because it's not perhaps as simple to...
It’s not about the database, it’s about you.
I was with a client today to do some work on a database for them, when a casual conversation took place that made me think. The database in question was not a new project that I’ve worked on from scratch, but rather one that already existed and which needed some...
Read more