Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9
This is the forum to discuss the Wrox book Expert Access 2007 Programming by Rob Cooper, Michael Tucker; ISBN: 9780470174029
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert Access 2007 Programming ISBN 978-0-470-17402-9 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 2nd, 2008, 04:36 AM
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


  #2 (permalink)  
Old May 5th, 2008, 01:09 PM
Authorized User
 
Join Date: Oct 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Any Clues about this error in the Monthly Calendar Report ????

  #3 (permalink)  
Old May 5th, 2008, 11:37 PM
Wrox Author
 
Join Date: May 2007
Location: , Washington, .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Maria,

Can you take the query that is created in the code and run it in a separate query to see if this works? I downloaded the sample code for the chapter and do not see the error.

Thanks!
Rob

Rob Cooper
Lead Software Design Engineer in Test
Microsoft Access Team

co-author: Access 2007 VBA Programmer's Reference
co-author: Expert Access 2007 Programming

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at microsoft.com/info/cpyright.htm.
  #4 (permalink)  
Old May 6th, 2008, 10:53 AM
Authorized User
 
Join Date: Oct 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Robb for your repply, I would try it as soon as I´ll arrive at home.
I´ve already try with another query and also with another fields, but the code stops at the same line with the same message

When the code tries to open the second recordset with the filter information the code stops responding .


  #5 (permalink)  
Old May 6th, 2008, 11:44 AM
Wrox Author
 
Join Date: May 2007
Location: , Washington, .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Unfortunately, I'm not sure why that is happening but am curious to see what happens when you try it on another computer. "P1" sounds like it could be a parameter that cannot be found perhaps?

Rob Cooper
Lead Software Design Engineer in Test
Microsoft Access Team

co-author: Access 2007 VBA Programmer's Reference
co-author: Expert Access 2007 Programming

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at microsoft.com/info/cpyright.htm.
  #6 (permalink)  
Old May 7th, 2008, 09:06 AM
Authorized User
 
Join Date: Oct 2007
Location: , , .
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Rob, thank you again for your kind Help, I´ve just run again the module createmonthlycalendar, and then insert the code inside the report., and it works !!

Thank you again ..
Maria


  #7 (permalink)  
Old May 7th, 2008, 11:43 PM
Wrox Author
 
Join Date: May 2007
Location: , Washington, .
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Maria,

Great job! Thanks for the update - glad to hear it's working.

Rob Cooper
Lead Software Design Engineer in Test
Microsoft Access Team

co-author: Access 2007 VBA Programmer's Reference
co-author: Expert Access 2007 Programming

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at microsoft.com/info/cpyright.htm.


Similar Threads
Thread Thread Starter Forum Replies Last Post
To solve the Exception in Monthly recurring events amoghgr C# 0 August 21st, 2007 06:21 AM
CH9 - Apache not using custom error page d2nash BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 3 June 20th, 2006 11:25 AM
Multidimensional array in ch9 willburke BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 November 2nd, 2004 04:44 PM
Shows monthly records leion General .NET 1 May 14th, 2004 07:34 AM
Desc sorted monthly report across several year Fehrer Access 11 February 7th, 2004 01:26 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.