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 04:02 PM
by a Go to last post
1 93
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 09:32 PM
by Duane Hookom Go to last post
1 79
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 09:30 PM
by Duane Hookom Go to last post
1 74
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 04:32 PM
by Wolfgang Kais Go to last post
1 56
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 91
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 02:32 PM
by David Lloyd Go to last post
3 491
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 03:47 PM
by David Lloyd Go to last post
1 339
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 03:18 PM
by Duane Hookom Go to last post
10 127
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 91
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 66
ACC2000: bloat after saving report via code by A Man
So I have a routine that makes a PDF for each customer in a loop. It opens a report in design view, changes the recordset to process only 1 customer, save...
January 31st, 2008 05:30 PM
by Duane Hookom Go to last post
1 96
ACC2000: change string to int by A Man
I have a customer number that is a string, but I need to change it to an integer variable. Assigning: iCust = sCust does not work. (I just want to drop...
January 30th, 2008 07:09 PM
by A Man Go to last post
3 115
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 07:16 PM
by A Man Go to last post
3 92
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 03:42 PM
by A Man Go to last post
0 78
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 05:07 PM
by Marshall Barton Go to last post
1 78
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 05:05 PM
by Marshall Barton Go to last post
1 76
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 12:11 AM
by Ron Weiner[_3_] Go to last post
4 65
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 05:58 PM
by A Man Go to last post
0 95
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 182
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 02:55 PM
by A Man Go to last post
2 91
Post New Thread

Display Options
Showing threads 141 to 160 of 28847
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 12:06 AM.

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