Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2000
    Thanked 0 Times in 0 Posts

    Auto reminder (2000 SP1 / 2002)

    I am only a beginner at this, so please be kind!
    I have made a database, the purpose of which is to track our society's members and, specifically, to record their passwords for access to our web pages.

    I have a field for expiry date of their membership, and I would like Access to automatically remind me when a membership has expired, so that I can withdraw their password, preferably without having to start access up. Is this possible?


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Auto reminder (2000 SP1 / 2002)

    Access is not a server database system, so if Access is not running (or if it is, but the database is not open), it can't notify you. You can have the database check for expired memberships when it is opened. There are several ways to do this; perhaps the following is the simplest:
    <UL><LI>Create a query that selects members whose membership has expired.
    <LI>Create a form based on the query (you can use one of the Form Wizards to design it if you like).
    <LI>Set this form to be the startup form in Tools | Startup...[/list]Post back if you need more help.

Posting Permissions

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