Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    The reasons why you need to have functions in seperate modules:

    They can be called by any form, query, report, function in the application
    Access only loads them into memory if the function is called.
    They are easier to find and maintain.

    Why they should be inside the form



    The function is specific to that form and is never requested elsewhere.
    It handles data that is specific to the form controls.


    David

  2. #17
    timo1999 is offline Novice
    Windows XP Access 97
    Join Date
    Aug 2009
    Location
    Houston
    Posts
    12
    David,
    Did you ever get a chance to look at the database I resent? I never got the code or query to work.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. crosstab query criteria
    By Sharron in forum Queries
    Replies: 3
    Last Post: 12-15-2011, 04:31 AM
  2. crosstab query calculation
    By rutica in forum Queries
    Replies: 2
    Last Post: 04-28-2009, 09:52 AM
  3. many decimal places in calculated fields
    By GordS in forum Access
    Replies: 1
    Last Post: 02-04-2009, 11:12 AM
  4. Criteria in Crosstab Query
    By wasim_sono in forum Queries
    Replies: 1
    Last Post: 12-12-2006, 05:14 AM
  5. Replies: 2
    Last Post: 11-09-2005, 02:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums