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 Reverse Sort Order Replies Views
Still have hope but need more help. First Question, more to follow by znibk
I have a report and I would like the information to print side by side on the report page ! ! (columns which are even at the top) not ! ...
(Multi-page thread 1 2 3)
August 19th, 2007 05:48 AM
by znibk Go to last post
23 306
Report/Sub-report Control Source by znibk
Hope some one can help me. I am using Access 2003 and am in the process of creating a financial report. So far, I have the Main Report containing the date...
August 19th, 2007 04:40 AM
by Duane Hookom Go to last post
3 120
Report preview behind form by Steve S
I have a regular with a button to preview a report. The report always opens behind the form. The form is set up as pop-up and modal so the user can't see...
August 19th, 2007 03:32 AM
by Bob Howard Go to last post
3 85
SQL query by Greg
I would like to show issues open for today and i have the folowing sql that is not working: SELECT ., ., ., ., .Status, ., ., ., . FROM where . =...
August 18th, 2007 11:38 PM
by Greg Go to last post
3 91
automated statements by robertm600635
I have a report set up that shows an individual client's billing statement. Is there a way I could set up a command button to automatically print statements...
August 18th, 2007 07:32 PM
by robertm600635 Go to last post
2 95
Page footers by retired fire
I use Access to print mailing labels, and the Labels (reports) created work great. I need to add page numbers in the footer, but when I add the footer, the...
August 18th, 2007 03:50 PM
by retired fire Go to last post
3 104
$150 to be automatically write as "one hundred fifty" in MS Access by Shakti
In MS Access, I design a report which show total of a field in Value (i.e. in number) and the same is to be write in word. For example - $150 to be...
August 18th, 2007 03:03 PM
by fredg Go to last post
1 148
Draw diagonal line in the report by Irshad Alam
I would like to draw diagonal line starting from RHS toward downside to LHS - the height should be the difference from the point where the detail section...
August 18th, 2007 06:02 AM
by Irshad Alam Go to last post
0 97
Carriage return in a text box in a textbox in report. by Misha
Hi! Who knows, why this code make a space but not carriage return? Me.txtText = rs("companyName") & Chr(13) & Chr(10) & "text1" When just change ADO RS to a...
August 18th, 2007 04:42 AM
by Misha Go to last post
4 131
Sum() function in report returns #Error in Access 2000 by KT Huggs
I am trying to create a report to generate an invoice, and I need it to total my fees in a reasonable manner. In the detail section of my report I have a...
August 17th, 2007 10:54 PM
by JC Go to last post
4 126
Fiscal YTD Calculation Not Working Correctly by Walt
Hello - I have a report that contains text boxes as calculated controls for MTD and YTD totals. These text boxes perform record counts and increment the...
August 17th, 2007 10:53 PM
by KARL DEWEY Go to last post
2 104
Report: List of Tables and their field names by porter444
I have a massive database that I inherited from someone who is no longer with the company and need to produce some reports. My problem right now is...
August 17th, 2007 09:28 PM
by George Nicholson Go to last post
3 76
Displaying Text Value in Number field in report. by hana
I need to display text value in number field in order reports for some items where quantity isn't applicable. For those items, I would like the report...
August 17th, 2007 08:16 PM
by Jeff Boyce Go to last post
1 80
Filter report to only show current record by robertm600635
I have a report that displays data for payments collected from clients. This report is grouped by the clients name with their various fees listed below their...
August 17th, 2007 05:12 PM
by robertm600635 Go to last post
4 106
allowEdits by injanib via AccessMonster.com
I have my form property setup to AllowEdits=false. When the form is opended in edits mode all fields are locked, which is what I want so that records are not...
(Multi-page thread 1 2)
August 17th, 2007 05:07 PM
by injanib via AccessMonster.com Go to last post
13 177
Report filter problem by injanib via AccessMonster.com
I have a command button called TodaysReport and an unbound textbox called txtDate whos defauld value is set to Date(). I need the on click event property of...
August 17th, 2007 04:40 PM
by Carl Rapson Go to last post
1 82
Automate Publishing through Excel to Word by knowshowrosegrows
I have a report that ultimately must be in word. However, when I publish it in word I lose some essential formatting. I can publish it to Excel and then...
August 17th, 2007 04:40 PM
by knowshowrosegrows Go to last post
0 109
2007 Access Reports by DSmith
I just moved up to 2007 from 2003. How do you get rid of the calculated fields that appeared on my reports??
August 17th, 2007 04:04 PM
by DSmith Go to last post
0 89
MonthName Sort options by klp via AccessMonster.com
I have a crosstab query that displays totals for each month. How do I convert the month numbers to their actual name on my report? I used the...
August 17th, 2007 03:59 PM
by klp via AccessMonster.com Go to last post
9 122
Professional layout for a dictionary by Klaus Martini
Hi, I use Access 2007 to store the data of a dictionary. Now, when it comes to print it out, I wonder if the following task can be done from within...
August 17th, 2007 01:27 PM
by Klaus Martini Go to last post
2 73
Post New Thread


Display Options
Showing threads 9761 to 9780 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 01:36 AM.


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