Msgbox without input?

Msgbox without input?

Post by perrych » Tue, 17 Jul 2007 00:42:36


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
 
 
 

Msgbox without input?

Post by Allen Brow » Tue, 17 Jul 2007 00:48:10

No.

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

 
 
 

Msgbox without input?

Post by fred » Tue, 17 Jul 2007 02:05:52


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
 
 
 

Msgbox without input?

Post by Jasmin Ter » Tue, 17 Jul 2007 04:26:48


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

Msgbox without input?

Post by Larry Lins » Tue, 17 Jul 2007 11:36:57

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
 
 
 

Msgbox without input?

Post by perrych » Wed, 18 Jul 2007 00:43:42

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
 
 
 

Msgbox without input?

Post by Jasmin Ter » Wed, 18 Jul 2007 01:42:27


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


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://www.yqcomputer.com/

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

Msgbox without input?

Post by Larry Lins » Wed, 18 Jul 2007 05:04:24


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

WSH is installed by default with Windows and has to be removed, and often is
by company system administrators, some of whom also add programming at
startup to search and destroy loads of WSH that what they consider "rogue
software" has performed. Relatively few individuals go to that effort,
however.

> Yes, I understand. So, what you think about "Status" field in forms?

I have used various Satus indications in Forms, including the Status Bar at
the bottom of the Access window -- but the user may turn off the Status Bar.
They work very nicely, but they don't "grab the user's attention" like a
message box or substitute. I have also used a popup Form like a MsgBox, and
used its Timer to automatically close it after some period of time.


I think that is OK... if you have some status to which you want to
especially call attention, you could change the backcolor of that status
field. But, so the "attention" color isn't visible for long periods and
people thus stop paying attention to it, it is a good idea to change it back
to normal when the "attention item" has been dealt with or when a specified
period of time passes.

Regards,

Larry Linson
Microsoft Access MVP
 
 
 

Msgbox without input?

Post by Allen Brow » Wed, 18 Jul 2007 09:44:19

In later versions of Access, you could try:

MsgBox "Say what?", vbSystemModal

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