Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Not sure (Access 2000)

    I just posted this, but it did not go for some reason....have a question from a past student that for some reason or 'nother...i'm at a loss for what hes asking...can you take a look...does anyone have an idea...

    QUESTION
    I have a an effective and a cancelled instruction form in the database.
    The forms do not have the same exact information because of the
    purposes of the forms. I would like to know if it would be possible when an
    effective instruction is cancelled if there is a way to have the information
    pertaining to that instruction transferred to the cancelled instruction
    records without having to do it manually?

    I know how to copy a record that has permanent information to a
    blank
    form without having to type the permanent information again, and I was
    hoping this could be done in the above instance also.

    END OF QUESTION

    thanks for looking at the question above...feedback if you've got a clue...
    NMP
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

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

    Re: Not sure (Access 2000)

    I would keep all instructions in one table, with a boolean Cancelled field. Create two queries based on the table, one returns all records with Cancelled = False (the effective instructions), and the other returns all records with Cancelled = True (the cancelled instructions). Use the first query as Record Source for the effective instructions form, and the second query as Record Source for the cancelled instructions form. Add a check box bound to the Cancelled field to the effective instructions form. By setting this check box, the user marks an instruction as cancelled; it won't be displayed in the form the next time it is opened (but it will be displayed in the cancelled instructions form). The two queries can also be used as Record Source for reports.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Not sure (Access 2000)

    Thank you Hans...
    Your help is "so" appreciated today...
    Having 3 Mondays in a row this week.
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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