Createobject.Popup Opens With "okay" Box, Access 2007

[David92595]

Hello,



I have borrowed a bit of code to open a popup box/message box (Not sure what the difference is), and it's working great. However, when it run, it opens with an Okay button in it. I need to get ride of the button, or hide it, ect

CreateObject("WScript.Shell").PopUp "A new version of the Database is available. " & vbCrLf & _
        "Please wait while your local copy is updated. " & vbCrLf & _
        "Once the update has completed this window " & vbCrLf & _
        "will close and then reopen automatically. ", 7, "New Database Version"

This run with our new auto Front End updater code.

I don't care if it is a message box, popup, I'd like to try to stay way from creating yet another form in our FE if at all possible. I know I can call a form to do what I need.

As always, any help is greatly apprechated.

Thank you,
David92595

[June7]

Can't get rid of the Okay button on popup MsgBox. If you could, would not be able to close it.

I have never seen this PopUp method. Why invoke Shell just for a message box?

[David92595]

Currently, this opens the message box, and waits 7 seconds before runing a cmd line script that updates the Front end. Clicking the okay button skips the 7 second wait. I think it's useful, my boss does not. So I'm looking for an alternative, hopefully one that doesn't involve creating yet another form.

David92595

[June7]

Okay, MsgBox does not have a 'wait' argument, PopUp is interesting alternative. There is no parameter in the button type argument for 'no button'.