Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2012
    Posts
    1

    Smile Unanswered: how to set alarm prior to 60 days of expiry date

    Dear all,
    I am new to ms access. My question might be humorous and a simple thing. But I don't know how to.

    I have a db including ID Card and its expiry date in another field. The card should be renewed in time. In this case how to inform my client though email 60 days before it expires?

    Any help is appreciated. Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    run a process which compares the expiry date to the threshold
    how or where you run thsat process is upto you

    you could do it every time the user logons on and tell 'em there and then
    you could do that as an overnight batch process, generating an email
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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