Msgbox without input?

[perryche]

Is there a way to have a msgbox popup a message without users to click
ok and it will go away in 5s. I prefer to have this without creating
a form to replace the msgbox.

Thanks.
Perry

[Allen Browne]

No.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pe******@yahoo.comwrote in message
news:11**********************@n2g2000hse.googlegro ups.com...

Is there a way to have a msgbox popup a message without users to click
ok and it will go away in 5s. I prefer to have this without creating
a form to replace the msgbox.

Thanks.
Perry

[fredg]

On Sun, 15 Jul 2007 08:42:36 -0700, pe******@yahoo.com wrote:

Is there a way to have a msgbox popup a message without users to click
ok and it will go away in 5s. I prefer to have this without creating
a form to replace the msgbox.

Thanks.
Perry

Sorry, you'll have to create your own message form, and use it's timer
event to close itself.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Jasmin Terzic]

<pe******@yahoo.comwrote:

Msg ID: news:11**********************@n2g2000hse.googlegro ups.com...

Is there a way to have a msgbox popup a message without users to click
ok and it will go away in 5s. I prefer to have this without creating
a form to replace the msgbox.

Yes, and it`s so simple. Sorry me, but I think that 5 sec. is to much for
closing message box. Maybe you should try with 2 sec. ?

-----------
Dim oSHL As Object
Set oSHL = CreateObject("WScript.Shell")

Rem* Now, you must replace your standard message box with this one

oSHL.PopUp " -=This message will be closed by 5 seconds =-", 5,
"Informacija", vbInformation
-----------

--
Eli.

[Larry Linson]

Unless I misunderstand, this will require that the Windows Scripting Host be
available on the user's machine. Many people here avoid WSH solutions
because, often, the system administrators in companies not only remove them,
but search and startup for "rogue applications" which may have reinstalled
it.

They do this because WSH is a target for viruses and worms.

On the other hand, creating a simple form with a timer, all in Access, is
simple, straightforward, and not dependent on external software that may not
be installed.

Larry Linson
Microsoft Access MVP
"Jasmin Terzic" <dr***@on.babywrote in message
news:f7**********@news.albasani.net...

>
<pe******@yahoo.comwrote:

Msg ID: news:11**********************@n2g2000hse.googlegro ups.com...

>Is there a way to have a msgbox popup a message without users to click
ok and it will go away in 5s. I prefer to have this without creating
a form to replace the msgbox.

Yes, and it`s so simple. Sorry me, but I think that 5 sec. is to much for
closing message box. Maybe you should try with 2 sec. ?

-----------
Dim oSHL As Object
Set oSHL = CreateObject("WScript.Shell")

Rem* Now, you must replace your standard message box with this one

oSHL.PopUp " -=This message will be closed by 5 seconds =-", 5,
"Informacija", vbInformation
-----------

--
Eli.

[perryche]

OK, then, another similar question:

Is there a way to have a message popup ontop of all windows (not only
in Access, but ontop of other windows) to give users a warning
message?

Perry

[Jasmin Terzic]

"Larry Linson" <bo*****@localhost.notwrote:

Msg ID: news:dRAmi.1893$gC5.909@trnddc04...

Unless I misunderstand, this will require that the Windows Scripting Host
be available on the user's machine.

No, on this PC I have installed just WinXP SP2 + M$ Office 2003 (full
version) and nothing else. This code working ok.

They do this because WSH is a target for viruses and worms.

Yes, I understand. So, what you think about "Status" field in forms?
Example, all my forms doesn`t have a MsgBox, but have a little "status
field" who send information about errors, status, example info about fields,
or something else to operators who work with form.

This is a little example (picture) when "MyStatusField" is on the top of
form.

http://img249.imageshack.us/img249/7...usfieldoj2.jpg

So, what do you think, is that a right answer? :)

--
Eli.

[Jasmin Terzic]

"Jasmin Terzic" <dr***@on.baby>
Msg ID: news:f7**********@news.albasani.net...

This is a little example (picture) when "MyStatusField" is on the top of
form.
http://img249.imageshack.us/img249/7...usfieldoj2.jpg

It`s a little "My status field" form for testing:

Link: http://www.sendspace.com/file/5wprpr

--
Eli.

[Allen Browne]

In later versions of Access, you could try:

MsgBox "Say what?", vbSystemModal

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<pe******@yahoo.comwrote in message
news:11*********************@n60g2000hse.googlegro ups.com...

OK, then, another similar question:

Is there a way to have a message popup ontop of all windows (not only
in Access, but ontop of other windows) to give users a warning
message?

Perry