Results 1 to 7 of 7
  1. #1
    gclarid1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    3

    Save & New button - Email

    Just a quick one if anyone can point me in the right direction.

    Ive got a database which is like a ticket system is there anyway of setting up the the save and new button to send an email also instead of having to press the email button also.



    Click image for larger version. 

Name:	Capture.PNG 
Views:	15 
Size:	19.3 KB 
ID:	29490

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    We could use a little more information. What do you have behind each of these two buttons so they work?

  3. #3
    gclarid1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    3
    Thanks for getting back to me I'm pretty new too all this.

    but is this what you mean

    Save & New

    Click image for larger version. 

Name:	Capture1.PNG 
Views:	15 
Size:	12.4 KB 
ID:	29497

    Email

    Click image for larger version. 

Name:	Capture2.PNG 
Views:	15 
Size:	16.0 KB 
ID:	29498

    Email

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Yes, that is the description for which I was looking. I'm not efficient in macros so if you will convert them to code, I could help get the buttons to do what you want.

  5. #5
    gclarid1 is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    3
    Quote Originally Posted by RuralGuy View Post
    Yes, that is the description for which I was looking. I'm not efficient in macros so if you will convert them to code, I could help get the buttons to do what you want.
    Thanks for the reply

    I would like to click the save and new button and it would send an email also instead of having to click the email button before saving.

  6. #6
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Does the Save and New button work properly? Does the Email button work? If so, put both sets of commands into one macro. Otherwise convert them to code and we can assist you.

  7. #7
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Here's directions on how to convert the macro to code: https://btabdevelopment.com/how-to-c...macros-to-vba/

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

Similar Threads

  1. Replies: 3
    Last Post: 10-20-2014, 03:25 PM
  2. Replies: 5
    Last Post: 05-07-2014, 09:25 AM
  3. form - save entered data only with save button
    By cbrxxrider in forum Forms
    Replies: 3
    Last Post: 10-20-2013, 12:39 PM
  4. Replies: 3
    Last Post: 10-08-2012, 08:40 AM
  5. Save an email in an Access database
    By CindyR19 in forum Programming
    Replies: 2
    Last Post: 09-01-2011, 05:25 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
  •  
Other Forums: Microsoft Office Forums