By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,931 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,931 IT Pros & Developers. It's quick & easy.

Msgbox without input?

P: n/a
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

Jul 15 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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
Jul 15 '07 #2

P: n/a
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
Jul 15 '07 #3

P: n/a

<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.

Jul 15 '07 #4

P: n/a
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.

Jul 16 '07 #5

P: n/a
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

Jul 16 '07 #6

P: n/a

"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.

Jul 16 '07 #7

P: n/a

"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.
Jul 16 '07 #8

P: n/a
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
Jul 17 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.