Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

EVENT OR REMINDER???

Discussion in 'Information Technology' started by ANGELICA, Jul 28, 2006.

Tags:
  1. ANGELICA

    ANGELICA
    Expand Collapse
    Guest

    Hi all,
    I have a table of clients who need to be visited on a certain time basis. I
    entered the date of the first visit and also the date when the next visit
    needs to be performed. However I'd like to have a pop-up window or a reminder
    or something that tells me 10 days in advanced of the upcoming visit. I
    should mention that I have not access to Mic. Outlook

    Any help will be greatly appreciated...BTW, My access skills are medium
    level.
     
  2. Loading...


  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    In a macro named Autoexec open a form based on query that has criteria of
    YourDateField - 10 <= Date() so it will pull all records due in 10 ldays or
    less.

    "ANGELICA" wrote:

    > Hi all,
    > I have a table of clients who need to be visited on a certain time basis. I
    > entered the date of the first visit and also the date when the next visit
    > needs to be performed. However I'd like to have a pop-up window or a reminder
    > or something that tells me 10 days in advanced of the upcoming visit. I
    > should mention that I have not access to Mic. Outlook
    >
    > Any help will be greatly appreciated...BTW, My access skills are medium
    > level.
     

Share This Page