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

    Specified date entered automatically (2000)

    I don't if want if want to do is possible.
    I would like the "Date reminder due" date to be completed automatically when a record is entered automatically onto the database.
    Altought this date needs to be date of the coming Friday on the calender.
    see attachment.

    Justin.

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

    Re: Specified date entered automatically (2000)

    Set the Default Value property of the text box or of the field in the underlying table to

    <code>Date()+7-Weekday(Date(),7)</code>

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

    Re: Specified date entered automatically (2000)

    Is is possible to amend it slightly so that if the todays date is a Friday then to ignore this piece of coding.
    i.e the date reminder due field would remain blank?

    Jusitn.

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

    Re: Specified date entered automatically (2000)

    Use this as default value:

    <code>IIf(Weekday(Date())=6,Null,Date()+7-Weekday(Date(),7))</code>

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

    Re: Specified date entered automatically (2000)

    Thanks for that.

    Regards
    Justin.

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

    Re: Specified date entered automatically (2000)

    For some reason this does not appear to work, any ideas?

    Justin.

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

    Re: Specified date entered automatically (2000)

    PLEASE be specific. Doesn't it work, or does it just appear not to work? If it doesn't work, in what sense? Do you get an error value, or no value, or an incorrect value?

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

    Re: Specified date entered automatically (2000)

    My apologies Hans, l will be more specific in future emails.
    Nothing appears to work.

    Regards
    Justin.

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

    Re: Specified date entered automatically (2000)

    <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23> Would you please try to be REALLY specific? "Nothing appears to work" doesn't tell me anything. I repeat from my previous reply:

    Do you get an error value, or no value, or an incorrect value?

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

    Re: Specified date entered automatically (2000)

    No value appears in the "Date Reminder Due" field.

    Justin.

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

    Re: Specified date entered automatically (2000)

    Did you go to a new record? The Default Value property only applies to new records; it will not be used in existing records.

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

    Re: Specified date entered automatically (2000)

    My apologies l thought it would be used in existing records.
    It works fine now.

    Regards
    Justin.

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

    Re: Specified date entered automatically (2000)

    Since you wrote
    <hr>I would like the "Date reminder due" date to be completed automatically when a record is entered<hr>
    I assumed that you wanted the Due reminder date to be set when a new record was created.

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

    Re: Specified date entered automatically (2000)

    That is exactly what l wanted.

    Thanks very much for your help, please ignore the last thread.
    What l said was incorrect. Sorrt for any confusion.

    Regards
    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
  •