View Single Post
  #1 (permalink)  
Old May 2nd, 2008, 04:36 AM
mruschetti mruschetti is offline
Authorized User
Join Date: Oct 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error in Monthly Calendar Report (Ch9)

Whenever I tried to open the monthly Calendar Report an error pops up saying that " The Microsoft Access Database engine could not find the object "P1", When I click on Debug , the program stos at this line:

' fill the control values with data from the recordset
    For Each c In Me.Controls
        If (TypeOf c Is TextBox) Then
            If (Not IsNull(c.Value)) Then
                ' filter the recordset
                rs.Filter = "[Order Date] = #" & c.Value & "#"
                Set rs2 = rs.OpenRecordset()

The report ask you to input a start date , I´ve just enter 01/01/2006, any ideas ?.

Thank you

Reply With Quote