Formating code appears in report
Mon, 18 Aug 2008 19:29:01 -0700
I have imported a database from an earlier verion of Access into Access 2007.
I want to print a report with a note field. Unfortunately, this field prints
full of coding information such as "<blockquote> <div> <font=cambria=2>
" etc. I don't want any of this
informati ...
|
Changing specified printer
Mon, 18 Aug 2008 17:20:16 -0700
I have an Access database (2003) with a large number of reports that use a
specified printer (Adobe Professional). The admin has decided to change to
PDFCreator and so I have to go through and update all of these reports to now
change to the new printer driver.
I was wondering if there is a way in the future ...
|
Report Design
Mon, 18 Aug 2008 16:17:02 -0700
I'm having a terrible time with my report design. I've asked this question
before and did not get an answer. FYI: I'm working in Access 2007.
Trying to do... As an example...I want to list a name and address on each
page of my report as the report headers. But then I have another table with
a one-to-ma ...
|
Filter a function that runs a report as a pdf (RunReportAsPDF)
Mon, 18 Aug 2008 14:57:00 -0700
Is it possible to filter a function that runs a report as a pdf
(RunReportAsPDF)?
the relevant code is below:
Public Function RunReportAsPDF(prmRptName As String, _
prmPdfName As String) As Boolean
' Returns TRUE if a PDF file has been created
Dim AdobeDevice As String
...
|
Pass arguments through a report filter using a ADO Connection
Mon, 18 Aug 2008 14:38:09 -0700
Is it possible to pass arguments through a report filter using a ADO
Connection?
I typically see examples like this Filter = "Client Id = 1" but I want to
do something like Filter = "Order Number" and each time the code loops it
uses the order number of each record as the filter.
Here is the line of co ...
|
Print icon from the MS Quick Access Toolbar prints wrong report
Mon, 18 Aug 2008 13:45:01 -0700
Using Access 2007, if I select the Print icon included in the MS Quick Access
Toolbar, the incorrect report is printed. The Print Preview icon also
displays the wrong report. Right clicking in the report and selecting Print
does print the correct report. Using the Quick Access icons worked in Access
2003 ...
|
Limiting Decimal Places in Report
Mon, 18 Aug 2008 13:05:01 -0700
I am hoping to find a top level fix to a report I've inherited.
16 reports pop up from a macro that I believe was built with Access 2000.
When you run the macro in Access 2007, the reports display the figures up to
14 decimal places. I have formatted the field in the report to "standard"
format and the de ...
|
|
|
watermark on the report
Mon, 18 Aug 2008 11:07:12 -0700 (PDT)
I just wanted to know it is possible to place a watermark on the
report like MS Word.
Your information is great appreciated,
...
|
Calculation Using IIf
Mon, 18 Aug 2008 10:51:02 -0700
I have a crosstab query with string values as row headings (Valid, Invalid)
and months as column headings. In a report, I need to calculate the
percentage of the total for each value. I can get a percentage for either of
the values, but not both. Something is wrong with my syntax.
Here is the expression:
...
|
Event Procedure
Mon, 18 Aug 2008 13:49:20 -0400
I am not knowledgeable about VB or event procedures.
I am trying to learn.
I have created a report based upon a query. Occasionally the query will
produce no output and the report based upon this query does not look good.
I put a Label on the Report saying " NO DATA AVAILABLE" and I set this Label
option ...
|
