|
More site info...
Setting Up & Running Reports | Forum profile
|
|
Forum profile page for Setting Up & Running Reports on http://www.officefrustration.com.
This report page is the aggregated overview from a single forum: Setting Up & Running Reports, located on the Message Board at http://www.officefrustration.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Setting Up & Running Reports" on the Message Board at http://www.officefrustration.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Setting Up & Running Reports:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
111
|
394
|
1,153
|
|
Post:
|
249
|
977
|
3,051
|
|
|
Setting Up & Running Reports Posting activity graph:
|
Top authors during last week:
user's latest post:
sorting on data calculated...
Published (2009-11-07 01:02:00)
Howard wrote: I have a dynamic cross tab report displaying estimated and potental student grades for a number of subjects. In the DetailFormat event I use the contents of the est and pot grade fields for each subject to count some stats that I then use that to set the colour of the 'name' textbox. (shown arrowed below) This works fine. However I now want to sort the report so that all the names in one colour are in the same place...
user's latest post:
Displaying blank space when no...
Published (2009-11-07 05:46:00)
I just checked again and a subreport control does have both Can Grow and Can Shrink properties. If you can't see them, you are probably looking in the wrong place. -- Duane Hookom Microsoft Access MVP "Taz" wrote: That is not showing as an option. "Duane Hookom" wrote: Set the "Can Shrink" property of the subreport to Yes. -- Duane Hookom Microsoft Access MVP "Taz"...
user's latest post:
On Open Event in a report
Published (2009-11-09 19:24:00)
In the report's open event, you should be able to add VBA code to open a form. Private Sub Report_Open(Cancel As Integer) DoCmd.OpenForm "NameOfTheForm" End Sub John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County MAM wrote: Hello... I have created a report, when I run that report I would like to have an "on Open Event" that opens up a small form...
user's latest post:
Trying to Export Report to Excel...
Published (2009-11-04 21:57:00)
Scott, First let me say, glad that got worked out! Now, as for the 255 character limit (I assuming here you're talking about the column heading), that is an Access limit so not sure how you are going to get around that. Any way you can shorten those column headers? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm...
user's latest post:
Missing data in Access reports
Published (2009-11-09 17:14:00)
Try this -- SELECT tblProperties.PropertyID, tblProperties.[Prop Cord], tblProperties.Year, tblProperties.[Street Num], tblProperties.[Street Name], tblDetails.DetailType, tblDetails.DetailNote, tblDetails.DetailValue, tblDetails.[DetailY/N], [Street Num] & " " & [Street Name] AS Address, tblTypes.Group FROM tblTypes LEFT JOIN (tblProperties LEFT JOIN tblDetails ON tblProperties.PropertyID =...
user's latest post:
doing math on summed totals
Published (2009-11-06 00:56:00)
whats wierd also is that if i change the "/" into a "+", a "-", or a "*", then the math results are other than 0. When I change it back to a "/", I get a "0.00%" answer. OH GREAT! WHILE TYPING OUT THIS INFO I REALIZED THAT THE WHOLE TIME I KEPT USING "WASTE%" INSTEAD OF "WASTE" IN MY FORMULA. THE...
user's latest post:
how to setup event procedure on...
Published (2009-11-09 21:07:00)
I have a main report and a subreport. Now it is working very well. But we don't want everything show up on daily report. On the main report, I put total actual time and target time. If (totalactualtime-targettime)/targettime0.1, then I am hoping the subreport invisible. How can I set this up on the format at event procedure? Please help. Thanks, Tracey
Uschi via AccessMonster.com
6
user's latest post:
Return to Menu after closing...
Published (2009-11-07 20:05:00)
Jeff, I believe I have solved my problem by adding the code to close the report; for some reason it was missing. The following seems to be working: stDocName = "Mailing Labels" DoCmd.OpenReport stDocName, acPreview DoCmd.Maximize DoCmd.Close acReport, "Main Menu" Hopefully, the command will still be working when I put this database back where it belongs. Best, Uschi Uschi wrote: Jeff, Correct. I don't...
Duane Hookom external usenet poster
6
user's latest post:
Displaying blank space when no...
Published (2009-11-07 05:46:00)
I just checked again and a subreport control does have both Can Grow and Can Shrink properties. If you can't see them, you are probably looking in the wrong place. -- Duane Hookom Microsoft Access MVP "Taz" wrote: That is not showing as an option. "Duane Hookom" wrote: Set the "Can Shrink" property of the subreport to Yes. -- Duane Hookom Microsoft Access MVP "Taz"...
user's latest post:
Suppression of name in a list -...
Published (2009-11-09 15:54:00)
Thank you again. But, with this new code, I received the following message: Message : Erreur dâexécution â94â : Utilisation incorrecte de Null And after débogage, the yellow color appeared on these lines : EquivalenceDateObtentionDipl = _ DLookup("[DateObtention]", "tbDiplômes", strCritère) I suppose that the following is correct: In the Source Control of the Zone de texte...
|
|
|
|
Latest active threads on Setting Up & Running Reports::
Started 1 day, 4 hours ago (2009-11-10 01:27:00)
by Sheri
Clarification: Running Sum not part of subreport - it is in the detail
section of the main report referencing to the subreport .
"sheri" wrote:
I have a subreport with a running sum which is referenced (=[RunningSum]) in
the main report under a grouping footer. When the running sum is visible it
totals properly and the referenced amount equals the running sum, but when I
...
Started 5 days, 6 hours ago (2009-11-05 23:48:00)
by Jeff Boyce
If there's a question, I missed it.
If you'll post the SQL of your query, and a description of the table
structure you're using, folks here might be able to offer ideas.
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute ...
Started 1 day, 6 hours ago (2009-11-09 23:04:00)
by duanehookom
You can set the subreport control to invisible with code in the On
Format event of the main report section that contains the subreport:
Me.srptControlName.Visible = Not (totalactualtime-targettime)/
targettime0.1
This assumes the name of your subreport control is srptControlName and
TotalActualTime and TargetTime are bound to controls in this section
of the main report.
Duane Hookom...
Started 1 day, 6 hours ago (2009-11-09 23:07:00)
by duanehookom
Do you have a Sorting and Grouping level on Company? If so, you can
display the group footer and add text boxes with controls source like:
=Sum([Dollar Amount])
If you want the company totals to appear one after another in a
'list', then you may need to create a subreport with the company
totals and insert the subreport into the main report.
Duane Hookom
MS Access MVP
On Nov 9, ...
Started 1 day, 6 hours ago (2009-11-09 23:01:00)
by duanehookom
I generally create a report with a record source the contains the
unique records and fields that I can use to Link Master/Child to the
chart control on the report. The chart control has an option in design
view to display Rows or Columns. I'm not sure which you want to select
but my data is generally more normalized so the "race" becomes a field
value rather than a name.
I'm not exactly ...
Started 1 day, 10 hours ago (2009-11-09 19:24:00)
by John Spencer
In the report's open event, you should be able to add VBA code to open a form.
Private Sub Report_Open(Cancel As Integer)
DoCmd.OpenForm "NameOfTheForm"
End Sub
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
MAM wrote:
Hello...
I have created a report, when I run that report I would like to have an "on
Open ...
Started 2 months, 1 week ago (2009-08-29 23:17:00)
by Duane Hookom
Typically you would just set the criteria in the report's record source to
filter out the names.
You will not have any success with code in the Report_Activate() event.
--
Duane Hookom
Microsoft Access MVP
"Telesphore" wrote:
In a provisory report of students, some students whose "Final Mark" field
already contains the mention "EQV" should not appear.
This report is ...
|
|
Hot threads for last week on Setting Up & Running Reports::
Started 1 week ago (2009-11-03 21:04:00)
by Marshall Barton
Tracey wrote:
I have a question for my report. We used to only put target time and
actual time on the report. But recently my boss wanted to list more
information on the report. If the difference between actual time and
target time is bigger than 0.1, then list runtime for each worker who
worked for this job at this workcenter (usually, many jobs at
different workcenters are listed on ...
Started 1 week, 3 days ago (2009-10-31 21:16:00)
by Marshall Barton
Uschi via AccessMonster.com wrote:
Is there a way to have the report open in Maximum print preview instead of
the report opening and then clicking the maximize button at the top of the
page?
If you use code (behind a command button on a form?) to open
the report, add:
DoCmd.Maximize
right after the OpenForm line.
--
Marsh
MVP [MS Access]
Started 1 week ago (2009-11-04 01:09:00)
by John Spencer
As a guess Access believes that LF Run is not a number field. Is it by chance
a text field that contains numbers or a calculated field that you have
formatted with the format function. Format changes number type to string type.
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
Repent wrote:
I have a report that is based ...
Started 2 months, 1 week ago (2009-08-29 23:17:00)
by Duane Hookom
Typically you would just set the criteria in the report's record source to
filter out the names.
You will not have any success with code in the Report_Activate() event.
--
Duane Hookom
Microsoft Access MVP
"Telesphore" wrote:
In a provisory report of students, some students whose "Final Mark" field
already contains the mention "EQV" should not appear.
This report is ...
Started 4 days, 6 hours ago (2009-11-06 23:52:00)
by Ken Snell
You cannot write data to a textbox on a report. A report will only show data
that are in the query/table that is the report's RecordSource, or that can
be "calculated" by an expression in the textbox's ControlSource property.
It's possible to have a report "look up" a value from an open form, so if
you had a textbox on a form named EquivalenceDateObtentionDipl and that form
is open ...
Started 1 week, 4 days ago (2009-10-31 02:24:00)
by Allen Browne
To add to your observation, Michael, you may like to try:
=[LastName] & ", " + [FirstName]
This generates:
a) Smith, Bill if both names exist
b) Smith if only a last name exists
c) , Bill if only a first name exists.
d) if neither name exists.
(a) is typical.
(b) is useful if you use the LastName for company names too.
(c...
Started 5 days, 9 hours ago (2009-11-05 20:57:00)
by Marshall Barton
Repent wrote:
I want to find the waste% using the sums available. For example, I
have summed up colums for LF Run, LF Produced, and waste.
I want the waste% based on dividing the summed totals of waste by the
summed totals of LF Run.
I tried the code of =Sum([waste])/Sum([LFrun]) but when i run that it
asks for a value, like a query parameter. I just want it to take the
summed ...
Started 1 week ago (2009-11-04 00:46:00)
by Jeff Boyce
"the report fails" is not very informative...
Does your PC melt down? Does it lock up? ... or does it present an error
message? If so, it might help us diagnose if we knew what that message
is...
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or ...
Started 5 days, 9 hours ago (2009-11-05 20:53:00)
by Marshall Barton
Taz wrote:
I have a main report with 4 subreports. When a subreport has no data, it
displays a blank space on the report. How can get rid of the blank space?
Set BOTH the subreport control's and its section's CanShrink
property to Yes.
--
Marsh
MVP [MS Access]
Started 1 week, 1 day ago (2009-11-03 04:51:00)
by eubanj external usenet poster
Report Problem: need to count one field based on another field. (e.g, if the
Region field = Oxnard, then count the "y's" in the QUES 1 field). Can any
one help with this. I am using 2003. Thank you.
|
|
Size: 759 bytes
