Greetings, Cool idea!
I just about have an Progress Bar example built that I'll post to the site by 3:00 Eastern today. It's pretty easy to increment a progress bar based on the value of D.Record (current record the script is processing). What my example does is loop through till the end of the file to see how many records there are - there isn't a DataStation.GetNumberOfRecords property since the DataStation is designed to be generic to all sorts of files. The last record number before the end is the total number of records. This becomes the "end of the progress bar range". Popping up the user form with Show Modal set to False allows other things to happen while the progress bar is incrementing. As for a how long should this take metric. This will take a bit of work on both of our parts, since it will need a "Start the clock", "Stop the clock" for each record - I can do the math for you then to give you an estimated time of completion. This of course would be "dynamic" based on how long it took to work the last record - of course, one could get fancy and do averages etc. Regards, Thom From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thompson, Mary Sent: Tuesday, April 17, 2007 12:04 PM To: [email protected] Subject: RE: [Talk] Progress Bar Indicator This would be a great addition to many scripts! Mary Electronic email from Mary Thompson, <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED] Children's Mercy Hospitals and Clinics. This communication is intended only for the use of the addressee. It may contain information, which is privileged or confidential under applicable law. If you are not the intended recipient or the agent of the recipient, you are hereby notified that any dissemination, copy of disclosure of this communication is strictly prohibited. If you have received this communication in error, please immediately notify Children's Mercy Hospitals and Clinics at 816-234-3940 or via return internal electronic email at <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED] and expunge this communication without making any copies. Thank you for your cooperation. _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, April 17, 2007 10:52 AM To: [email protected] Subject: [Talk] Progress Bar Indicator I'm looking for a simple progress bar indicator to add to my script. I'm performing a dictionary update in Meditech from an Excel spreadsheet. I would like to progress bar to query the number of records in the spreadsheet to determine the how long it will take for the update to run and what % complete it is. Thanks, John Keefer Systems Analyst Highline Medical Center 16251 Sylvester Rd SW Burien, WA 98166 206.431.5373 Ext. 5399 [EMAIL PROTECTED] _____ This message, together with any attachments, is intended only for use of the individual or entity to which it is addressed. It may contain information that is confidential and prohibited from disclosure. If you are not the intended recipient, you are hereby notified that any dissemination or copying of this message or any attachment is strictly prohibited. If you have received this message in error, please notify the original sender by telephone or by return email and delete this message, along with any attachments, from your computer. Thank You.
