Titles with parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using VB or any other easy way, how do I update the title on a chart with the
parameter from a parameter query?

Just spell it out long please. I know nothing about VB. I am trying to create a database report for work. I need to show the range the chart is based on, it is the whole report!!. Everyway I have tried asks the start date and end date 20 million times before showing nothing.. I am getting really frustrated I have 5 chart reports to create!!!
 
Is this report called from a form - where the parameter is entered? if so
trying something like . .

Add an unbound text box to the report and call it txtTitle

At the top of the Report module add the following
Dim strPageTitle As String

In the OnOpen event of the report add the following code

strPageTitle = "Date Range = " &
forms!yourformname!yourdatefromcontrol.value & " to " &
froms!yourformname!yourdatetocontrol.value

In the OnFormat event of the page header or report header add some code
similar to the following.

txtTitle = strPageTitle

If it is not called from a form then do the following:

in the controlsource of the datefrom control enter the exact wording of the
parameter prompt
eg Prompt1 = [Enter Date From]
Prompt2 = [Enter Date To]

Each control where you want the entered parameter to appear on the report
change the controlsource to
[Enter Date From] or [Enter Date To]

HTH

Tammy said:
Using VB or any other easy way, how do I update the title on a chart with the
parameter from a parameter query?

Just spell it out long please. I know nothing about VB. I am trying to
Click to expand...
create a database report for work. I need to show the range the chart is
based on, it is the whole report!!. Everyway I have tried asks the start
date and end date 20 million times before showing nothing.. I am getting
really frustrated I have 5 chart reports to create!!!
 
The report is to consist of a chart only with a title that gives the date range that is entered for the parameter query. The problem is the chart is based upon a secondary query

The first query gives a date count to ensure that all entries are counted. This is the parameter quer
The second query counts the desired parameter and this is the query the chart is based on

I do not understand how to do what you are describing in this type of situation

Hopefully someone will be able to help me tonite I am desparate!!!!
 
I posted an possible solution in another thread.

--
Duane Hookom
MS Access MVP
--

Tammy said:
The report is to consist of a chart only with a title that gives the date
Click to expand...
range that is entered for the parameter query. The problem is the chart is
based upon a secondary query.
 
Back
Top