Wednesday, June 18, 2008

Turbo Charge Your Access Form and Report Design Tasks With Custom Templates!

"Do overs" are fun if you are playing a game. They are not fun when designing Access Database Forms and Reports. We will show you an easy way to save time every time you create a new Form or Report.

Access Wizards do a great job of helping you create a Form with the text boxes and combo boxes you need. But, it does a lousy job of formatting the forms the Wizard creates. You have to resize all of the controls and align them and change the font, background color, back style-I get tired just thinking about it. Here is a time saving tip that can vastly speed up your Form and Report development time.

You can save a lot of time by creating and using your own Custom Form Template and Default Control Properties. To make a Form Template, create a Form with the format and control properties you want and save it as "Template". On the Menu Bar click Tools | Options and then select the Forms/Reports tab. In the Form Template box type "Template". Note that you can also make a Report Template as well. Click OK and you are ready for faster Form developing.

The next time you create a new Form or Report it will have the form and control properties you saved in the Template. If you create a lot of Forms and Reports this tip will save you a great deal of time.

You can get more info here:

http://articles.techrepublic.com.com/5100-10877_11-6181942.html

http://allenbrowne.com/ser-43.html

You are welcome to download our Free Database Samples. Feel free to copy the code and modules to use or distribute in your Access Applications. One of our favorites is the free and easy to use Free Access Pop-up Calendar that is an Access Form so there is no ActiveX or broken reference hassle.

Visit us at our Church Management Software Solutions site to download our free Church Management Software.

Patrick A. Wood

http://www.advancingsoftware.com