Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 January 5th, 2006, 01:25 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error on previewing a Report

Hi experts,
I would like to stop the dialog "asking for a parameter" when opening
a report, once the parameter asked is included on the record source
of the report. The problem came up after i exported a table to
a file which should not be excluded from the original Db. Trying
to correct the error by importing the tb from the file, the report
now asks for a parameter that should be of knowledge of it, once
i've provided it on the report source.
Rgds,happy new year,
P :(

Reply With Quote
  #2 (permalink)  
Old January 6th, 2006, 11:34 AM
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

A field in the report is using a control source that is not present in the underlying table or query; OR your underlying query is prompting for something. Either remove that control object out of the report OR remove the prompt from the underlying query.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #3 (permalink)  
Old January 6th, 2006, 01:40 PM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Greg,
Thanks for ur reply. I've checked the points u mentioned above. The report in
question is based on a solution that i would classify as experimental. I've
never seen on the books but i've find it useful till now when problems have
been found that ask for an answer. The report has a subreport that displays
some values on a horizontal line. As i need the sum of those values i've used
on the main report the same values displayed on a vertical line showing
only the totals of the sum, no details are needed. That means that main report
has a record source and subreport has a second source with the details of
the fields having the sums on the main report. Has anybody seen a report design
like that? Is the solution possible on the long run?
Penta

Reply With Quote
  #4 (permalink)  
Old January 7th, 2006, 05:41 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi again,
BTW the record source of the main report is a query with three related tables.
The parameter asked when i preview the report is TableA.CodeName which is
related to TableB.CodeName that is a must field for the query and determines
the CodeName that should show on the report. Although when i add TableA.CodeName
to the query it is excluded when i run the qry and the report asks for it
before it opens. What may be happening ?
P


Reply With Quote
  #5 (permalink)  
Old January 7th, 2006, 07:13 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

So Penta, Do I understand you are saying the query that underlies the report does not run? (Does it work when you rebuild it?)

Loralee

Reply With Quote
  #6 (permalink)  
Old January 8th, 2006, 07:44 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Loralee, the query runs Ok when opened from the qries window. Although the
report asks for a parameter when previewed from the reports window. If i add
the parameter asked to qry design, an error displays saying that i should specify the table from where the parameter should come on the SQL view. Going
to the SQL view u see that there is nothing to be added because every field
has the Table.Field.
P

Reply With Quote
  #7 (permalink)  
Old January 8th, 2006, 01:41 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

How irritating.
I had similiar behavior occur suddenly in an MDB for all reports that used the date function. I ended up using an older backup copy of the mdb and imported my tables with the latest data.
Do you by chance have a back up copy of your .mdb (prior to exporting the table) that has a healthy report in it that you could import your tables with updated data into? (I am assuming you are using the db and not just testing).

BTW, someone suggested looking in my report for unexpected textboxes and checking the Group-On settings to confirm there wasn't something goofy there. I assume you looked in those places.

Good luck,
Loralee

Reply With Quote
  #8 (permalink)  
Old January 9th, 2006, 06:17 AM
Friend of Wrox
 
Join Date: Aug 2004
Location: , , .
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Loralee,
I had a BU copy of the application that was used to solve the problem. But i'm
working on the repaired Db to see if i make it run again.
Again thanks, rgds
P

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
error report doubleb BOOK: Professional Ajax 2nd Edition ISBN: 978-0-470-10949-6 2 September 15th, 2008 01:15 AM
Previewing Multiple Reports PaulJH Access 1 August 15th, 2007 07:12 AM
Previewing your XSLT - What do you use? tripecac XSLT 3 May 3rd, 2007 05:45 AM
How to edit report data after previewing report twt Access VBA 2 April 14th, 2005 06:35 AM
Error While printing report (Crystal report) vikaspaweb Pro VB 6 0 March 8th, 2004 09:53 AM



All times are GMT -4. The time now is 06:56 PM.


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