June 2004 - Posts

• Tips on Access report numbering

  Starting Report page numbers from a number other than one In Design View place an unbound text box in the report footer or header. Then enter the following in the ControlSource property of the text box: ="Page " & [Page]+([Starting Page]-1) When you Read More... Posted Friday, June 25, 2004 5:48 PM by frice | 0 Comments

• User-Defined Functions in Excel

  Excel allows you to create custom functions, called "User Defined Functions" (UDF's) that can be used the same way you would use SUM(), VLOOKUP, or other built-in Excel functions. The Excel user who wishes to use advanced mathematics or perform text manipulation Read More... Posted Friday, June 11, 2004 5:38 PM by frice | 3 Comments

• Creating reusable code

  This blog discusses just a couple of ways that you can make your code reusable. If you frequently create similar projects, you can save yourself considerable development time and ensure application consistency by creating and using object and project Read More... Posted Friday, June 11, 2004 1:44 PM by frice | 0 Comments

• Adding Additional Conditional Formatting in Access with VBA

  Microsoft Access 2000 (and later) lets you conditionally format the data in combo box and text box controls based on certain conditions through the user interface or through programming. However, each control is limited to a maximum of three conditional Read More... Posted Tuesday, June 08, 2004 4:03 PM by frice | 1 Comments