Results 1 to 2 of 2

Dealing with historical data on a Form

  1. #1
    Yogibear is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2012

    Dealing with historical data on a Form

    I have a database with student information that contains tables about their dissertation and graduation information. There is a field "academic year" noting their graduation year. I have a form for data entry that my data entry person likes to use in datasheet view. The form is based on a query that contains only current academic year records. When a new academic year arrives, I plan to create a new query for the form to feed from. I am not sure this is the best way to handle this, i.e., "hiding" past academic year records on the form in datasheet view.

    Hope that makes sense.....


  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    Having to modify form just because the year changes is poor design. Alternative is dynamic filtering of the form. Can have the form default to filter for the current year but then user can select another year.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Dealing With Expression Of The Form
    By azhar2006 in forum Queries
    Replies: 4
    Last Post: 02-07-2014, 02:37 PM
  2. Handling Historical Data with different assignments
    By crimedog in forum Database Design
    Replies: 5
    Last Post: 12-12-2013, 09:43 AM
  3. Replies: 5
    Last Post: 03-05-2013, 03:30 PM
  4. Historical data
    By Accessgrasshopper in forum Access
    Replies: 0
    Last Post: 02-28-2011, 06:39 PM
  5. Replies: 1
    Last Post: 12-09-2010, 08:29 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
Tech Forums: Microsoft Office Forums