Share via

Access Date Reminder

Anonymous
2012-06-12T19:55:40+00:00

Hi Everyone,

I was wondering if you could help me out here. I'm pretty good with everything in Microsoft Access 2010, but the one thing I have no clue what to do is something I was just asked to do.

We keep a database of equipment, and each year it has to be registered, but the boss would like a notification to show up everyday prior to 30 days when the registration needs to be completed, and the notification will only go away when the date has been updated (registration renewed).

I have a date field ready, I just need to know how to do the registration alert whenever Microsoft Access is opened.

Seeing as I am fairly new at this, whoever helps me, could you make it as basic to understand for a newby? I'd really appreciate anything you can do to help.

Thanks,

Matthew

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. ScottGem 68,810 Reputation points Volunteer Moderator
    2012-06-13T11:55:29+00:00

    The problem here is we don't know the structure of your database. Do you store the date that registration was last renewed or the date that it expires. That is a key piece of information.

    What you need is two fold. First you need a query that returns all pieces of equipment that need to be registered in the next 30 days. So you need criteria that will return those records. You can use the DateAdd function and return all records where the current date is greater than 30 days prior to the registration date. But without knowing how you know the registration date, we can't give you the correct expression.

    The second part is running this query. I would create a report based on the query and run it as needed. However, if you want to run it automatically, that's a different story.

    10+ people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-06-12T20:36:05+00:00

    I think all you need is a Reminders form to display the equipment and date needed to renew by.  THe form could then be based on a query something like:

    SELECT equipment, DateAdd("yyyy", 1, [registration renewed]) As DueDate

    FROM equipmenttable

    WHERE DateDiff("d",  Date(), DateAdd("yyyy", 1, [registration renewed])) <= 30

    1 person found this answer helpful.
    0 comments
  2. ScottGem 68,810 Reputation points Volunteer Moderator
    2012-06-18T12:06:09+00:00

    What John said. But you really didn't give us enough info to answer you. 

    Does this database get used daily? Is it opened frequently during the day? Or what?

    0 comments
  3. Anonymous
    2012-06-16T05:04:17+00:00

    I take it that the expiration date field is updated when the registration is in fact renewed? Because you need both facts - that the registration is coming due, and that it has not been renewed.

    It's really easy to create the query if you know the structure of the table - which you do and we don't; but it would have something like a criterion of

    < DateAdd("d", 30, Date())

    on the renewal date field, and some appropriate criterion on whatever field indicates that the renewal has in fact been done (perhaps IS NOT NULL, or a similar date criterion, or something which you can see but we cannot).

    You could open a Form based on this query as - or from - the Startup form of your database, and close it immediately if it has no data.

    0 comments
  4. Anonymous
    2012-06-16T03:51:00+00:00

    Hi Scott,

    The database stores the date that it expire. And it needs to be automatic, knowing the woman who renews the registration would easily forget. (Sometimes she can be a little forgetful, so this is why I finally just decided to create this database so she wouldn't be able to forget as easily.

    Anything to help, I would greatly appreciate.

    Thanks,

    Matthew

    0 comments