Date Range IsLoaded Error

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top