Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

The First Of Many Questions

Discussion in 'Information Technology' started by Strow, Oct 27, 2005.

  1. Strow

    Strow
    Expand Collapse
    Guest

    okay i am doing this very big project and i am going to need alot of
    help, i guess you will see me on this board alot over the next week or
    so. so, here my first question


    this is what i want to do


    ok i have a sent letter date field on a subform on my main form. what i

    want to do is say in 30 days from that date (we can call sendemaildate)

    it remind me to send the company it refers to an email. Then 14 days
    from that (telephoned date)it reminds me to call them. so i want to
    write something that will give me 30 days from sent letter date, and
    then 14 days after that generated date. So after the dates get
    generated and shown on my form, I want a report that says, things to do

    today, and they click on the button and todays date shows with a list
    of things they are supposed to do (ie email this company or telephone
    today)


    guys i really need help with this. there is alot of things that i want
    and need to do with this that i dont have the slightest clue how to do.

    i guess i could probably send the database out through gmail if anyone
    would like to take a look at it. I modified a service call management
    database templatae that i found on office online. Please i really need
    some help.


    jstrowbridge@sunsetsolutions.com or johnstrow@gmail.com


    thanks
    John
     
  2. Loading...

    Similar Threads Forum Date
    So Many Questions... New to Sikhism Jan 16, 2008
    Reglion Many Lives, Many Masters - A Case For Reincarnation? Book Reviews & Editorials Jun 6, 2016
    How many times? Blogs Oct 16, 2015
    How many different types of Sikhs are there? Sikh Sikhi Sikhism Jul 8, 2014
    India The many British connections to massacres of Sikhs Breaking News Mar 29, 2014

  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    Strow

    Take a look at queries.

    By the way, your data is not "in" the forms, they just show it. Your data
    is in the underlying tables. You'll want to look at how to use queries to
    list data in tables, and to massage/calculate.

    For example, to get a date one month after a date you have, you can use the
    DateAdd() function.

    --
    Regards

    Jeff Boyce
    <Office/Access MVP>

    "Strow" <johnstrow@gmail.com> wrote in message
    news:1130334223.035959.61240@g43g2000cwa.googlegroups.com...
    > okay i am doing this very big project and i am going to need alot of
    > help, i guess you will see me on this board alot over the next week or
    > so. so, here my first question
    >
    >
    > this is what i want to do
    >
    >
    > ok i have a sent letter date field on a subform on my main form. what i
    >
    > want to do is say in 30 days from that date (we can call sendemaildate)
    >
    > it remind me to send the company it refers to an email. Then 14 days
    > from that (telephoned date)it reminds me to call them. so i want to
    > write something that will give me 30 days from sent letter date, and
    > then 14 days after that generated date. So after the dates get
    > generated and shown on my form, I want a report that says, things to do
    >
    > today, and they click on the button and todays date shows with a list
    > of things they are supposed to do (ie email this company or telephone
    > today)
    >
    >
    > guys i really need help with this. there is alot of things that i want
    > and need to do with this that i dont have the slightest clue how to do.
    >
    > i guess i could probably send the database out through gmail if anyone
    > would like to take a look at it. I modified a service call management
    > database templatae that i found on office online. Please i really need
    > some help.
    >
    >
    > jstrowbridge@sunsetsolutions.com or johnstrow@gmail.com
    >
    >
    > thanks
    > John
    >
     
  4. Strow

    Strow
    Expand Collapse
    Guest

    okay jeff so far so good. Now i want to create a report that will only
    show things that need to happen on the date the report is generated.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page