Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / July 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
records total expressions not working31 Jul 2007 17:14 GMT3
I have a report wherein I would like to total the number of meeting
registrants.  I enter the following expressions in a text box in the report's
footer and neither of them work.  
=sum([LastName])
Conditional format31 Jul 2007 16:04 GMT4
I have a report with a conditional format that works fine on the "left" page
but I created a report with the same format (the right page) and it won't
work.
It is a simple line count from a hidden field called "rulenumber"
Need to keep field groups together31 Jul 2007 15:08 GMT3
Here's is the format to my report:
Sec.      Item#     Description           UPC
_____________________________________
###     ####      ######## #########
Group Together31 Jul 2007 13:54 GMT3
I have a report containing 2 sub-reports.  One is to show a list of book IDs
that are checked out today, and the other one is a list of book IDs that are
checked in today.  Currently, the book ID text box is in the Book ID Header
section.  The report does list a listing book IDs ...
Are these calculations possible?31 Jul 2007 13:21 GMT1
I have a report made up of multiple investment funds.  I have totaled the
amount for each individual fund in the group footer which is the way the
client wants it.  The clincher is they want the total from one of the funds
to show that it is subracted and then added to a ...
Coding problems with User defined Visible Property31 Jul 2007 12:41 GMT2
I have a report that my users supply to seavel groups. Some do not require
certain fields so these will be hidden by using a checkbox on the relevant
form. At the moment, I am using the following in code builder:
Me.txt[recordNumber].Visible = ...
report problems31 Jul 2007 12:38 GMT1
i have a check box whose control source is:
=[Total In Stock]-[reorderlevel]<=0
how can i set the control to only be visible if this check box is
true?
Rounded Rectangle31 Jul 2007 10:16 GMT2
I need to insert rounded rectangles on an access report. To see what I mean,
open Paint, and selected rounded rectangles from the toolbox.
These rectangles are to be in the report header, footer, and body.
For the header and footer, I just drew the rectangle in paint, then pasted
Query that feeds the report31 Jul 2007 05:50 GMT3
Im using Windows XP and Office 2003
I would like to put more than 255 fields in my report.
I have one query that feeds my report. That query is full [255 fields].
If i take the query that is full and and make a relationship between it and
Print Preview Window Handling31 Jul 2007 05:29 GMT2
I open a report from VBA code in a form.  I use acViewPreview and open it as
a dialog (window type is acDialog).
In the report's OnOpen event, I maximize.
The reason I want that is because I want a full screen preview, and I don't
In Access what expression do I use to average a field ignoring 0?31 Jul 2007 01:13 GMT2
I have a report that calculates the average of a requested field. The average
is not correct due to "0" values in some of the records. What expression do I
use in the Control Source to ignore the 0 entries? I tried to adapt the one I
use in Excel but did not get the results I was ...
Problem with If.... Then.... Else.... Statement30 Jul 2007 23:16 GMT7
Trying to run a report which will look at a field and if a persons name
appears in that field the their signature will be visible on the report, if
it is not there name then another person signature will appear.
I have put the if statement below on the reports Details section in ...
Format a report30 Jul 2007 22:01 GMT1
I have a table with a single field named "ID".  I would like to print a five
column report which would display my first 5 ID's across the page and then
display the next 5 ID's on the next line and so on.  Can I do that?  
Thanks for any suggestions you may have.
Calculating Averages30 Jul 2007 21:22 GMT10
I am trying to calculate an average on the following
[score A]+[score B]+[score C]+[score D]
These are text fields with validation rule
="NA" or Between 1 and 5
Counting records by financial year30 Jul 2007 20:54 GMT1
I am trying to count the number of jobs in a program, based on the financial
year.  I have found I can set the properties so that it starts a new year on
each page, but I cannot get it to change to financial year.
I then need to count the records in the separate programs in each ...
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 June, 2007
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.