Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatically completion of fields (2000)

    I don't know if what l want to do is possible, what l would like to do is to create a macro which allows me to put todays date into
    the "Reminder Sent" field then automatically place a date 7 days ahead in the Date follow up field.

    I would like to apply this to all the records in the datasheet view.


    see screenshot.

    Justin

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

    Re: Automatically completion of fields (2000)

    Does the form display ALL records in a table or query, or is it filtered?

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically completion of fields (2000)

    It displays all records in a query.

    Justin

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

    Re: Automatically completion of fields (2000)

    You can create a new query based on this query.
    Add the Reminder Sent and Date Follow Up fields.
    Select Query | Update Query.
    Enter <code>Date()</code> in the Update To line for the first column, and <code>Date()+7</code> in the last one.
    Save this query.

    To update, run this query, either interactively or from a command button on a form (using DoCmd.OpenQuery)

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically completion of fields (2000)

    I am a bit confused as to what you mean by the first bit:

    "Add the Reminder Sent and Date Follow Up fields".

    Can you elaborate for me.

    Thanks
    Justin.

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

    Re: Automatically completion of fields (2000)

    From your original question:
    <hr>put todays date into the "Reminder Sent" field then automatically place a date 7 days ahead in the Date follow up field.<hr>
    The two fields mentioned here should be added to the query design grid, for example by dragging them from the field list into the design grid. If you don't know what is meant by that, please study a beginner's book for Access.

  7. #7
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically completion of fields (2000)

    Sorry slight lapse in concentration. I know what you mean.

    Justin

  8. #8
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatically completion of fields (2000)

    That works great.

    Many thanks for that.

    Justin

Posting Permissions

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