IsLoaded Error Date Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2000. Database is based on my employee's work log. One table, named
Tasks with
rows of TaskID, Task, Notes and StartDate. I have entered test data for
different dates to test out the database. I have a report that can print out
the entire database and a report that prints out only within a specific date.
Example, Between 04/01/2005 to 04/30/2005. Two forms, one for the Tasks and
the second one for entering the Report SDate Range. One query for the Tasks

Here is my problem, I want the Report SDate Range form to open when
accessing the report by date report, enter the two dates and the report
prints out the data between the two dates. When I attempt to access the
report, I get an Visual Basic Compile error: Sub or Function not defined.
Click Ok and it brings me to the following

Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "Report SDate Range", , , , , acDialog, "Tasks by
StartDate"
If Not IsLoaded("Report SDate Range") Then
Cancel = True
End If
End Sub

And "IsLoaded" is highlighted and the "Private Sub Report_Open" line is in
yellow.

I did try to follow the instructions from the following post
http://www.microsoft.com/office/com...orts&mid=a5b552df-114a-4f08-a64b-dd3c37437b52

But to no avail, I get the same thing.
 
Back
Top