hi Liz,
> "acSysCmdUpdateMeter only accept an integer as an argument? "
If I recall right, it is initialized with the number of records. Then the update get the number it is on -- long integer. when I posted before, I was thinking the update got a percentage, which works if it is initialized with 100. To tell the truth, I really can't remember much about it right now.
Its been a long time since I did it that way. I have to look up my code
hang on a few hours ... got my code documenter done (except now I am running it on a locked down database and hopefully making a way to get to it by modifying a copy and analyzing the copy). I gotta quit adding whistles and bells like clicking on column headers to sort and calculating extra stuff like %executable lines. After this, I'll run it on some of my old databases and get a snippet for you ;) Unfortunately, I didn't index my stored snippets on this topic by anything I can remember now. Maybe someone else will jump in sooner
Warm Regards,
Crystal
Microsoft MVP
remote programming and training
Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: Liz Ravenwood
Crystal, does this acSysCmdUpdateMeter only accept an integer as an argument? I want to write out a whole line of text because I want to indicate which specific query I'm running at the time.
Liz Ravenwood
-----Original Message-----
From: Crystal
Hi Liz,
after you initialize the meter with your message, you need to update the meter yourself so the progress bar moves ;)
SysCmd acSysCmdUpdateMeter, nPercentDone
I put this in a loop -- well actually I wrote my own progress meter on my PleaseWait form -- but I used to use SysCmd
Warm Regards,
Crystal
Microsoft MVP
remote programming and training
Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: Liz Ravenwood
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
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar