Sabtu, 28 Januari 2012

[MS_AccessPros] Re: syscmd and running queries

 

Oh, one more thought, I can't remember for sure as I stopped using the Statusbar for anything when Microsoft started advertising in the Runtime's Statusbar, but... it's possible that when the Query runs, that the Query progressbar replaces the text you entered while it's running.

--- In MS_Access_Professionals@yahoogroups.com, "acravenrohm" <yahoo@...> wrote:
>
> Hi Liz,
>
> it's not actually the acSysCmdInitMeter you need in order to display a text, use:
>
> Access.Application.SysCmd acSysCmdSetStatus, sStatusText
>
> (The "Access.Application." is only necessary if there's a chance a reference might be missing.)
>
> However, if your users are anything like my users, they won't notice anything written in the statusbar.
>
> Generally, a Progress Form gets noticed a great deal more than the statusbar but you may have reasons for avoiding a Progress Form and your users may be used to, or trainable to check for, information in the statusbar.
>
> --- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@> wrote:
> >
> > Greetings Pros,
> >
> > I am running queries and would like to use the status bar to indicate which query is running but all I'm getting is "running query" message.
> >
> > Here's what I'm trying to do:
> >
> > SysCmd acSysCmdInitMeter, "Appending data to ECO Tracker actions file... " & CStr(Now()), 0
> > Db.execute("appECOTracker")
> >
> >
> > Liz Ravenwood
> > Database Developer / Programmer
> > Super First Class Products
> > B/E Aerospace
> > O: 1.520.239.4808
> > www.beaerospace.com
> >
> >
> > This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
> >
>

__._,_.___
.

__,_._,___

Tidak ada komentar:

Posting Komentar