Determining the actual running time of external application in Access

[edmscan]

I would like to do the following ..



I want to run an external application (a batch file) ... and want to run it by clicking on a command button on a form. That part is all fine, using the Shell command. I can determine the start time of the application (also fine with now() function) .. but want to find out how long the external application ran and log that "run time" into my database.

The part I don't know about is the .. really the ending time. How do I determine how long the application really ran for / ended ? I imagine I can use datepart to determine the difference in the start and end times. Or would I use a timer control. (but I cannot find the timer control in Access 2010).

Thanks

[burrina]

Here are 2 examples;

GrandTotal: DateDiff("n",[StartTime],[EndTime])/60

For the Timer Function, you could use a module or code via the form using the OnTimerEvent.
Log the time when the counter started and when it finished.

HTH

[edmscan]

I found an example from Access 2007 that works .. with a bit of a tweak it will work for me. But thank for the above .. and yes I did mean DateDiff above not DatePart.

[burrina]

Glad you got it sorted out. Good Luck With Your Project.