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 Reverse Sort Order Last Post Replies Views
using vba to alter detail section height is it possible? by a
Hello, in Access 2000 is it possible to alter the height of the detail section to a fix height at run time using VBA? we want the header and footer to be...
March 15th, 2006 05:02 PM
by a Go to last post
1 120
Access Reports - sub-report same height by a
Hello, i have been working on an invoicing system in Access 2k for a while now. we have successfully got vertical lines working in the sub-report thanks...
March 19th, 2006 10:32 PM
by Duane Hookom Go to last post
1 101
using VBA to determine which page a subreport is currently on by a
Hello, within the detail_format() function can VBA determine which page the sub-report is currently on? thanks
March 19th, 2006 10:30 PM
by Duane Hookom Go to last post
1 98
problem with pagebreak by a
Hello, we are setting a page break visibility to TRUE within a subreport, however no page break is being entered. any ideas on why this should happen . we...
March 20th, 2006 05:32 PM
by Wolfgang Kais Go to last post
1 79
How Do You Order an Aggregate Function by A Boy Named Joe
I'm attempting to calculate (in decending order) the cost of inventory of spare parts which were used last year. I'm doing this using a report which groups...
August 17th, 2005 02:46 PM
by A Boy Named Joe Go to last post
2 142
Export multiple reports to same Excel workbook by A C
Hi Can someone point me in the right direction for doing the above? I have 3 reports, I would like to save all 3 into the same Excel workbook. Each on its...
November 25th, 2005 03:32 PM
by David Lloyd Go to last post
3 905
Export report into Excel workbook and --- assign a PW to that workbook by A C
Hello How do I export my reports into an Excel workbook and assign a password to that workbook? What should i be looking for in the help? Thanks AC
November 24th, 2005 04:47 PM
by David Lloyd Go to last post
1 670
Empty date field error by A deer in the digital media headlights!!
I have a report that displays the month, year and a headcount sum for that month and year. The problem I am having is that if I run the report before I have...
(Multi-page thread 1 2)
January 7th, 2009 04:18 PM
by Duane Hookom Go to last post
10 174
Error by A Dodson
I think he is referencing the "Use a form to enter report criteria" help section. Beware that there is an error with the " = No" section of the Ok button...
August 2nd, 2004 06:47 PM
by A Dodson Go to last post
0 118
ACC2000: Can't use Replace() in Control Source of report by A Man
Hi, I have a report in Access 2000. In a Control source of a text box I have: =Trim(replace(UCase(),"PER BOX","")). Access does not recognize the replace...
September 5th, 2007 04:32 PM
by Klatuu Go to last post
2 87
ACC200: error in SQL string by A Man
I have a really long SQL string I'm trying to assing to a string variable in VBA code. Here it is: sSQL = "SELECT Mid(Str(),2,4) AS ,...
January 29th, 2008 11:21 PM
by Duane Hookom Go to last post
1 167
ACC2000: changing report .Filter does not work by A Man
I'm still working on issues in earlier threads. When I use code to change my report's .Filter and set .FilterOn to true, I get no records. When I manually go...
January 29th, 2008 08:16 PM
by A Man Go to last post
3 114
CODE: put text on status bar by A Man
I put text on the status bar to update the user the progress of current operations that take a while. I usually display the current record and total number...
January 29th, 2008 04:42 PM
by A Man Go to last post
0 100
CODE: get current dir of MDB file by A Man
I will be posting a few short snippets of code. Many of you coders already know these, but they should benefit other people as well. Here is code to find the...
January 29th, 2008 06:07 PM
by Marshall Barton Go to last post
1 93
Access help is poor by A Man
Since about Access 95 or 97, Microsoft removed any bookmarking or "favorites" feature in the help system. CHM help is supposed to have a Favorites tab but I...
January 29th, 2008 06:05 PM
by Marshall Barton Go to last post
1 106
ACC2000: save WHERE clause to report via code by A Man
I have a report where I need to save the WHERE clause to it, so another routine (which I did not write) can open the report and create a PDF from it. How...
January 29th, 2008 05:13 PM
by A Man Go to last post
5 92
A2000: make mult. PDFs from one report by A Man
I have Access 2000 and Acrobat Pro v8. I have a giant report with 800+ customers. For each customer I list the products they ordered. Each customer "sub...
January 30th, 2008 01:11 AM
by Ron Weiner[_3_] Go to last post
4 88
ACC2000: dealer order form with last yr qty by A Man
I want to print a dealer order form with all products on it. I want the total of each product the dealer ordered in 2007 to be in a different column next to...
January 28th, 2008 06:58 PM
by A Man Go to last post
0 132
A2000: calculated fields on a report detail by A man
How do I calculate values in a field on a report detail? First I have database fields called FabricBasePrice and FabricRiserI. The report recordsource is...
September 27th, 2004 09:56 PM
by Fons Ponsioen Go to last post
1 415
Report detail col heading problems by A Man
I have Access 2000 on Win XP. I have a report which is based on a query. The query contains multiple customers and each customer has many product details....
January 28th, 2008 03:55 PM
by A Man Go to last post
2 103
Post New Thread


Display Options
Showing threads 141 to 160 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:44 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.