[AccessD] Using progress meter for queries

In case it wasn't clear, I'm referring to the built-in progress meter in the
Status Bar (must have Display Status Bar option = true in Access settings). 

If I was inserting records in a DO LOOP, the progress meter commands would
look like this...

SysCmd acSysCmdInitMeter, "Importing from LP_Customer...", NumRecs
'Initialize the progress meter...
RecNum = 0
Do While Not rFrom.EOF
   RecNum = RecNum + 1
   SysCmd acSysCmdUpdateMeter, RecNum 'Update the progress meter
   {append data here}
   rFrom.movenext
LOOP
SysCmd acSysCmdRemoveMeter 'Remove the progress meter


So what I'm asking is, is there a way to utilize the same progress bar to
monitor an append query?

Thanx,
Darrell


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Saturday, June 25, 2011 9:51 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Using progress meter for queries


  Within a standard JET workspace no, as queries are always a synchronous
operation.  You can however do it in a ODBC Direct workspace, which allows
for asynchronous queries.

  What exactly is the situation that you have?

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darrell Burns
Sent: Friday, June 24, 2011 06:38 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Using progress meter for queries

Is there a way to hook the progress meter to an append query?

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com