|
report header onprint event procedure does not fire
Hi,
in the report header onprint event, my report calls a sub that is to write
table-of-contents data into a table (as per MS Knowledge Base article).
However, the event would not fire.
I tried compress and repair, copied the whole database into a new one,
decompiled and recompiled, still the event would not fire.
From the Properties panel, I can get smack into the report header onp...
|
7 |
11/10/2008 7:01:01 AM |
|
|
Putting 2 different record sets on the same report line.
I have a summary table report that has a Table and a Query to pull
data from.
Right now the Table data is in each row of the report and the Query
data get placed below that in multiple rows based on the number of
records. I only have no more than 8 records in the query for each
table item so it should all fit on one page.
I want to show those query items in the same ROW as the Table items...
|
2 |
11/10/2008 2:07:07 AM |
|
|
ADDING COMPANY LOGO to A REPORT
I have a copy of our logo saved in word.
I copied and pasted it to my report and it appears perfectly on the screen.
When I print a copy of the report the border of the logo appears but inside
the frame is blank.
How do I get the actual logo to appear?
Currently I am printing the report twice. Once from Access and then again
in word so that the logo prints onto the report.
--
Thanks, P...
|
3 |
11/9/2008 1:35:00 PM |
|
|
Report With 2 columns in Access2007
How do you create a report with two columns in Access 2007? I couldn't find
anything in Help.
Thanks!
Steve
...
|
8 |
11/8/2008 4:53:20 PM |
|
|
Exporting Access 2007 Report to Word 2007
Exporting Access 2007 Report to Word 2007
--------------------------------------------------------------------------------
My Uncle has created a fairly straightforward Report in Access 2007 and
would like to export it to Word 2007.
Where is the means to do this (i.e. somewhere from within Word 2007
interface?)
He'd then like to add some page breaks to the exported Report, so .doc ...
|
3 |
11/8/2008 9:15:01 AM |
|
|
Need to know how to use a drop down list to populate a search field
I have a report that before it runs a search criteria field pops up and the
user then needs to type in the required search criteria. Once the search
field is populated the report then runs based on the search criteria [i.e.
date ranges]. I want to have a drop down list open up when the search field
opens so the user can populate the search field by clicking on an item from
the drop down lis...
|
3 |
11/8/2008 1:21:13 AM |
|
|
Grouping Issue
I'm having a problem with grouping and totals.
I have a form that the users select a date range and a report type and have
the option to select one or more physicians which then displays a running AR
total for the physician. If the user selects one physician it works properly.
If they select more than one, the beginning and ending AR balance of the 1st
physician in the report is added i...
|
3 |
11/7/2008 10:58:43 PM |
|
|
Totals
I have a report that lists whether a suite of a building is occupied
(Tenants's name) or vacant (vacant).
I am trying to create a total of all sqft that are currently occupied.
Meaning I need the sum of all sqft minus the sqft of those entries
where the Occupant name is "vacant".
And then I would like to creat a sum of all sqft where the occupant
name is "vacant".
Can anybody help wit...
|
5 |
11/7/2008 10:29:02 PM |
|
|
New Record At the Top of the List
All,
In a subform for notes I order by date DESC. This show my notes from Newest
to oldest. Which makes sense for our business purposes. We always want to
see the newest notes first. We also need the new note fields to be at the
top of the list. Access 2003 puts the new note fields at the bottom. Does
anyone know how to move it to the top of the list.
...
|
2 |
11/7/2008 10:23:01 PM |
|
|
Subtotal for a record
In my database I track what components are needed for a repair. It is
possible to have as many as three components per record (serial number).
Each record has (for needed components) 1st/2nd/3rd part number, description,
and cost fields. How do I get a total for the three cost fields for each
record (serial number)? Every formula I have tried gives me a grand total of
all values in t...
|
9 |
11/7/2008 10:21:00 PM |
|
|
Duplex Printing With Binding Margin (Gutter)
Hello All,
My turn to ask a question. I have some reports that print in
landscape, using both sides of the page, that I put into three-ring binders.
Some of them are over 160 pages so I want to put as much as I can on each
page and want to keep the paper usage to a minimum. I use the flip-up duplex
option. Does anyone know how to get Access to do binding margins or page
gutte...
|
5 |
11/7/2008 10:14:03 PM |
|
|
ACC2000 Month-Year sort in charts
I've read several of the posts about Date sorting, but nothing seems to fit
my situation.
I have a table of statistical data with a date column (called MthDte) for
3-letter month, 2-digit year entry, e.g., Jan 08, Feb 08, Mar 08, etc. The
Data Type for that field is set to Text rather than Date, since I didn't want
an actual date in the format, just Month & Year.
I set up a chart re...
|
2 |
11/7/2008 8:29:01 PM |
|
|
Email Outlook confirmation
I use docmd.sendObject to send out my report by email.
Outlook has confirmation prompt to click on yes.
Are there any work around for this?
It will be nice to have user send out email without Outlook message.
Your help is great appreciated,...
|
9 |
11/7/2008 5:16:18 PM |
|
|
Dlookup issue
Hello,
I am trying to set up a Dlookup in a query.
My Dlookup field will retrieve data from a second query. The match
criteria is the W field. This dlookup up process has to retrieve 24
different values from the second query (Query5). Unfortunatelly the
function always brings the first value of the 2nd query for all the 24
fields.
My formula is the
Expr10: IIf([ph4]="Stock4";dLookUp(...
|
4 |
11/7/2008 4:54:36 PM |
|
|
Excel To Access
Hi,
I have a report that is based on information in Access. It tracks periods
of time for each job - quoted to approved to repaired to complete. I ran
query and put all records to an Excel spreadsheet. Boss has come back with
extensive calculations that he wants to put in a report in Access to run on
regular basis instead of calculating in Excel each time data changes.
The first ...
|
11 |
11/7/2008 2:09:42 PM |
|
|
Reports Printing
My Final printout report is made up of 19 other reports in it. One of the
reports in my final printout report is called financials. This report
Financial is made up of 3 other reports called F1, F2 and F3 and the reason
is for my team to be able to compare three Annual financial reports of any
three given companies whereby F1 being the Main Company and F2, F3 being the
competitors.
F1, F2...
|
2 |
11/7/2008 12:25:12 PM |
|
|
printing multi reports
My Final printout report is made up of 19 other reports in it. One of the
reports in my final printout report is called financials. This report
Financial is made up of 3 other reports called F1, F2 and F3 and the reason
is for my team to be able to compare three Annual financial reports of any
three given companies whereby F1 being the Main Company and F2, F3 being the
competitors.
F...
|
2 |
11/7/2008 12:25:04 PM |
|
|
sort by total in report?
Hi all
I'm designing a very simple database for my college radio station to track
how many times albums are played on the station. Ive got it set up to show
the total number of plays on the report, but was wondering if there is a way
to have the report sort by the total so that it can show the most played
album at the top of the report. Any ideas how to do this or is it even
possib...
|
3 |
11/7/2008 5:43:01 AM |
|
|
Conditional summing of values
I have created a report from a query that includes an equipment "start up
date" and an "estimated days" required for equipment startup. The query and
report includes all equipment that has shipped but has not been started. I
can accurately sum the "estimated days" for the entire report, but I also
need to calculate the "estimated days" on only the equipment has a "start up
date" 90 da...
|
2 |
11/7/2008 5:36:01 AM |
|
|
Priority
I'm working on my first db and have moved on to creating reports. I have a
table for Subjects with a field for priority. This table is in regards to
substitute teachers and their preferred subjects. I would like the report to
list the subjects with the sub teachers name who has priotized that subject
as one of their most preferred. A sub can be listed multiple times on the
report for eac...
|
3 |
11/6/2008 8:19:04 PM |
|
|
trouble shoot subreports
Hi All
My question in a nutshell I have a rental database which works like a charm
however on my reports data which is accessed from tables via a union query
prints the embedded subreport three times on my parent report This I have
tried torectify without success - I think it is safe to say i am missing
something somewhere - Please help
Thanx...
|
3 |
11/6/2008 7:26:04 PM |
|
|
Totaling
I have report based on Tissue Samples, How can I total the number of "Yes"
Tissues Sent and "No" Tissues Sent
Thank you in Advance
--
thomp...
|
3 |
11/6/2008 7:14:07 PM |
|
|
subtotal with condition
I have a report that has properties for Sale and for Lease. I have all
for lease listed first, and all the sale listed after, each with
building sqft.
I have a subtotal for each broker giving me a combined total for sale
and lease.
I would like to have a subtotal for all their sqft for lease and a
subtotal for sale.
I used: =Sum([Building Sqft]="Sale")
and it won't work :-((
any hel...
|
2 |
11/6/2008 6:20:01 PM |
|
|
on report open, query date
I've looked through previous questions about this, and I can't seem to find
what I'm looking for.
The issue: When the end user opens a report I want a date parameter
drop-down list of the date ranges (see next paragraph) for the user to choose
from.
Database has date ranges that are manually keyed into a table, e.g., Jan
1-3, Jan 4-10...one date range per record/row. When the user...
|
4 |
11/6/2008 4:57:14 PM |
|
|
Not publishing reports to word properly
Hi there
I am generating a report using access and then pulishing it to word. All the
data is shown in the report, but it is not all shown in the rtf... It is cut
short after one of the lines on the second page. Anyone know why this might
be happening?
Thanks...
|
1 |
11/6/2008 4:41:01 PM |