I have a report with a sub report for an income / expense report for
church. My expense report is the sub report.
My question is, when I run the report, it prompts me 2-3 times for the
parameters of the expense report. Is there a way around this annoyance?
Thank you for your help.
Scott
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! 14 10633
How are you defining these parameters?
"Scott Gorman" <sg***@comcast. net> wrote in message
news:41******** **@127.0.0.1...
I have a report with a sub report for an income / expense report for church. My expense report is the sub report. My question is, when I run the report, it prompts me 2-3 times for the parameters of the expense report. Is there a way around this annoyance? Thank you for your help.
Scott
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
In the query, I have a column with the following entries.
Field- Month([Date])
Sort- Expression
Criteria- [Expense Report for month: 1-12: ]
When I run this query on its own, it works fine. The problem seems to be
when I have this query in my report as a sub report. It currently is
prompting me 2 times for this data. Not sure how I changed it, but it
was prompting me 3 times before.
Thanks,
Scott
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I'd suggest you take the criteria line out of the query.
Instead, put a textbox on your main form to enter the month you want.
Then use the LinkMasterField s and LinkChildFields properties of your subform
control to take care of your filtering.
"Scott Gorman" <sg***@comcast. net> wrote in message
news:41******** **@127.0.0.1... In the query, I have a column with the following entries.
Field- Month([Date]) Sort- Expression Criteria- [Expense Report for month: 1-12: ]
When I run this query on its own, it works fine. The problem seems to be when I have this query in my report as a sub report. It currently is prompting me 2 times for this data. Not sure how I changed it, but it was prompting me 3 times before. Thanks, Scott
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
I am not sure how to do that. Could you possibly help me to get that
started. I sure appreciate your help
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
"Scott Gorman" <sg***@comcast. net> wrote in message
news:42******** **@127.0.0.1...
I am not sure how to do that. Could you possibly help me to get that started. I sure appreciate your help
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
1. I'd suggest you take the criteria line out of the query.
2. Instead, put a textbox on your main form to enter the month you want.
3. Then use the LinkMasterField s and LinkChildFields properties of your
subform
control to take care of your filtering
Sorry, I'm not sure where I need to be clearer.
Which line of my instructions is unclear?
Could you be more specific in the help you'd like?
"Scott Gorman" <sg***@comcast. net> wrote in message
news:42******** **@127.0.0.1...
I am not sure how to do that. Could you possibly help me to get that started. I sure appreciate your help
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
Sorry for being so unclear.
OK. I have taken the parameter out of the query. Now, when I open the
report, I get all the dates, and do not get the parameters I want.
I am trying to create a form that will open when the report is opened
that I can put the date range I want to see.
I can not figure out how to link the "Date" form to the query and then
to the report to tie it all together.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
OK, that's quite different from the report/subreport setup you first
described.
Do you have parameters other than the date?
Do you have a form, perhaps with a button, from which you open this report?
Or are you opening it directly from the database window?
"Scott Gorman" <sg***@comcast. net> wrote in message
news:42******** **@127.0.0.1... Sorry for being so unclear. OK. I have taken the parameter out of the query. Now, when I open the report, I get all the dates, and do not get the parameters I want. I am trying to create a form that will open when the report is opened that I can put the date range I want to see. I can not figure out how to link the "Date" form to the query and then to the report to tie it all together. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
The only criteria I am pulling out is the date range
I have a switchboard from which to open the report from.
I was able to create a form that I am able to have open when the report
opens to input the parameters in now. Seems to be working ok.
The last thing I would like to be able to do is....
I have a text box in the report that prompts to "input last months
balance". This prompt comes up after my form to input the date range. If
I add this to my form, how do I link it to fill in on the report?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Joris Kempen |
last post by:
Hi people,
I know that the question has come around sometimes:
How to open an Access Report using ASP and export it to for example
RTF.
I'm trying to implement the first method of David Cline:
http://www.15seconds.com/issue/981216.htm
|
by: Tom Weddell |
last post by:
Can I call an Access report from VB.Net? (I'm using access as the backend.)
Thanks in advance.
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
|
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
by: lauren quantrell |
last post by:
When I open an Access form I can have no recordset specified, then in
the form's OnOpen event I can do something like:
Me.paramaters = "@SomeColumn = 22)"
Me.recordsource = "dbo.sproc123"
But I can't do this in a report as it will prompt me for the
parameters, even though they seem to be defined ahead of the
recordsource.
I have worked around this by opening reports to a bogus recordsource
| |
by: brettclare |
last post by:
I have linked a large SQL Server table to Access, however 'only'
2,195,439 records are shown and are available to query. Can I increase
the size (cache??)/number of records showing in Access?
Thank you.
|
by: Dean Slindee |
last post by:
I would like to pass multiple parameters from a VB.NET application to an
existing Access 2003 application's reports (essentially using Access as a
report writer where the reports already exist).
The reports' datasource is a stored procedure with multiple @parameters.
This code works where the report requires no parameter:
Dim strAccessDBPath As String
Dim booReturn As Boolean = False
strReportName = "rptCMOTeam1"
strAccessDBPath =...
|
by: Andy |
last post by:
Hi guys
I having a problem creating a report in Access 2003 project talking to
a SQL database through and ODBC connect.
After hours of trying things from Access Help, MSDN and Google I still
can't get it working.
I have a query defined (view) and want the end user to put in a start
date and end date to filter a report.
|
by: Gilberto |
last post by:
pks00
Expert
280 Posts April 16th, 2007
01:08 PM
Re: How to print MS Access 2000 report to PDF995 printer by VBA Code
Sweet, your using pdf995, makes answering this question that much easier :)
|
by: DanicaDear |
last post by:
I have something interesting...looking to see if anyone else has came across this.
I have a query with parameter and and the query works beautifully every time. However, when I use the wizard to build a report, at the end of the wizard the report opens beautifully, asks for the 2 parameters, and displays results. Beautiful. Then, after closing the report and re-opening, the report promts me for a third, unwanted parameter. ...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |