LEARN MS-ACCESS TIPS AND TRICKS

In some Projects we have to upload data regularly from external data sources like dBase, Excel, flat files like CSV, Text and so on. The external file can remain linked to the Project and the data from them can be added into the local MS-Access Table for preparing Reports

How to search for several pieces of information across all the fields and in all the records of a Table?

 

For example, when we search for something on the Web we give several piece of text separated with , or + symbol to match any of the given text anywhere within the Web Pages and display the matching links on the screen.

Any method that helps to find data quickly on a Form is always welcome by Users. There are several options available when you are in Form View Mode.

 

When you Right-click on a Field a Shortcut Menu will popup showing four data filter options as shown on the sample image given below.

Last week we have prepared a Report Parameter Control Form for concurrent usage on Network without clashing with other User�s Report Data Filter Parameter Values, while preparing different Versions of the same Report. To do this we have discarded the usage of a Parameter Table as Record Source to the Parameter Form and created two Unbound Text Boxes for keying in Parameter Values for setting Filter condition in the Report Source Query. Besides that we have seen how to save the Parameter Values in the Custom Properties of the Form, when the Form is closed.

Parameter Controls are provided to the Users for entering data Filter criteria values for preparing MS-Access Reports. A reference to the parameter control fields can be set in the criteria row of the Report Source Query directly to filter the data. A sample image of such a Parameter Control is given below.