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 […]
Category: Office 2010
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 […]
Splitting an Access database is about the most important thing that you can do to add stability to an application and any experienced developer will almost certainly tell you to ‘split’ your database into a Front End (FE) and Back End (BE) The Front End will contain all the Forms, Queries, Reports, Macros, and VBA […]