Results 1 to 3 of 3
  1. #1
    thekruser is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    93

    Best practice?

    What I have:
    tblPersonal
    -EmployeeNumber
    -LastName
    -FirstName


    -MI

    qryCommon
    -EmployeeNumber
    -NameLFMI: IIf([tblPersonal.MI] Is Null,[tblPersonal.LNAME] & ", " & [tblPersonal.FNAME],[tblPersonal.LNAME] & ", " & [tblPersonal.FNAME] & " " & [tblPersonal.MI] & ".")
    -NameFMIL: IIf([tblPersonal.MI] Is Null,[tblPersonal.FNAME] & " " & [tblPersonal.LNAME],[tblPersonal.FNAME] & " " & [tblPersonal.MI] & ". " & [tblPersonal.LNAME])
    -etc...

    My question:
    I created qryCommon basically as a code repository for quickly copying code I use over and over so I don't have to retype. Is it better practice to:

    1. Copy the code into every query I need it in
    -OR-
    2. Include qryCommon in the other queries

    I see plusses to both. 1-less possibility of a conflict 2-less code=smaller FE size.

    I just am wondering what the best practice is since I am basically creating a new database do to the "shortcuts" I have in my current one.

    Thanks in advance for your input. Have a great day!

  2. #2
    Join Date
    May 2010
    Posts
    339
    Bob Larson has something called "code store" I haven't tried it but looks useful. http://www.btabdevelopment.com/ts/freetools

    Richard

  3. #3
    thekruser is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    93
    I look into that. Thanks!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Structure | Best Practice Question
    By davidson12 in forum Forms
    Replies: 0
    Last Post: 11-05-2009, 03:29 PM

Tags for this Thread

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