Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

How do I set up mailings by dates?

Hello. I have a simple "Carpet Cleaning" Access database that I am
working on. It has a Billing Address, Site (of carpet cleaning),
Service Date and Details of Cleaning tables. My friend wants to be
able to send mailings to his customers. He also wants to be able to
have a way to control monthly, every 3 months, every 6 months, 9
month and yearly. (He asks the customer when they would like a
reminder for the next cleaning to be done.

I have "some" experience with VBA. I assume there must be some kind
of query I could use.

Thanks for your help.

Fred
jujutsu101@hotmail.com




Comments

  • gigsvoogigsvoo Posts: 328Member
    Just build an application, store the next reminder date in the last or new column inside the table.

    Everytime when the system runs, check the columns of date compare with the sytem date...

    : Hello. I have a simple "Carpet Cleaning" Access database that I am
    : working on. It has a Billing Address, Site (of carpet cleaning),
    : Service Date and Details of Cleaning tables. My friend wants to be
    : able to send mailings to his customers. He also wants to be able to
    : have a way to control monthly, every 3 months, every 6 months, 9
    : month and yearly. (He asks the customer when they would like a
    : reminder for the next cleaning to be done.
    :
    : I have "some" experience with VBA. I assume there must be some kind
    : of query I could use.
    :
    : Thanks for your help.
    :
    : Fred
    : jujutsu101@hotmail.com
    :
    :
    :
    :

    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


  • gigsvoogigsvoo Posts: 328Member
    Just build an application, store the next reminder date in the last or new column inside the table.

    Everytime when the system runs, check the columns of date compare with the sytem date...

    : Hello. I have a simple "Carpet Cleaning" Access database that I am
    : working on. It has a Billing Address, Site (of carpet cleaning),
    : Service Date and Details of Cleaning tables. My friend wants to be
    : able to send mailings to his customers. He also wants to be able to
    : have a way to control monthly, every 3 months, every 6 months, 9
    : month and yearly. (He asks the customer when they would like a
    : reminder for the next cleaning to be done.
    :
    : I have "some" experience with VBA. I assume there must be some kind
    : of query I could use.
    :
    : Thanks for your help.
    :
    : Fred
    : jujutsu101@hotmail.com
    :
    :
    :
    :

    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


Sign In or Register to comment.