Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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


Reply With Quote
  #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 ????

Reply With Quote
  #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.
Reply With Quote
  #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 .


Reply With Quote
  #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.
Reply With Quote
  #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


Reply With Quote
  #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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 01:37 PM.


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