Timer

[saurabh.mandal]

Hii guys,
I need some help regarding the timer function.
I want to compare the time of results obtained by filest and timest
fuctions.
Can anyone suggest how do i do it.

Thx
saurabh

 

[Douglas J. Steele]

I have no idea what "filest and timest fu[n]ctions" are, but if you're
asking how to time events, take a look at my April, 2004 "Access Answers"
column in Pinnacle Publication's "Smart Access". You can download the column
(and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[John Nurick]

Hi Saurabh,

The usual Access libraries don't include functions called timest or
filest, and I don't know what you're trying to do. If you type
Timer
into the Help dropdown on the menu bar of the VB editor, you'll get
links to help on the VBA Timer function and the Access.Form.Timer
method. But neither of these have anything to do with comparing times.

To compare Access date/time values you can use the ordinary numeric
comparison operators. If you want the difference between them, use
DateDiff() or simple subtraction.