Welcome to SPN

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

Sign Up Now!

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
    > >
    > >
    > >
     

Share This Page