Results 1 to 7 of 7
  1. #1
    nichmeg is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    31

    check box notification


    I have a check box in my form and want to know if there is a way to have an email sent when ever the box is checked?

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Does this work for you?


  3. #3
    nichmeg is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    31
    Ill give it a go and see if it works. Thanks

  4. #4
    nichmeg is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    31
    It kind of worked. It opens an email dialogue box, but if the message is closed out a runtime error '2501' message - the sendobject action was cancelled occurs and stops the database to debug it. How can I have the database still run even if the email message box is closed. The code was pulled from the site that was noted above:
    Private Sub Command164_Click()

    DoCmd.SendObject _
    , _
    , _
    , _
    "sample@email.com", _
    , _
    , _
    "My drawing update", _
    "Message", _
    True

    End Sub

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,947
    I would add error trapping and do whatever you want with that error:

    http://www.baldyweb.com/ErrorTrap.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    nichmeg is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    31
    that worked, thanks

  7. #7
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,947
    Happy to help.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Just a check......
    By confidego in forum Access
    Replies: 7
    Last Post: 07-19-2011, 11:13 AM
  2. Check for no value
    By jgelpi16 in forum Programming
    Replies: 12
    Last Post: 07-29-2010, 02:53 PM
  3. To check or Un-Check all Boxes in a form
    By devcon in forum Forms
    Replies: 7
    Last Post: 05-01-2010, 12:03 AM
  4. Check Box Value
    By mulefeathers in forum Programming
    Replies: 4
    Last Post: 10-09-2009, 08:31 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