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 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
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
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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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...
|
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...
| |