Access Solutions

How to Implement Conditional Formatting in a Continuous Form in MS Access

In this article, we explain the steps for applying conditional formatting to a Continuous Form Conditional formatting as the name suggests is the kind of formatting that can be undertaken only when certain conditions are met. This is the kind of formatting that can be used for changing the background or the foreground color of the textbox controls that are a part of our forms or reports being used. To change the color of a single or multiple fields the values need to meet certain conditions;...

Read more »

How to Use Temporary Tables for Negotiating Non-Updatable Queries in MS Access

In this solution, we look at a non-programmatic way to deal with non-updatable queries in MS Access using Temporary tables  Queries in MS Access are one of the essential features provided by the application. If you take away the query feature from MS Access, there would be very little left in the application. Access provides its users with multiple types of queries that can be used in multiple situations. However, these queries also have their own set of limitations. The most annoying one...

Read more »

How to Quickly Create a Macro Group in MS Access

In this article, we attempt at creating a Macro Group in MS Access instead of creating several standalone macros. Macros in MS Access allow you to automate actions. You can opt for creating a macro to get a particular task done. You might also want to create group macros which can be used for automating the related task to the one that you have automated. If you are making use of the 2007 edition of MS Access, you will have the option of using the macro objects for containing the macros that...

Read more »