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
Use SQL Statement In Report Text Box by Jeff Monroe
In Access 2007 I have a report where I would like to use a SQL statement inside a text box's control source. In the text boxes control source I copied the SQL...
August 30th, 2011 11:35 PM
by Jeff Monroe Go to last post
0 5,454
Crosstab Graph Report not showing Parameters in text box by Alaska1
I have a report using a crosstab query in a graph. The query is asking for parameters. When I try to pass the parameters to a text box on the graph they...
February 22nd, 2011 12:44 PM
by RichardBoomhowern Go to last post
4 2,923
Invalid Sheet Name on Export by Janie
When I export a report from Access to Excel via DoCmd.OutputTo I get an error from Excel saying Invalid Sheet Name. What can be causing this and how I do to...
June 7th, 2010 08:21 PM
by Janie Go to last post
1 1,591
First Letter of each word by PJ
I have the following in a text box field: =IIf( Is Null,"",Left(,1) & Mid(,InStr(1,,",")+2,1)) the field "Comp Entered By" is based off of a lookup table of...
June 7th, 2010 08:10 PM
by John Spencer[_2_] Go to last post
1 1,462
Force the group footer to print on the first page by VBNovice10
Hello, Does anyone know how to force the group footer to print only on the first page of an Access 2007 Report? Thank you in advance.
June 7th, 2010 07:06 PM
by VBNovice10 Go to last post
8 1,752
Automatically name a report when exporting to PDF by shm135
Hello, I have a form with a command button that opens my report in print preview mode in Access 2007. When I click the Export to PDF/XPS button, the default...
June 7th, 2010 06:34 PM
by KenSheridan via AccessMonster.com Go to last post
1 2,057
stLinkcriteria no longer working (since 2007 upgrade) by arathra
We have just upgraded to 2007 and are having a few minor problems. I've seen similar threads online but can't find the solution exactly for us. If I open a...
June 7th, 2010 04:37 PM
by Jörn Bosse[_3_] Go to last post
1 1,509
PageSetup properties keep changing by PayeDoc
Hello All I recently had some mdb corruption problems, that I THINK I've solved - by creating a new mdb and importing all objects. A new problem has now...
June 7th, 2010 03:57 PM
by PayeDoc Go to last post
2 1,508
Report made of a query cross table by Pedro
Hi everyone It must be very simple for you guys but i can't find it: How to make a report, made of a query cross table, but only show records that the total...
June 7th, 2010 02:30 PM
by John Spencer Go to last post
5 1,445
easiest way to create gridlines in an Access 2003 report by Liam0364
Does anyone know an easy way to create gridlines in an Access 2003 report so that it resembles a spreadsheet, other than manually drawing vertical and...
June 7th, 2010 07:39 AM
by Allen Browne Go to last post
1 2,529
conditional numeric formatting of field output on report by JASelep
I have a report that uses one area to display either a percentage or a count I'd like to format the report field output so that if the value is less than 1...
(Multi-page thread 1 2)
June 7th, 2010 06:52 AM
by David McCormack[_2_] Go to last post
10 2,328
Resource For Help With Access by Steve[_77_]
I provide help with Access applications. I specialize in designing the tables for a new database and fixing problems and adding new functionality in existing...
June 7th, 2010 05:34 AM
by Piet Linden[_2_] Go to last post
9 1,482
Trying to calculate difference between two times in an access repo by jackie
I am trying to calculate the difference between two times in an access report and don't know what the correct expression is. My report has a column of...
June 7th, 2010 12:30 AM
by KenSheridan via AccessMonster.com Go to last post
2 1,503
Merge a field data for all records in a table into one output by Zikar
Hi Team, I am desperately seeking help for a solution by which I would be able to merge the data for all records of any one field in a table to appear in the...
June 6th, 2010 11:02 PM
by Zikar Go to last post
2 1,553
Access report date problem. by pinchin1
I have created a lot of graphs to show various information. The problem I'm having is that I need the graphs to show the last 14 days of data. The criteria I...
June 6th, 2010 11:18 AM
by Marshall Barton Go to last post
1 1,333
actualizaciones automaticas by ola jordy
ola jordy
June 6th, 2010 08:41 AM
by ola jordy Go to last post
0 1,258
Prevent skip to new page after last page prints by Goldar
I have a page header section, a group header section, a group footer section and a page footer section on my report. The group header I am trying to use...
June 6th, 2010 04:58 AM
by Allen Browne Go to last post
3 1,652
PLEASE HELP: Refresh columns displayed in a report from a query ou by Sam
Hi All, I have a report whose record source is a query, the query consists of dynamic Select and Where clause and so the columns are user driven (based on...
(Multi-page thread 1 2)
June 4th, 2010 10:13 PM
by Marshall Barton Go to last post
10 2,251
report in access (Count) by M.K[_2_]
If i have data in CSV file and it show like belwo Column1 Column2 ABCD Saturday ABCD Saturday EFGH ...
June 4th, 2010 08:07 PM
by Duane Hookom Go to last post
2 1,356
Firstname plus Middlename?? by KG
Apologies if this is a silly question. I'm trying to combine Lastname, Firstname Middlename in a report. I have =(+", "++" "+). The only time it works is if...
(Multi-page thread 1 2)
June 4th, 2010 07:02 PM
by David W. Fenton Go to last post
10 2,068
Post New Thread


Display Options
Showing threads 1 to 20 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 07:39 AM.


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