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
Pass value from Footer to Header by DM - NPS[_2_]
I was wondering, I have a subreport in a footer and would like to use one of the values in the subreport to be visible in the detail section. When I tried to...
January 27th, 2009 03:40 AM
by Duane Hookom Go to last post
1 103
Opening a report from a form by Stephen @ ZennHAUS
I have a report that is opened from a form in Access 2003. Two issues. The first is that whenever the report is opened, it opens in the background rather than...
January 27th, 2009 02:37 AM
by Stephen @ ZennHAUS Go to last post
5 113
"On No Data" causes crashes by Kari
Every time I try to use the "On No Data" even to cancel opening a report it crashes Access. That is, if I insert the following code in the On No Data...
January 27th, 2009 12:33 AM
by Kari Go to last post
7 221
Look up a value by ake
I think my problem is about looking up a value. I have a table with the following values Name Initials Juan dela Cruz JdC Kate Winslet KW Manuel...
January 26th, 2009 10:35 PM
by Jeff Boyce Go to last post
3 125
If then statement by DM - NPS[_2_]
Hopefully I can explain this, I am very new to editing code so the more details the better. I have a report called rpt_history which has a sub report called...
January 26th, 2009 10:06 PM
by DM - NPS[_2_] Go to last post
0 89
Dates in a Query by labtyda
I need to use a query where I can change the date. Want to get a percentage of salespersons collections. I have a pledge date, but want sales through a...
January 26th, 2009 06:48 PM
by labtyda Go to last post
6 127
Chart legend problem ("SumOf") by SteveS
Using the chart wizard, I have created a line chart based on a linked excel table. The x-axis is Months, and the y-axis is $. The table works great, except...
January 26th, 2009 05:19 PM
by christine105 Go to last post
4 104
Show current report date and prior report date in same report by mogll
I have a dbase to track internal audits by facility. In each report, I want to show the current audit date and the prior audit date for that facility. My...
January 26th, 2009 01:28 PM
by mogll Go to last post
4 114
Increment numbers on a report by Dave
I have an accounts database with records on a subform linked to the main form against the AccountID, I now want to produce a receipt against the latest...
January 26th, 2009 02:27 AM
by tina Go to last post
3 118
Filtering Subtotals from a report by debinnyc
Working in Access 2003, have a table with customer information and charitable donation amounts. I wrote a query to pull by a date range, and ran a report to...
January 25th, 2009 07:42 PM
by Jonathan Terrell Go to last post
2 115
Conditional Decimal formatting in reports by [email protected]
I have a simple report with data grouped by accounttype such as Sales, PercentRate. I would like my detail records to have no decimal points for the Sales and...
January 25th, 2009 02:32 PM
by Marshall Barton Go to last post
1 130
Is there a bracket (financial) format? by 8020
On a report can a negative number be bracketed, rather than show the -ve sign? e.g. -123.45 (123.45) Seems simple but, I just can't find the format. All...
(Multi-page thread 1 2)
January 25th, 2009 05:57 AM
by 8020 Go to last post
12 225
Print same vendor mulitple times in a single sheet by CAM[_2_]
Hello, I am using Access 2002 and I have made a 1099 database. I need to print out the vendors name, address, amount earned, social security number, etc....
January 25th, 2009 04:03 AM
by CAM[_2_] Go to last post
2 131
Can't set up Switchboard for an Access Report by Lorina
I have tried over and over again to set up a switchboard for a report but when I open the data base nothing happens. It just takes me to the standard Access...
January 24th, 2009 11:09 PM
by Chuck Go to last post
2 100
change report recordsource by smk23
I would like to change a report's recordsource when certain criteria are met. Currently my code looks like this: DoCmd.OpenReport "rptProcSched",...
January 24th, 2009 07:33 PM
by fredg Go to last post
1 101
Foreign Currency on Reports by AccessReportWriter
I write reports for accounting software that is an access database, 2007 version. A field in the database, allows users to enter the currency that a...
January 24th, 2009 05:49 PM
by fredg Go to last post
1 102
Alternating color per line in detail section by Ben
hello, Is it possible to alternate the colour of the detail section for each line? I hope that question is clear, if not what im looking for is the first...
(Multi-page thread 1 2)
January 24th, 2009 04:28 PM
by Rick Brandt Go to last post
14 249
Help with rotating a text box on a report. by FatMan
Hi all: I have a report where I need to rotate a text box 90 degrees so it prints vertical instead of horizontal. The text box contains a bar code that will...
January 24th, 2009 03:14 PM
by Mark A. Sam[_3_] Go to last post
1 93
Change upper case to sentence case by EllenM
Hello, The names of my church's ushers are all in upper case in the table. How can I have them appear in title case in the report? Thanks in advance, Ellen
January 24th, 2009 02:04 PM
by EllenM Go to last post
3 88
making me gray by barret bonden
Access 2002; getting "half gray" check boxes on a report. These are yes/no check boxes and I cant see anything different I'm doing to them - some are...
January 24th, 2009 12:07 AM
by Allen Browne Go to last post
3 158
Post New Thread


Display Options
Showing threads 3941 to 3960 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 07:38 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.