Status Bar

[DJS]

In Table (Datasheet view) is it possible to change the status message ? I
view many forms in datasheet view and have a double-click routing on many
cells, ideally I'd like to show which query or macro is currently running,
in the status bar.
Thanks in advance !

 

[Brian]

Dim SBText As Variant
SBText = SysCmd(acSysCmdSetStatus, "yourQueryName")
DoCmd.OpenQuery "yourQueryName"
SBText = SysCmd(acSysCmdClearStatus)

 

[Brian]

Just a link for more info on SysCmd:

http://msdn.microsoft.com/library/d...en-us/vbaac11/html/acmthSysCmd_HV05186385.asp

 

[Wolfgang Kais]

Hello "DJS".

In Table (Datasheet view) is it possible to change the status message?
I view many forms in datasheet view and have a double-click routing
on many cells, ideally I'd like to show which query or macro is currently
running, in the status bar.

In a macro, use the Echo action, in vba, use DoCmd.Echo