473,324 Members | 2,239 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Report generated but prompts for parameter when printing

I have been asked to look at an Access application. It generates a
report successfully, so that you can see it on the screen with no
errors.

However, when you try to print it, the prompt dialog for missing
parameter is displayed.

Anyone any thoughts?

Sorry it's rather sort on detail, but I've been passed the details of
the problem by someone else. I'm expected to sort the problem on a
site visit and I don't know if I'll have Internet access on-site.

TIA

Edward

Oct 11 '06 #1
5 2384
Unfortunately, without much more information, the problem could be in many
different places. Here are a couple of the more likely ones. First run the
query and see if you get prompt. Then look in the Sorting and Grouping
dialog and see if there are any fields which are no longer in the data set.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<te********@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
>I have been asked to look at an Access application. It generates a
report successfully, so that you can see it on the screen with no
errors.

However, when you try to print it, the prompt dialog for missing
parameter is displayed.

Anyone any thoughts?

Sorry it's rather sort on detail, but I've been passed the details of
the problem by someone else. I'm expected to sort the problem on a
site visit and I don't know if I'll have Internet access on-site.

TIA

Edward

Oct 11 '06 #2
Wouldn't those conditions hold true even in preview mode?

How do you print the report? Via the print icon in Access or did you
code an option to print or preview? If so, perhaps there is a bad
where clause being passed when you choose print?

-Brian
Arvin Meyer [MVP] wrote:
Unfortunately, without much more information, the problem could be in many
different places. Here are a couple of the more likely ones. First run the
query and see if you get prompt. Then look in the Sorting and Grouping
dialog and see if there are any fields which are no longer in the data set.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<te********@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
I have been asked to look at an Access application. It generates a
report successfully, so that you can see it on the screen with no
errors.

However, when you try to print it, the prompt dialog for missing
parameter is displayed.

Anyone any thoughts?

Sorry it's rather sort on detail, but I've been passed the details of
the problem by someone else. I'm expected to sort the problem on a
site visit and I don't know if I'll have Internet access on-site.

TIA

Edward
Oct 11 '06 #3

BerkshireGuy wrote:
Wouldn't those conditions hold true even in preview mode?

How do you print the report? Via the print icon in Access or did you
code an option to print or preview? If so, perhaps there is a bad
where clause being passed when you choose print?

-Brian
That's what I thought. Obviously I'll take a look at Arvin's
suggestions, but my thinking (bearing in mind that I *didn't* write the
app., and in fact have never seen it!) is that if it gets as far as
generating the report on screen it's unlikely to be a problem with the
underlying query.

I'll post again when I've figured it out, or have more information.

Edward

Oct 11 '06 #4
Does the report contain a graph?

I have one with a parameter in the graph's source query that accepts my
input before the preview and repeats the prompt when printed.

<te********@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
I have been asked to look at an Access application. It generates a
report successfully, so that you can see it on the screen with no
errors.

However, when you try to print it, the prompt dialog for missing
parameter is displayed.

Anyone any thoughts?

Sorry it's rather sort on detail, but I've been passed the details of
the problem by someone else. I'm expected to sort the problem on a
site visit and I don't know if I'll have Internet access on-site.

TIA

Edward

Oct 11 '06 #5
Ignore what I wrote - the person who relayed the problem details was
misled.

The problem comes, as I suspected, when the report is actually being
generated on-screen. As Brian suggested, the report is being "Printed"
via a button, which simply opens the report.

The report contains a number of sub-reports, one of which contains a
text box with the following ControlSource:

=(Str([Quantity]))+(" no. "+[CutOutDescription])

When opening the report, the parameter would prompt for "Str"

This led me to think that there was either a References problem or a
Compilation problem. The References checked out, but the program
didn't compile. It barfed in the following sub:

Private Sub Text28_AfterUpdate()

Dim stDocName As String

stDocName = "qryEstimateTotals"
DoCmd.Requery stDocName, acNormal, acEdit

End Sub

The offending line is:

DoCmd.Requery stDocName, acNormal, acEdit

and the error is:

"Wrong number of arguments or invalid property assignment"

If I amend the line to:

DoCmd.Requery stDocName

all is well - the application compiles and doesn't prompt for a
parameter called Str!

What I want to know is:

How did anyone ever get the damn thing to work in the first place?
Please do bear in mind that I DID NOT write this - for a start, I never
leave my controls with their default names (e.g. Text28) And what is
the purpose, do you suppose, of the line

DoCmd.Requery stDocName, acNormal, acEdit

Thanks

Edward

Oct 12 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Lloyd Stevens | last post by:
I'm trying to create a report from two queries, one query displays which customers bought a particular product, the quantity and price using the "Enter productID" as parameter While the other is...
4
by: Sami | last post by:
I hope someone will tell me how to do this without having to do any VB as I know nothing in that area. I am a rank beginner in using Access. I have created a database consisting of student...
6
by: Mike Conklin | last post by:
This one really has me going. Probably something silly. I'm using dcount for a report to determine the number of different types of tests proctored in a semester. My report is based on a...
3
by: Bryan | last post by:
I've been looking over this newsgroup, but I can't find an answer to my problem. I see that a few others have posted this issue over the years, but none of them got a response. I'll give it...
1
by: Bill Nguyen | last post by:
Report source is an SQLSERVER 2K store procedure. VB.NET application. Report created by CR 8.5. At runtime, I still had to click "CANCEL" to bypass the parameter prompts before the report display...
6
by: fieldja | last post by:
I have a form called OwnerForm. It contains a combo box called Owner. The combo box looks up names from a table called OwnerName. It contains fields called OwnerID and Owner. I also have a main...
12
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to...
2
geolemon
by: geolemon | last post by:
I'm still relatively new to Access - this question is due to my moderate experience with forms and my complete and total lack of experience with reports. I want to create a report (I use that term...
25
by: DanicaDear | last post by:
I am trying my hand at my first ever Access report. It is based on a two parameter query (start date, end date). When I use the report wizard and click "view report" the report prompts me for the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.