Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / December 2005

Tip: Looking for answers? Try searching our database.

need help on tracing FormatCount

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
homer - 19 Dec 2005 16:57 GMT
Last week, I got an advice from this forum on how to find out the performance
bottleneck of a report.
It suggests adding a debug.print in each on_format event for each section
with this syntax:
Section - FormatCount - TimeStamp(Now())

I have tried the following three ways, but none of them worked.

Private Sub PageHeader_Format(Cancel As Integer, FormatCount As Integer)
1) got argument is not optional compile error
debug.print Section - FormatCount - TimeStamp(Now())
2) and 3) got sub or function not defined error on Section
debug.print Section(acPageHeader) - FormatCount - TimeStamp(Now())
3)
Debug.Print Reports!Report_rptJJMain.Section(acPageHeader) & "-" &
FormatCount & "-" & timestamp(now())
End Sub

What did I do wrong? And thanks for your help!

TC - 19 Dec 2005 17:29 GMT
I don't know what the previous advice was, but the following code will
show the number of seconds between the two points:

dim secs as single
...
secs = timer  ' start timing.
... do things ...
secs = timer - secs  ' stop timing.
debug.print "elapsed time = "; secs; " seconds"

HTH,
TC
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.