|
create an optional row of a report
Is there a way to create a row on a report that is optional?
I'm trying to improve an existing report , that is generated from a link
table. what i would like to have is if certain columns are not null ( have
values) print an extra row right underneath that row, showing this
information. Is this possible in MS Access? Anyone have any idea how to
accomplish this?...
|
3 |
12/18/2008 6:22:02 PM |
|
|
Output data to Calendar
Is there any way to output certain information in my database to
either a monthly or weekly calendar format? The date is entered into
the database and a simple text explanation would need to be displayed
on that calendar day. I cannot figure out how to do this either as a
report in access or exporting to a document.
Any suggestions?
Thanks!...
|
3 |
12/18/2008 6:02:46 PM |
|
|
Subtotals every X number of records
I know how to do subtotals based on the standard groupings based on the
values in a field.
Is there a way to do subtotals every certain number of records in an Access
report (Access 2003 here)? In my current specific case I need subtotals
every 15 records (don't care at all about values in the fields, just every 15
records)....
|
5 |
12/18/2008 2:51:04 PM |
|
|
Report Linked To Excel Causes Access 2007 Crash
I have a report that is linked to an Excel spreadsheet that I use every now
and then. I tried to use again and now it crashes as soon as I attempt to
display the report. In diagnosing the problem, I have found that I cannot
create any new linked report. Access will always crash when I try to display
the report.
I have found these simple steps always cause Access to crash:
1. Use E...
|
2 |
12/18/2008 2:07:22 PM |
|
|
How to set permanent height in detail section area
I have a report and I want to set the detail section just print max only 10
records (ex.the detail section height is only 3 inch) and dont want the
height grow or shrink.If my records less than 10 record, the height is
permanent 3 inch height, cause my paper is already printed.
Thank
BT...
|
3 |
12/18/2008 1:41:02 PM |
|
|
Import from word to Access Report
Does anyone have code / a utility to import the actual objects into a
report.
I don't mean dropping the document as an ole object. I mean that the
word objects (table borders, text boxes etc.) should be translated into
their access report equivalents, as much as possible.
This should be possible through code that loops through the objects in
the word file and reconstructs similar obj...
|
1 |
12/18/2008 11:22:13 AM |
|
|
Grand total
I am trying to set up a grand total of totals.
Total is [unit1]+[unit2]
and the grand total at the end of the report is of the form
Sum([unit1]+[unit2])
All I get on the report is #error
what am I doing wrong?...
|
3 |
12/18/2008 8:23:01 AM |
|
|
Report To PDF
Hi there,
I would like to create a pdf file for my invoice using a combination of the
company name and invoice number. I would like to be able to preview the
invoice first, then save it and when it's saved the invoice would look
something like this: fakecompany-LPI02.
The code below is what I'm currently using to preview the invoice. I then
would select CUTEpdf Writer from my list of p...
|
2 |
12/18/2008 3:49:37 AM |
|
|
Count records in footer
The record counter works correctly the first couple of times. Then it seems
to double values. Is there a way to clear out this counter each time the
report closes? I suspect its holding values....
|
4 |
12/18/2008 2:28:01 AM |
|
|
OUTPUTTING REPORTS IN ACCESS 2003 (or 2007?)
I have a report with a specific layout (combination of columnar and tabular)
with a subreport in it and I want to be able to have the users choose this
report from the switchboard and have the report output to Excel AND maintain
the exact formatting and layout as the Access report. HELP!!! Can this be
done? Can someone point me in the direction of an example of how to do this?
(The r...
|
2 |
12/18/2008 1:34:36 AM |
|
|
Decimal Trailing Zero Formating
Im working with a numeric field that infrequently uses decimals. I know that
Access 2003 does not store trailing zeros in the number field but would like
to show zeros when printing reports.
I would like only to show zeros for non integers so the report would read
1
2
3
4.01
4.02
.....
4.10
5
I do not want the report to read
1.00
2.00
3.00
4.01
4.02
...
4.10
5.00
H...
|
14 |
12/18/2008 12:10:37 AM |
|
|
Report generation
Working with Access 2007 and let me say, It's a bitch.
Is there an easier way to move "controls" rather than "removing" them from
the layout and re positioning them?? boy I liked the old method better.
Secondly, trying to "Page Break" when a "Clock Number" field changes. Cant
find that at all Want to put each "Clock Number" on it's own report page
with headers etc...
Thanx..
tom...
|
6 |
12/17/2008 11:58:01 PM |
|
|
Suppressing Page Header for Specific Page
I want to suppress the main report page header on the separate page for a
subreport (that is, I want the subreport to appear to be an entirely
different document).
How do I suppress the main report's page header?
...
|
4 |
12/17/2008 9:58:24 PM |
|
|
Creating an anniversary card
I was using merge documents, but I'm having difficulty merging. I am putting
merge documents into Access and running everything from Access. The report
seems very archiac or I just don't know how to use it. I try and paste
graphic, etc. but nothing seems to work. I'm trying to create an anniversary
card, and want to rotate text? Can you do that in report. I can't find anyway
to do it. ...
|
1 |
12/17/2008 9:39:00 PM |
|
|
SumIf on report
I have a report that returns 4 different records and is grouped by 'Type'.
I would like to return the sum of the values for every "Reserved" type in my
report footer.
I am able to create an IIF statement saying:
IIF([txtType] = "Reserved",[Total],0) - but obviously this will not check
each record
My next attempt was to sum the IFF statement as such:
Sum(IIF([txtType] = "Reserved...
|
3 |
12/17/2008 7:48:01 PM |
|
|
Chart
I am creating a graph in a report where there are multiple dates on the X
axis. By default the chart groups duplicte dates togeather on the axis. In
Excel you can
have them seperate as individual data points by formating the axis. Is there
a way to force the chart to not combine the dates (show them as individual
datapoints) in Access?
Terry
...
|
2 |
12/17/2008 7:31:01 PM |
|
|
horizontal line is creeping down the page
I have a report that has a rather simple detail section. The detail section
height is set to 3.55", with a .166" top and bottom margin. That makes it
print 3 records (i.e. detail sections) per sheet of paper.
Everything is working fine except for a horizontal line I have in the detail
section that sits at the bottom of a column of numbers, above the total.
When I print the report, th...
|
2 |
12/17/2008 5:11:02 PM |
|
|
system time
I would like to have my system time on the report in French, but in
English Windows system.
I know that when I have now( ) function that Windows give us system
time base on Windows language for example English.
I would like to know is it possible to overwrite it base on user
select language in the applicaiton and print out different language,
but using English Windows.
Your help is ...
|
6 |
12/17/2008 4:09:10 PM |
|
|
Page Layout: Portrait and Landscape
I have a multi page report, it is a main report with 2 sub-Reports. Is there
a way to make the first page of the report have a Portrait Page Layout while
the rest have a Landscape Page Layout?
--
Thorson...
|
3 |
12/17/2008 3:34:23 PM |
|
|
Report Control Source
Not sure if this is the correct approach but the end result that I am looking
for in a report is for values contained in month 1 through 12 (values in a
month field) are displayed for each project record.
The source of the data is a table that pulls in actuals transactions from an
Excel ss - multiple transactions per month per project. I have created a
query that sums the transactions ...
|
2 |
12/17/2008 2:32:46 PM |
|
|
Email 2 reports at once
Is there a way I can take this code, but insert another report in as well so
both reports are attachments in 1 email? Thanks a ton, and I appreciate your
help in advance!
The one report I have in here working already is "r6135EMAIL2". I also want
to put in another report called "r6135FOREMAIL".
Private Sub Command49_Click()
On Error GoTo Err_Command49_Click
Dim stDocName As S...
|
3 |
12/17/2008 1:56:02 PM |
|
|
Printing earliest report of name selected
What I need to do is print a report that will only print the last entry of
that selected Name, not the complete last record of all entries. Now I know
how to do a qwery select by name, but I do not know how to get just the last
record of that name. Any help would be greatly appreciated....
|
5 |
12/17/2008 3:23:00 AM |
|
|
won't print color
haven't been able to find any q&a on this topic here at the site.
Access03: existing report: I changed to a font color to several columns of
data. Columns span up/down from report header, page header, details, footer.
Was all black; but added color font for readability...some blue and some red.
But it only prints it black.
Tend to blame the printer; possibly the driver - - but the use...
|
3 |
12/17/2008 12:09:12 AM |
|
|
Using a combo box to open a report
I'm running into a problem, where from a main menu form, I need to have a
combo box where a user can select a record from another form and print a view
it's report. Help?...
|
2 |
12/16/2008 11:19:01 PM |
|
|
how do i count "unchecked" boxes
I have 2 checkbox fields, [E-Mail] and [Mail]. How do I count the records in
which neither of these fields is checked?...
|
5 |
12/16/2008 11:10:00 PM |