Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Mar 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding Pages for new info ('97 / Access)

    I am tying to get our database up and running. The question was brought to me that on a form what would I do if I wanted to be able to add info for different years but for the same Company. Is there a way of just adding pages with certain info on it. I hope I'm explaining this good. I don't even know if this can be done but I figured I would ask.
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Adding Pages for new info ('97 / Access)

    Can you provide some more information on what tables you already have, how they are related, and what your form is based on? Without that, your question is hard to answer.

  3. #3
    New Lounger
    Join Date
    Mar 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Pages for new info ('97 / Access)

    Sorry about that. Let me see.... We work with Benefit plans and each year we have to do census, 1099's, and testing. This is stuff we do every year for the same company. On this form there are 2 tables linked together one with Company info. the other with all the plan year end info. i hope this is a little more clear. We want to be able to keep all the info even from the previous year, well at least for 3 years, and still have everything together as if it were in a folder or something without having to go in each year and erase last years info.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Adding Pages for new info ('97 / Access)

    Perhaps someone from the USA (I suppose you're from there) can help with specific features - I don't have the slightest idea what "1099's" are.
    I would recommend creating a main form for company info, and a subform for year end info. This subform can contain multiple records for a single company, corresponding to different years. This way, the user can inspect/edit data for several years in one form.

    The underlying table structure would be something like the attached picture (simplified, of course).

    Post back if you need more help; try to be as specific as possible.
    Attached Images Attached Images
    • File Type: png x.png (3.7 KB, 0 views)

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Adding Pages for new info ('97 / Access)

    Hans has captured the essentials - we built a complex system for a large company that does the same sort of thing, and we ended up with a one-to-many relationship between the Company table and the PlanYearEnd table. In the company table we carried a CurrentPlanYearEnd field so we could quickly pull up the current year, but using a subform, we let them go back as many years as they have history. Hope this makes sense - if not post back.
    Wendell

  6. #6
    New Lounger
    Join Date
    Mar 2003
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Pages for new info ('97 / Access)

    I'm not sure if I understand. I'm going to try and see if I get it. If not I will definetly post back to see if you would have any further input for me. I really appreciate you help. Thanks !

  7. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adding Pages for new info ('97 / Access)

    FYI, Hans, 1099s are US tax forms for other income payments that are filed with tax authorities by payors with copies sent to the payees.
    Charlotte

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Adding Pages for new info ('97 / Access)

    Thanks, Charlotte. I'll stay away from them.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Adding Pages for new info ('97 / Access)

    Hans, you have NO ambition! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •