Results 1 to 11 of 11
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Seeking best approach to auto reminder... (Access 2000)

    Hi,

    I have an employee DB. I want the DB to automatically remind me ( a month before the time) of employees whos Contract expiry dates are upcoming. Whats the best (easiest) approach to take.
    1. To have a report to filter these employees and have the macro open the report (if there are records).
    2. Or have a pop up dialog form to list exiry contract dates (which is a calculated field in a query) one month before the time???
    3. Any other bright (easy ) idea?

    Tx for any input...
    Regards,
    Rudi

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

    Re: Seeking best approach to auto reminder... (Access 2000)

    Whether you prefer to display a form or a report is up to your personal preference.

    Is this a database that you open every day?
    Does it remain open on a PC all the time?

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Seeking best approach to auto reminder... (Access 2000)

    Im just seeking the best and easiest approach. The DB will be opened every morning.
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Seeking best approach to auto reminder... (Acc

    Personally I would have a form/subform opening on autoexec which pops up on start up, it could be tied into a main menu or activated when navigating to a main form, my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    Jerry

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

    Re: Seeking best approach to auto reminder... (Access 2000)

    I agree with Jezza. You can either use an AutoExec macro that checks whether there are employess to be displayed and pops up a form/report if so, or set a form as startup form (in Tools | Startup...) and put similart code in its On Open or On Load event.

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Seeking best approach to auto reminder... (Acc

    Thanks guys....I will work on this approach and call again if I need some help.
    Cheers
    Regards,
    Rudi

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Seeking best approach to auto reminder... (Access 2000)

    Hi,

    I finally went this route...

    1. I created a query to filter the hiredate. ( Filter: >=Now() and <=DateAdd("m",1,Now()) )
    2. Then I created a little dialog popup form that lists the results of the filter
    3. Then a macro linked to the On Open Event of the Switchboard form (which opens at Startup)

    Works well....Tx to all the advice!


    PS: Is it possible to have the form show results without having to have the query as a saved object listed in the DB. Can I link the form to an SQL statement that is generated in memory to display the results on the form?? Will this run faster and take up less space in the DB??
    Tx
    Regards,
    Rudi

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

    Re: Seeking best approach to auto reminder... (Access 2000)

    You can set the Record Source property of a form to an SQL string, either in design view or in the On Open event of the form.
    The database engine that powers Access optimizes stored queries, so those will run faster than queries that are created on the fly. A stored query will take up a little bit more disk space, but not dramatically so.

  9. #9
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Seeking best approach to auto reminder... (Access 2000)

    Hmmn....a catch 22 scenario...6 of the one and half a dozen of the other... <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Tx for the advice and guidance!
    Regards,
    Rudi

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

    Re: Seeking best approach to auto reminder... (Access 2000)

    I don't think the extra disk space taken up by a stored query is relevant - it's in the range of kilobytes, not megabytes. If you have to worry about that, you have a problem anyway.

  11. #11
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Seeking best approach to auto reminder... (Access 2000)

    True.... <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Cheers
    Regards,
    Rudi

Posting Permissions

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