Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

Simple Reminders

Discussion in 'Information Technology' started by Dustin, Nov 5, 2005.

  1. Dustin

    Dustin
    Expand Collapse
    Guest

    I need to make a simple reminder that will come up every morning when a
    person opens the database. I need it to look at a querie which I already
    have built, and just pop up a message box saying, that something needs to be
    done no details. I just can't seem to make my brain come up with a way to do
    it that works. I was thinking of using hasdata=true, but I'm not sure if it
    works for a querie. Has anyone ever tried this using say a macro
    --
    Dustin
     
  2. Loading...

    Similar Threads Forum Date
    Grammer / Vyakarn Learn Simple & Easiest Gurbani Vyakaran/grammer From Prof. Maninderpal Singh Language, Arts & Culture Mar 9, 2015
    General Babaji Ranjit Singh Dhandrian Wale, Simple living high Thinking Hard Talk Sep 27, 2013
    Sikh Weddings Simple? No, they Are Indulged In Brahmanwad Questions and Answers Sep 15, 2012
    The One-Minute Mystic: Simple Things You Can Do to Stay Connected Spiritual Articles May 23, 2011
    Being a Simple Sikh (blog of a Prithihardkaur Sikh) Spiritual Articles Sep 13, 2010

  3. Dustin

    Dustin
    Expand Collapse
    Guest

    ps. I have checked the forums, but everyone seems to want to link to outlook,
    and I don't need to go that far
    --
    Dustin


    "Dustin" wrote:

    > I need to make a simple reminder that will come up every morning when a
    > person opens the database. I need it to look at a querie which I already
    > have built, and just pop up a message box saying, that something needs to be
    > done no details. I just can't seem to make my brain come up with a way to do
    > it that works. I was thinking of using hasdata=true, but I'm not sure if it
    > works for a querie. Has anyone ever tried this using say a macro
    > --
    > Dustin
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Dustin wrote:
    >I need to make a simple reminder that will come up every morning when a
    > person opens the database. I need it to look at a querie which I
    > already have built, and just pop up a message box saying, that
    > something needs to be done no details. I just can't seem to make my
    > brain come up with a way to do it that works. I was thinking of
    > using hasdata=true, but I'm not sure if it works for a querie. Has
    > anyone ever tried this using say a macro


    I have not done it, but I would guess that you could on open extract the
    day (dd) from the date Date(). Then check that against a stored date and if
    equal, end procedure if not, then change the stored day to today's day and
    trigger your message. Of course if no one opened it up for a week it would
    not know that, but if that is a problem, that could be addressed as well.

    --
    Joseph Meehan

    Dia duit
     
  5. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Create a macro named Autoexec. In it put command OpenQuery. Have it open a
    query called MySus.
    Create a table called My_Sus.
    CMT – text – 255 characters
    Done – text – default “N†- Validation “Y†Or “Nâ€
    SusDate – datetime – default Date()+1 Sets date to tomorrow for
    all suspense but is easy to edit.

    The query has the fields with Date() as criteria on SusDate and “N†on Done
    field.

    You can have a form to enter new items and change from Done “N†to “Yâ€.


    "Dustin" wrote:

    > ps. I have checked the forums, but everyone seems to want to link to outlook,
    > and I don't need to go that far
    > --
    > Dustin
    >
    >
    > "Dustin" wrote:
    >
    > > I need to make a simple reminder that will come up every morning when a
    > > person opens the database. I need it to look at a querie which I already
    > > have built, and just pop up a message box saying, that something needs to be
    > > done no details. I just can't seem to make my brain come up with a way to do
    > > it that works. I was thinking of using hasdata=true, but I'm not sure if it
    > > works for a querie. Has anyone ever tried this using say a macro
    > > --
    > > Dustin
     
  6. Dustin

    Dustin
    Expand Collapse
    Guest

    I see where your going with the autoexec macro, and I like that part of it,
    But all I want to do is open a message box that says "you have blah blah
    blah" if the the select querie "WO Remind" returns a date <=Now(). I have
    tried putting that condition into the macro but I get an error that says it
    can't find the name of the querie. even though I selected it and the value
    from the menus in expression builder
    --
    Dustin


    "Joseph Meehan" wrote:

    > Dustin wrote:
    > >I need to make a simple reminder that will come up every morning when a
    > > person opens the database. I need it to look at a querie which I
    > > already have built, and just pop up a message box saying, that
    > > something needs to be done no details. I just can't seem to make my
    > > brain come up with a way to do it that works. I was thinking of
    > > using hasdata=true, but I'm not sure if it works for a querie. Has
    > > anyone ever tried this using say a macro

    >
    > I have not done it, but I would guess that you could on open extract the
    > day (dd) from the date Date(). Then check that against a stored date and if
    > equal, end procedure if not, then change the stored day to today's day and
    > trigger your message. Of course if no one opened it up for a week it would
    > not know that, but if that is a problem, that could be addressed as well.
    >
    > --
    > Joseph Meehan
    >
    > Dia duit
    >
    >
    >
     
  7. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    You will need to open the query.

    I think you can condition on any results of the query like a field Is Not
    Null.

    "Dustin" wrote:

    > I see where your going with the autoexec macro, and I like that part of it,
    > But all I want to do is open a message box that says "you have blah blah
    > blah" if the the select querie "WO Remind" returns a date <=Now(). I have
    > tried putting that condition into the macro but I get an error that says it
    > can't find the name of the querie. even though I selected it and the value
    > from the menus in expression builder
    > --
    > Dustin
    >
    >
    > "Joseph Meehan" wrote:
    >
    > > Dustin wrote:
    > > >I need to make a simple reminder that will come up every morning when a
    > > > person opens the database. I need it to look at a querie which I
    > > > already have built, and just pop up a message box saying, that
    > > > something needs to be done no details. I just can't seem to make my
    > > > brain come up with a way to do it that works. I was thinking of
    > > > using hasdata=true, but I'm not sure if it works for a querie. Has
    > > > anyone ever tried this using say a macro

    > >
    > > I have not done it, but I would guess that you could on open extract the
    > > day (dd) from the date Date(). Then check that against a stored date and if
    > > equal, end procedure if not, then change the stored day to today's day and
    > > trigger your message. Of course if no one opened it up for a week it would
    > > not know that, but if that is a problem, that could be addressed as well.
    > >
    > > --
    > > Joseph Meehan
    > >
    > > Dia duit
    > >
    > >
    > >
     
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