June, 2004

  • frice's WebLog

    User-Defined Functions in Excel

    • 3 Comments
    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...
  • frice's WebLog

    Adding Additional Conditional Formatting in Access with VBA

    • 1 Comments
    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...
  • frice's WebLog

    Creating reusable code

    • 0 Comments
    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...
  • frice's WebLog

    Tips on Access report numbering

    • 0 Comments
    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)...
Page 1 of 1 (4 items)