Thanks! I'll check this out.
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of acravenrohm
Sent: Saturday, January 28, 2012 1:18 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: syscmd and running queries
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.
>
------------------------------------
Yahoo! Groups Links
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