graph not showing on PDF export / print
Thu, 20 Nov 2008 07:10:00 -0800
Hi all,
I have in my Access 2000 application (running in Access 2007 comp. mode) 4 reports with graphs on them.
2 of them work as expected, and 2 don't. These graphs are all pretty much copies of one another, and I can not, for the life of me, figure out why 2 of them do not work.
I've searched this and man ...
|
Table of Contents Help
Thu, 20 Nov 2008 15:00:28 GMT
Good Morning Everyone,
I am having trouble updating my Table of Contents report that I created using
KB article 210269. The is as follows:
Option Compare Database
Option Explicit
Dim db As DAO.Database
Dim TocTable As DAO.Recordset
Dim intPageCounter As Integer
Function InitToc()
'Called from th ...
|
Pass parameters by directly opening a report by link?
Thu, 20 Nov 2008 06:25:02 -0800
Hi all,
I wonder how to call a report by link already with filled parameter like:
LINK:
http://moss.abc.com/DB.accdb?type=report&name=ReportA
(This opens access with the specified ReportA, but how can I pass
parameters, too?)
...
|
Subreports don't appear in the report if I splitted the database
Thu, 20 Nov 2008 03:08:10 -0800
I created a rather complicated report with many subreports included and many
queires. When I run the report it worked fine as long as the table and
reports etc. are in one database. But if I splitted the database, all the
subreports doesn't display on the report. There are no temporary tables in
any queries. ...
|
Reports: sorting on hidden Table fields in Access 2007
Thu, 20 Nov 2008 00:56:04 -0800
Using Access 2007,my Uncle would like to generate a fairly simple Report for
a Table. Can he use the Report to sort on certain fields in the Table (i.e.
multiple sort) without having to display those fields in the resultant
Report?
I don't have Access 2007,so if poss could you please give brief details of ...
|
pdf file name from field?
Wed, 19 Nov 2008 20:28:01 -0800 (PST)
I want to print my report to a pdf file but the default file name is
always my report name. Can I reference a field in my report for the
new pdf file name? ...
|
Calculating total hours
Wed, 19 Nov 2008 15:04:06 -0800
I have a report were I add up the total number of seconds and then report
that in hours:minutes:seconds. The control source reads
=Sum([ETime])/(60*60*24), the format reads h:nn:ss. It displays in the
format I want but I need it to show total hours such as 32:25:00 for 32 hours
25 minutes and 0 seconds. It ...
|
|
|
Pulling report from 2 queries, one with a Sum
Wed, 19 Nov 2008 14:46:00 -0800
In MS Access 2003 I'm trying to make a Report pulling from 2 queries. One
query pulls from a table of offices with their authorized staffing amounts.
The other query pulls from a query that pulls the Sum of the number of times
each office appears in a table. When I make the report, pulling from the 2
quer ...
|
Avoiding blank lines in report
Wed, 19 Nov 2008 14:15:02 -0800
My simple report shows no detail lines, but has both bound fields and sum
fields in the group footer. On conditions based on the sums, I set
PrintSection to False in the On Format event, but a line feed is still
generated giving an unwanted blank line. Is there any way to avoid the blank
lines? ...
|
Change Default font for Reports template 2003-2007
Wed, 19 Nov 2008 10:18:09 -0800
I am working on a project that requires I build a number of sub reports that
are then incorporated into a master report. I am spending a lot of time
changing fonts size color etc to match the master.
Is there a way to change the default font for reports and forms? In the
Access options there is a place to ...
|
