• frice's WebLog

    Using Northwind Traders can save yourself a lot of time

    • 1 Comments
    Since 1994, regardless of my actual job, I've always found a way to stay involved with Access. I'm certainly no expert but I like working with Access and with the people that work with Access. I just finished attending the MVP Summit in Redmond, my second...
  • frice's WebLog

    Writing Technical Articles - Part 3

    • 1 Comments
    To recap, you've created a plan and an outline for your article. You've also added code samples or created the "to-die-for" tool or utility. And you've written your article as clearly and concisely as appropriate. Now it time for the scary part: letting...
  • frice's WebLog

    Writing Technical Articles Part 2

    • 2 Comments
    Continuing my previous blog on writing technical articles, now that you have a plan, it's time to create an outline. If done correctly, the outline can serve as the table of contents (if you use a TOC) for your article. Magazines and technical publication...
  • frice's WebLog

    Writing Technical Articles Part 1 - Step up to the plate and share the wealth

    • 3 Comments
    I'm a programmer writer for the MSDN Office Developer Center. My job for the last five years is writing how-to articles for developers that appear on the Microsoft Developer Network (MSDN), specifically, Microsoft Office developers. I have a background...
  • frice's WebLog

    Using ADO with Excel Data Sources

    • 1 Comments
    ADO is used for performing client/server data access between a data consumer and a data provider. ADO is a good choice, in many instances, for working with Excel data because it eliminates the sometime lengthy process of having to open Excel. Using ADO...
  • 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)...
  • 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

    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

    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

    Database normalization simplified?

    • 10 Comments
    --Making Sense of Database Normalization, Hopefully-- Following is my take on database normalization. Hopefully this simplified version will help your understand of a sometime complicated subject a little better. When setting up a database...
  • frice's WebLog

    Adding a button and Click event at run-time

    • 9 Comments
    Many developers recognize the need to disable certain controls in their application to either keep from confusing users as to which button to click or to keep users from clicking buttons at an inappropriate time. Usually this is done by programmatically...
  • frice's WebLog

    Should I use a bang or dot?

    • 0 Comments
    One of the questions frequently asked by new Access users (and veterans as well) in the newsgroups concerns writing expessions that reference various collections, objects, and properties. When should you use a bang (!) and when should you use a dot (...
  • frice's WebLog

    Improving Access Database Performance

    • 3 Comments
    One of the areas where I see a lot of questions in the newsgroups concerns the performance of Access databases. Access databases are used for a variety of applications; everything from relatively small to medium records management to proof of concept...
Page 2 of 2 (38 items) 12