Results 1 to 3 of 3
  1. #1
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34

    Expression builder - opened date matches today's date - send an email

    Hi guys,



    Need help with an expression I need to write in the expression builder

    I have a field (column) called 'Opened Date' (dd/mm/yyyy hh:mm:ss) as part of a form. I want to write that if someone opens a ticket and the date/time is with today's, an email notification should be sent via outlook.

    Also.. my table is not being recognised (it is under 'Supporting Objects').

    Can anyone advise?

    Thanks!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,986
    set the text box property DEFAULT = NOW()
    then you can send the email...
    docmd.SendObject....

  3. #3
    rayted is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2016
    Posts
    34
    Hi ranman256, but it is part of a macro I am building? not a text box as such

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

Similar Threads

  1. Send Email after updating a date
    By tcheck in forum Access
    Replies: 4
    Last Post: 08-31-2017, 12:24 PM
  2. Replies: 1
    Last Post: 10-08-2015, 02:20 PM
  3. Replies: 5
    Last Post: 01-12-2015, 07:41 PM
  4. Replies: 5
    Last Post: 10-12-2012, 11:00 AM
  5. Using expression builder to find lowest date
    By MMcKenna in forum Queries
    Replies: 1
    Last Post: 03-20-2012, 02:28 PM

Posting Permissions

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