A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Setting Up & Running Reports Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Views Reverse Sort Order
Error in totals when no data in subreport by Barry
Good Evening: I have a report ("Invoice") which has 2 subreports, one for parts and the other for labor. When either has no data the calculations for totals...
June 2nd, 2010 03:48 AM
by Marshall Barton Go to last post
1 933
Reports with Date Range - Errors by jwr
I am using Access Orders Database. On the Orders by Customer Report (and other reports) when I attempt to preview, a box pops up asking for a date range. ...
(Multi-page thread 1 2)
August 8th, 2005 12:57 PM
by jwr Go to last post
12 929
Printing on a 22" x 34" size sheet by GYO
I need to print reports on a 22" x 34" size sheet. The bigest access allows me to print is 17" x 22". HELP.
May 4th, 2005 02:24 PM
by Rick Brandt Go to last post
3 928
How to use a Access Query that as a parameter into Excel database query by Karen Middleton
I have an Access Query that joins several Access tables and reports on it I have a parameter value of Year.Month for this Access query. I want to use Excel...
December 13th, 2004 07:54 PM
by Nick Hodge Go to last post
1 927
how NOT to print page number on 1st page of report by kim
i'm preparing a report with the first page as a cover using report header. how can i hide page number on this cover page located in page footer area? also, how...
May 19th, 2004 08:51 PM
by Go to last post
2 925
Export from Access to Excel disabled by Karen Water
My company is in the process of upgrading to vista, but they are using Microsoft Service Pack 1 instead of 2. The option to export to Excel is disabled in...
May 18th, 2010 01:31 PM
by Mark Andrews[_4_] Go to last post
1 925
Printing a report 2-up by Bill
How do I go about creating a report that retrieves data from my table and produces a report of that data 2-up (side by side). ! record on the left and the...
June 3rd, 2010 01:29 PM
by John Spencer Go to last post
3 924
Weekly Calendar by Lori
I am using Office 2003 and I have everything set up to provide me with Annual and Monthly Calendars that are perfect when they print. What I need now is a...
May 19th, 2010 10:02 PM
by Duane Hookom Go to last post
6 920
Make field in report show zero and not blank by T. W.
How do I make a TextBox in a report show the number zero instead of a blank. Thank you beforehand.
(Multi-page thread 1 2 3)
November 22nd, 2004 02:00 PM
by T. W. Go to last post
21 917
REPOST: Maintaining Page Numbers with multiple reports. by Robin Chapple
Having been growled at for being unaware of protocol I have taken advice from an MVP before sending this. If this offends protocol I apologise in...
August 5th, 2005 06:53 AM
by david epsom dot com dot au Go to last post
1 917
subreport not displaying in main report by JohnLute
I posted this previously as "subreport with parameter query"." Although I resolved part of the problem I have yet to resolve it entirely. Thanks, Allen Browne...
(Multi-page thread 1 2)
November 17th, 2005 04:02 PM
by Ofer Go to last post
15 916
Write Name of Report Query in Report Footer by Steve Stad
Is it possible to programmatically write the name of the query the report is based on in a text box in the report footer.
May 24th, 2010 03:59 PM
by Steve Stad Go to last post
2 916
Show phrase when no data for a report by FloodEbb
I have followed several threads on this subject which suggest using the IIf statement in a new text box. Some suggest the IIf should be on a particular field...
May 30th, 2010 03:27 PM
by FloodEbb Go to last post
3 914
"AND" Clause in Filter Makes Unbound Text Boxes "Invisible" by Smit-Dog
I have a report with a bunch of unbound text box controls. The report is opened, and then I explicitly populate a few text boxes with data: DoCmd.OpenReport...
September 10th, 2004 09:52 PM
by Duane Hookom Go to last post
4 914
Calculating an inventory balance at a "point in time" by Joe[_48_]
All, I have an inventory transaction table that houses all additions and subtractions of a particular part #. The inventory balance of the part # at any...
August 20th, 2009 06:36 PM
by Duane Hookom Go to last post
5 914
Update a table and close a form after a report runs... by Jacqueline
After I run and then close a report I want a checkbox in Acknowledgement table to update...the table does show the checkbox updated. ....but after the report...
May 19th, 2004 06:59 PM
by Jacqueline Go to last post
0 913
Bound Chart in Report Issues - Access 2007 by Andre[_5_]
I have a simple table, containing a count, a status and an agent name. I created a simple report, with a header by agent name. The idea is that the report...
May 24th, 2010 12:33 PM
by Mark Andrews[_4_] Go to last post
3 912
subreport not showing fully by Pam Ammond
I have a subreport, and it previews properly. When I put the subreport in the main report, it shows the detail portion, but not the footer portion of the...
(Multi-page thread 1 2)
August 19th, 2004 10:19 PM
by Vikrant V Dalwale [MSFT] Go to last post
11 912
Number of Mondays in month by Michael Noblet
I have a % utilization calculation I need to do in a report where the denominator is the number of hours in a shift * number of rooms * number of days. Yhe...
July 28th, 2004 10:41 PM
by Wayne Morgan Go to last post
3 910
Report Taking a Long Time to Print by MichelleM via AccessMonster.com
I have a main report with 2 subreports in it. One of the subreports seems to be holding up the report when it comes to running and printing. When I run the...
April 30th, 2010 07:04 PM
by MichelleM via AccessMonster.com Go to last post
0 909
Post New Thread


Display Options
Showing threads 161 to 180 of 28846
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.