Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Msg Box Format (2003)

    Hi folks - when I'm generating message boxes, is there a format I can use which just flashes up and disappears as my code goes through and does not require the user to click "OK"?? Thanks!

    Ina

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Msg Box Format (2003)

    No, a message box requires user input.

    As an alternative, you can display text in the status bar of the Access application window:

    SysCmd acSysCmdSetStatus, "This is my status bar text"

    to set the text, and

    SysCmd acSysCmdClearStatus

    to remove the text you set.

    Or you could display a small form with its Popup property set to True. Say you have a form frmMessage with a label lblMessage. Code to display the form looks like this:

    ' Open the form
    DoCmd.OpenForm "frmMessage"
    ' Set the caption of the label
    Forms!frmMessage!lblMessage.Caption = "Please wait a moment."
    ' Force the form to be displayed fully even while code is running
    Forms!frmMessage.Repaint

    You can close the form again when you want to

    DoCmd.Close acForm, "frmMessage", acSaveNo

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Msg Box Format (2003)

    Another alternative would be to have your own pop-up box, in which you could pass the message as part of openargs. Set the timer interval for say 3000 (3 seconds), and close the form in the timer event.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Star Lounger
    Join Date
    Jul 2006
    Posts
    96
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Msg Box Format (2003)

    Thanks for your suggestions - great help!

    Ina

Posting Permissions

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