November 19, 2008 02:34am pst

1. capricorn1 1,164,378
2. LSMCons... 643,742
3. boag2000 584,207
4. DatabaseMX 439,605
5. peter57r 402,190
6. harfang 277,504
7. matthews... 220,454
8. jimhorn 192,522
9. TextReport 132,746
10. MikeToole 120,513
11. omgang 115,275
12. frankytee 99,014
13. koutny 94,835
14. GRayL 90,855
15. angelIII 90,320
16. irudyk 89,074
17. LennyGray 81,272
18. mbizup 79,933
19. Rick_Ric... 79,617
20. hnasr 76,855
21. cactus_d... 71,848
22. JDettman 69,055
23. eghtebas 68,487
24. jmoss111 68,371
25. rorya 64,932

1. capricorn1 1,785,223
2. LSMCons... 875,861
3. DatabaseMX 742,330
4. peter57r 639,699
5. boag2000 624,119
6. harfang 459,052
7. jimhorn 388,512
8. matthews... 369,718
9. jefftwilley 353,737
10. mbizup 275,650
11. frankytee 234,267
12. MikeToole 225,563
13. stevbe 222,014
14. omgang 187,510
15. GRayL 176,661
16. rockiroads 166,783
17. LPurvis 144,870
18. JDettman 138,915
19. angelIII 133,378
20. TextReport 133,246
21. ragoran 112,130
22. koutny 109,860
23. dqmq 106,796
24. Rick_Ric... 103,217
25. eghtebas 96,062

09.12.2008 at 03:50AM PDT, ID: 23725904

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.7

Access to the millisecond (article). Examples?

Asked by cactus_data in Access Coding/Macros, Microsoft Access Database

Tags: Access, VBA

Ever wondered if it can be done? It can.

The idea came one day where I wondered why SQL Server presents a time resolution of 3 ms while Access/VBA/JET only offers 1000 ms, both using the same underlying data type of double. So what was the resolution of double really? Much to my surprise, I found out that the resolution is 1 ms (or better) in the full range of data type date/time - from 100-1-1 00:00:00.000 to 9999-12-31 23.59.59.999.

Then I created the functions needed to generate and read time values with milliseconds and to create a set of functions handling milliseconds that mimic the full range of the well-known date/time functions of Access/VBA. One of the challenges was to get the calculations with doubles right avoiding bit errors. This was solved by switching to data type decimal at some critical places.

Finally Susan Harkins wrote it up. So (shameless plug):

http://www.devx.com/dbzone/Article/39046

Below is the list of functions.

Anyone having a good example for practical use of milliseconds?

/gustav

Start Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:

           
           
             Msec() is the core function. It generates the current time with millisecond resolution and returns current (local) date/time, including millisecond. 
DatePartMsec() extracts milliseconds or decimal seconds, as well as all the standard date/time parts from a date/time value. 
DateAddMsec() adds milliseconds or decimal seconds, as well as all the standard date/time intervals to a date/time value. 
DateDiffMsec() calculates the difference in milliseconds or decimal seconds between two date/time values. 
MsecDiff() returns the difference in milliseconds between two date/time values. 
TimeMsec() returns current (local) date/time, including millisecond as a time value that includes milliseconds. 
NowMsec() returns current (local) date/time, including millisecond as a full date/time value that includes milliseconds. 
TimerMsec() returns count of seconds from midnight with millisecond resolution. 
Millisecond() returns the millisecond part from a date/time value. 
SecondMsec() returns the second and the millisecond from a date/time value as a decimal value. 
MsecSerial() returns the date/time value of a numeric (double) input rounded to integer milliseconds relative to a base date. 
TimeSerialMsec() returns the date/time value of the combined parameters for hour, minute, second, and millisecond. 
MsecValueMsec() extracts the millisecond time part from a string expression. 
ExtractMsec() returns millisecond the date/time value from the last digits of a string. 
CDateMsec() converts a date/time expression including millisecond to a date/time value. 
CVDateMsec() converts a date/time expression including millisecond or a number to a date/time value. 
IsDateMsec() checks an expression if it represents a date/time value with or without a millisecond part. 
DateValueMsec() cleans a string for a time part including milliseconds. It also returns the date value of the string. 
TimeValueMsec() cleans a string for a millisecond part. 
StrDateFull() returns a date/time value formatted as to the current settings for Short Date and Long Time with trailing milliseconds formatted as a fixed-length numeric string. 
StrDateMsec() returns milliseconds of a date/time value as a "000" formatted string. 
FormatMsec() returns a value as a string formatted with milliseconds or any other value using Format. 
StrDateIso8601Msec() returns a value as a string formatted with milliseconds according to ISO-8601. 
DateSumDates() adds or subtracts partial date/time values to create a compound date value. 
TimeSerialFull() returns correct numeric negative date/time values, which TimeSerial() does not. 
DateValid() returns invalid numeric negative date/time values less than one day as their positive equivalents. 
DateLinear() converts a native date/time value and returns the linear date value. 
DateNative() converts a linear date value and returns the native date value. 
DateMsecSet() rounds off a date/time value to the second and optionally adds specified millisecond part up to and including 999 milliseconds. 
SplitDateMsec() splits a date/time value into its components of date/time and millisecond as date/time values. 
JoinDateMsec() joins an array of date/time and millisecond as date/time values to a compound date/time value. 
DateSort() returns a continuous value including milliseconds that can be sorted on correctly even for negative date values. 
DateTimeRound() returns a date/time rounded off to the second by removing a millisecond portion. 
DateTimeRoundMsec() returns a date/time value rounded to the nearest millisecond approximately by 4/5.

           
         

Keywords: Access to the millisecond (article). …

	Title
1	Track task duration with debug.print n…
2	Timestamp in milliseconds
3	the Jet VBA file
4	jet VBA file error
5	Science vs Religion Article
6	Jet VBA File Error

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Access to the millisecond (article). Examples?

Asked by cactus_data in Access Coding/Macros, Microsoft Access Database

Tags: Access, VBA

About this solution