Because the standard Gregorian calendar used by the majority of the world doesn’t lend itself to date calculations (differing length months, and leap years to name but two examples), Microsoft have devised a special system for dates within Excel which makes it easy to incorporate calculations based on dates into your spreadsheets and Excel based […]
Category: Office 2007
In Microsoft Office, the Excel undo list has a limit of sixteen entries, which for some power users can be too few but with a single registry hack, it can be changed to any number you like. The main body of this article explains how to alter the registry which if done incorrectly can cause […]
Here is a selection of some of the most often used keyboard shortcuts, along with a few you may have never used before, or even know existed! If you have any others that you would like to add, then please E-mail your tip to us, and we will include it with a credit to your […]
Like most programs, Microsoft Excel has certain terms and phrases that are specific to it. We have attempted to list as many of the terms you are likely to come across below. If you come across a word or phrase that you either don’t understand, or that you think should be in this glossary, please […]
Sometimes it can be useful to know which user is logged on to your application, maybe in order to check that they have the correct permission to use the application etc, or maybe unlock certain features that are only available to certain users. We have outlined some code below to help you achieve this, the […]
To use this tutorial you will need to have worked through Part 1 – click here to go to Part 1. Now that we have created our Form and Query, we now need to start a chain of events that will lead to the retrieval of data based on the Query. It is unusual, (and bad practice) […]
A common question from Access developers is ‘How can I have a query that has a ‘drop-down’ to specify the criteria?’ Whilst Access has no actual function built in to the query builder, it is possible to add this functionality with just a little bit of work. This tutorial assumes that you are already conversant […]
Microsoft Access Forms are the basic interface between your application, and your users. Whilst form are generally used to provide easy data entry and manipulation, correctly designed and well thought out forms can also be used to create your own menu system. Because the Microsoft Access form provides the main interaction with your users, it’s […]