Search results

  1. M

    Alternate Rows in Forms - The easy way

    Hi, After a *lot* of searching, and looking at various code samples, I finally figured out a *very* easy way to get alternate Row colours (colors) in continuous forms. I can't post a sample just yet, but the instructions are: 1) Create the Public function: '(Create the Variable first)...
  2. M

    'Public' and 'Private' Prefix, when do I need them?

    Hi Everyone, I hope this isn't a really stupid question :) Basically, I've searched and searched, but can't seem to find an answer to the following: If I create a Sub or Function that is bound to a Form, so It's only accessible by that form (private). So what is the difference between typing...
  3. M

    Difference between Public 'Sub' and Function'

    Hi All, Please forgive me if this is a stupid question, I am new to VBA. I was just wondering if someone could explain simply, the difference between a Public 'Function' and a Public 'Sub'. Specifically, when the use of each is recommended, and how they differ from each other. The only...
Back
Top Bottom