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 / December 2004

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
MOD Function or how to convert total minutes to hours and minutes22 Dec 2004 08:08 GMT1
simple question.. maybe
i have a total number of minutes and i want to convert to
hours and minutes.. example  125 total minutes i want it
to be 2 hours and 5 minutes so i figured out how to change
Setting filter prop. of subreport in detail22 Dec 2004 08:07 GMT4
       I have a report with a subreport in its detail section.  I pass the
strings for the filter for the main report and the subreport to the Open
event code of the main report.  I wanted to set the filter of the subreport
from there with code like:
Print Access 97 Mailing Labels in the "middle" of a sheet of label22 Dec 2004 04:03 GMT7
How do I start printing mailing labels in the "middle" of a sheet of Avery
labels for an Ink Jet printer?
Code in Detail_Format of report causes Access 2002 to crash22 Dec 2004 04:03 GMT4
I have a simple 'if' statement in the Detail_Format subroutine of an Access
2002 report:
   If Me.EXPIRED_DT < Date Then
       With Me.Check14
Don't Understand "Public" Variables22 Dec 2004 03:04 GMT1
I am confused about the meaning of "Public" variable.  My main report
declares "Public strStaffGrp As String" at the top of the module.  My
subreport needs to compare strStaffGrp to a Detail field during formatting,
but I can't see strStaffGrp at that point.  But the footer of ...
#Error in a report22 Dec 2004 00:39 GMT1
I have used the following statements in a report:
=IIf("#Error",0,[Field 1])
=IIf([Field 1]="#Error",0,[Field 1])
=nz([field 1], 0)
Duplicate Pages in Summary Report22 Dec 2004 00:13 GMT2
I seem to be having a similar problem that others are experiencing but the
responses on Duplicate Pages in reports are not correcting my problem.  
In my report, all of the text boxes summarize (either by count or sum)
fields in the underlying query.  Everything fits on one page ...
cut chart21 Dec 2004 21:31 GMT1
After installing Windows XP instead of 2000, I've got a cut chart in a report.
The chart is based on days per months. Now, it shows only 26 or 27 days
instead of 30 or 31.
(All forms are bigger now and don't match with a screen).
Passing values to a query21 Dec 2004 20:35 GMT2
I'm trying to pass a value from the field of a form to a popup window for a
query when running a report.  The way I have it set up now is the user goes
into a form and selects from a set of combo boxes that keep narrowing their
possibilities.  Once the users get to where they ...
how to calculate a total21 Dec 2004 20:33 GMT1
in the footer of my report  i made a calculated textbox
=IIf([tipotarea]="1",Sum([points])) this works but shows the total of all
points. What I want is only the total of point where tipotarea is 1
e.g.
Event Programming - on print21 Dec 2004 19:25 GMT4
I have a complex report which contains a number of calculations.  Many of
which are calculated in vba then displayed in an unbound text box.  The
results are totaled from group footer and displayed in the report footer.
I have the problem that the results are shown correctly on ...
Summing an unbound Textbox21 Dec 2004 19:14 GMT1
I have unbound textboxes in the detail section of my report that hold values
related to checkboxes for each record.  In my report footer I want to do a
grand total for the unbound textboxes.  I have tried putting
=sum([textboxName]) in the control source proptery for the textbox ...
Can I print a list of all reports in a database?  If so, how?21 Dec 2004 17:23 GMT1
Can I print a complete listing of all the reports in a database?  If so, how
do I do it? I tried documenter but I just want a list of all the reports and
nothing else.
Please advise. Thank You.
Report Header Sum21 Dec 2004 17:07 GMT3
I would like to cum the total of the 1D1's, It has about 6 like this 1D1D,
1D1G Etc. I'm using the following:
=Abs(Sum([rctg_stn_id]="1D1*"))
and it is not working.
Add a particular record from a table to a report text box21 Dec 2004 16:25 GMT2
I have a report that is generated from a query.  The record that I would like
to add does not come from the same table and query that generates this
report, but from another, seperate table.  I ultimately will use this value
as a constant in a calculation on the report.  I ...
 
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.