Results 1 to 5 of 5
  1. #1
    Jonk7273 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2015
    Posts
    8

    I am trying to send alerts once you log in and for email as well


    I am trying to send alerts on my database for people who have not returned their tools. The employees enter a date on when they will return the tool, if the tool is returned on the said date then all check boxes will clear and the record will be saved. If the tool is late by one day I need an alert to pop up every time the employee logs in, if the tool is late by two days then an email alert will be sent to the floor manager. please help...im a novice at this and I could very much use some assistance.

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    How are Users logging in? Do you have a form that opens by default? Maybe you could start by creating a statement or an expression that uses DLookup().

  3. #3
    Jonk7273 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2015
    Posts
    8
    Is there any step by step instruction that shows me how to do that? I am looking all over how to do that. I am also trying to do a multi user login where when the user logs in they will have there name and employee numbers displayed on the form so that they don't have to choose them every time they want to add a new record. it will already be there for them. please help...I really am a novice at this stuff.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I use MSDN. I called DLookup a function. So if you search for "DLookup Function Access2010" @ msdn.com, you will probably find what you need. I would recommend filtering the results to "Library" using the options in the left sidebar.

    The trick is using the correct term. I seem to find MSDN is classifying what used to be considered functions as Methods, now. So that can make things a little tricky. If you know Dlookup is a method of the Application Object, your search might look like "Application.DLookup Method Access2010"

    I would use this result ...https://msdn.microsoft.com/en-us/lib.../ff834404.aspx

  5. #5
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If the tool is late by one day I need an alert to pop up every time the employee logs in
    Then you need their login id, either from a sign-in form, or (my preference) use the fosUserName function (you can find it just about anywhere if you Google it). Those computer login id's need to be in a user table (along with FName, LName and whatever else you need). On startup, a query should run against their login id, looking for anything that is late, and the results passed to a recordset. Using this method, you can present a message box letting them know about the late return and any related data from that query (tool name, days overdue, whatever) if the recordset count >0. As for the email, you can use the SendObject method or use the more complex CDO. Sending mail via CDO is also something you can find code for. It's not affected by security prompts that require anyone to allow an application to send mail.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 05-07-2014, 09:25 AM
  2. Send automatic email alerts from access
    By RERM in forum Programming
    Replies: 5
    Last Post: 09-03-2013, 03:49 PM
  3. Send Alerts to Application user base
    By redbull in forum Programming
    Replies: 4
    Last Post: 04-15-2013, 11:00 AM
  4. Email Alerts when Due Date approaches
    By shariq1989 in forum Programming
    Replies: 0
    Last Post: 07-13-2012, 10:01 AM
  5. Replies: 4
    Last Post: 04-13-2011, 10:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums