Results 1 to 12 of 12
  1. #1
    Join Date
    Dec 2010
    Posts
    6

    Unanswered: Adding confirmation response

    I'd have a database with a "submit" button and would like to send a "confirmation" when the record is submitted. Something that says "your submission is confirmed"

    Can this be done?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Do you mean send an email? If so, the simplest way is probably SendObject. Others include automation and CDO.
    Paul

  3. #3
    Join Date
    Dec 2010
    Posts
    6

    Adding confirm button

    When the employee clicks on the "submit" button, I would like to send a message "submission confirmed" which would pop up on the window of the db file.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Try

    MsgBox "submission confirmed"
    Paul

  5. #5
    Join Date
    Dec 2010
    Posts
    6

    Adding confirm button

    Thanks....how do I do that?

  6. #6
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Add that line to the code behind the button. If the button calls a macro, add a message box line to the macro.
    Paul

  7. #7
    Join Date
    Dec 2010
    Posts
    6

    Thank you!

    Paul, thank you so much!

  8. #8
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Happy to help, and welcome to the site by the way!
    Paul

  9. #9
    Join Date
    Dec 2010
    Posts
    6

    New question

    I'm having difficulty with two commands. The "Submission confirmed" works beautifully. However, the two don't seem to be working. I'm using the data entry "yes" to bring the user to the next record. It works without the "submission confirmed" is not used but will not work with it when used.

  10. #10
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    First display the message then move to the new record.
    Have a nice day!

  11. #11
    Join Date
    Dec 2010
    Posts
    6

    new message

    How is that done?

  12. #12
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    BTW I'd be very careful about adding such a message, make certain your users are happy with that as a design stylistic. my experience is that most users do not want such a popup box on success. by all means use pop ups whn there has been a fail, but masses of pop up boxes can be a distraction, if the users are seriously good at data entry then they don't want to have to wait for the pop up to be drawn.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •