A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

No one got an answer ???



 
 
Thread Tools Display Modes
  #1  
Old August 26th, 2004, 02:17 PM
Big Al
external usenet poster
 
Posts: n/a
Default No one got an answer ???

Message origionaly sent on the 16th August 2004

StopWatch,
can I use this (On THe Same Form)to calculate how long a
query runs???????
  #2  
Old August 26th, 2004, 02:24 PM
stefan hoffmann
external usenet poster
 
Posts: n/a
Default

hi Big Al,

Big Al wrote:
StopWatch,


Digital wris****ches are a great thing, hu?

can I use this (On THe Same Form)to calculate how long a
query runs???????


Declare Function GetTickCount Lib "kernel32" () As Long

Dim TC As Long
TC = GetTickCount
DoCmd.RunQuery ""
Debug.Print GetTickCount - TC

Gives the running time in miliseconds.

-- stefan --
  #3  
Old August 26th, 2004, 03:14 PM
Big Al
external usenet poster
 
Posts: n/a
Default

Thanks Stefan !!
-----Original Message-----
hi Big Al,

Big Al wrote:
StopWatch,


Digital wris****ches are a great thing, hu?

can I use this (On THe Same Form)to calculate how long

a
query runs???????


Declare Function GetTickCount Lib "kernel32" () As Long

Dim TC As Long
TC = GetTickCount
DoCmd.RunQuery ""
Debug.Print GetTickCount - TC

Gives the running time in miliseconds.

-- stefan --
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Easy ??.... but I can't find the answer PPerez Setting Up & Running Reports 1 July 16th, 2004 09:10 PM
need an answer quick about charts K1s0s General Discussion 1 June 12th, 2004 04:15 PM
**Trying to use answer from another formula cell in another formula KIMBERLY Worksheet Functions 1 April 27th, 2004 06:22 PM
Problem with formula using an answer of another cell formula KIMBERLY Worksheet Functions 4 April 23rd, 2004 08:15 PM


All times are GMT +1. The time now is 05:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.