|
dynamic caption
Is it possible to dynamically fill-in the caption on a report?
What I want is "MyReport" & DatePart("yyyy",Now())
thanks
...
|
2 |
12/23/2008 1:31:11 AM |
|
|
getting one image per group in a report
I have a report that shows a student's name and ID in the name header
(grouped) and then shows about 8 or 9 narrow detail rows, each listing
one of their subjects and the corresponding grade.
Using the ID and a folder of pictures I've put an image box in the
header to show the student's picture next to their name. However this
makes the header rather large with lots of white space and m...
|
3 |
12/22/2008 9:53:45 PM |
|
|
Number formatting...
I am working on a year end report that totals of monthend queries. There are
some categories have a value of 0, but they are left blank. This makes the
report look awkward. Is there a way to format these blank records as a 0?
Any help would be greatly appreciated....
|
2 |
12/22/2008 8:56:07 PM |
|
|
Pivot Chart, second level category
Hi,
I am creating a pivot chart, the X category has two levels of grouping,
first level by model year and second by Month. By dropping modelyear first
then month second in pivot chart view, the pivot chart shows up the two level
grouping nicely. However how do I do this using VBA? Thanks.
Lydia
--
Lydia Liu
Access/VB Programmer
...
|
1 |
12/22/2008 8:28:03 PM |
|
|
Access Report sent to Sharepoint Server
I have several reports created in Access. I would like these reports to be
accessed on Sharepoint Server in PDF format but I don't want to send the
whole database to Sharepoint. I haven't found anything that gives details on
this. Any suggestions?...
|
1 |
12/22/2008 5:55:01 PM |
|
|
set a report
Hi,
I want to set a report 8.5 in x 22in, is it possible? i cant find this paper
size in my epson LX-300 driver.
or is it possible if i set a paper size more than 22 in?
Thanks for your help
--
Message posted via http://www.accessmonster.com
...
|
4 |
12/22/2008 5:08:43 PM |
|
|
Access Subreport from Concatenated Query
I have created a query where I concatenate (based on the basConcatenate
module sample created by Duane Hookem) comments from evaluation forms. The
problem I am having is that I need to filter the query or the results on the
subreport by date.
For the main report and other subreports I am using a Date Filter Dialog
form (similar to the example on Northwind) but when I try to do the sa...
|
5 |
12/22/2008 3:57:02 PM |
|
|
Best Way to Create Custom Filtering on a Report
Hi all,
Here's my situation.
I have a report (Report_1) based on a query (Query_1) which contains the
following fields:
Staff name (text)
Manager name (text)
Location (text)
Client (text)
Key client (yes/no)
Date payment due (date)
Overdue (yes/no)
I want to create some sort of filtering interface at the top of the report,
which lets users filter records from a par...
|
13 |
12/22/2008 10:14:00 AM |
|
|
all records on one page
Ok, I have done this before but cannot for the life of me remember how. I
need to group all records pertaining to one customer on a one page letter.
Example:
One customer has three dogs. I need to send a renewal letter to the customer
and want all three dogs showing up on one letter, to run in a batch with all
the other owners.
I have query that pulls all my owners by renewal year, ...
|
2 |
12/22/2008 4:38:35 AM |
|
|
Creating An Access Report To Group Payments Of Equal Amounts
I am new to MS Access and need to do the following:
Write a report that groups payment of equal amounts for each vendor together.
Ignore the sign (positive or negative) of the amount. Ignore groups with
only one record. For each vendor show a group header containing the vendor
number and name.
For example if the GrossAmt is $100 in one record and the GrossAmt is $-100
in another r...
|
2 |
12/22/2008 12:09:01 AM |
|
|
Counting Records in report footer
I am trying to count records in the report footer when a certain condition
exist when calculating the difference between two fields, ie ([field
1]-[field 2]) = 0. Only count the records that match the results. Any
suggestions?...
|
5 |
12/21/2008 8:00:01 PM |
|
|
Combining two date fields in a report
I have an existing database with "LastName", "FirstName", "Birthdate",
"SpouseName" and "SpouseBirthdate" fields. I want to create a report that
combines the "Birthdate" and "SpouseBirthdate" fields into one and have them
all print in chronological order.
Help!...
|
5 |
12/21/2008 3:05:01 PM |
|
|
Subreport parent reference
In a subreport Sub I am trying to pick up the value of a field in the parent
report, using Me.Parent!txtBox. I get an error saying You can't reference a
property for a control unless that control has focus. This control is in the
detail section of my main report and I'm in the Detail section of my
subreport.
So is this possible or do I have to pass the info somehow to the subreport?
...
|
11 |
12/21/2008 7:53:00 AM |
|
|
Display two pages at once.
I now have a wide-screen monitor.
How can I make Access2003 default to showing (displaying)
two pages, side by side, on the screen .
I can do this manually, but I need it automatically.
Please help, Frank
...
|
3 |
12/20/2008 4:24:52 AM |
|
|
Auto fill
I have a table (and form) that list Organs that have cancer. I want fill a
text box with the word "Yes" if the Organ is Brain, or Lung.
Any ideas?
Thanks in advance.
--
thomp...
|
3 |
12/19/2008 7:16:32 PM |
|
|
Formatting
How can I format the following so the output will be % vs. currency?
=IIf(([Method])="Percent",([Percent]),IIf(([Method])="Amount",([Amount]),''))...
|
2 |
12/19/2008 6:44:01 PM |
|
|
first 5 records
Hi Guys
I have a reports sorted and grouped by the field machine, but in the detail
I just want to show the first 5 records for that group. Any help will be
appreciated
Thanks
...
|
2 |
12/19/2008 5:25:01 PM |
|
|
Keep subreports together in Access 2007
I've created a lot of Access reports over the years, but none with as many
subforms as this one. I'm creating a report that has a natural grouping on 1
field (LD_ID). However, this report has about 10 subreports associated with
it, and I want to ensure that each subreport is kept together with all of its
details.
I found some posts that related to this, and have created a bunch of
a...
|
2 |
12/19/2008 4:56:57 PM |
|
|
Total in Access Reports
I am running a report that will display tunits for each member of our
association. There are around 250 records that will have numerous tunits for
different items.
I am trying to set up a total of tunits for each member in this report.
tunits: Sum(IIf([units]=999000,0,[units]))/100
and the total at the end of the report is
=Sum([tunits])
All I get on the report is #error
what am I ...
|
7 |
12/19/2008 4:44:59 PM |
|
|
Query fast / Report slow
This is a bit a repost, but new information (or basically an entirely new
problem) is available.
I have a pretty complex query that only takes a second to product the desired
result. The query is large made up of 16 or so other queries. The number of
queries is due to the calculations needed for each product to be displayed in
the query and eventually the report.
The report is for e...
|
4 |
12/19/2008 4:11:46 PM |
|
|
what paper size?
I am setting a report, (like minimarket sales invoice ) when my report has
print the footer note, the printer have to stop print, the paper wide is
about 3" and the long is unlimited.
1.How do I do this?
2.What paper size should i set?
Thanks a lot...
|
1 |
12/19/2008 7:58:01 AM |
|
|
Snapshot files will not open
Hi.
I have Windows XP Professional Version 2002 Service Pack 2 and have just
upgraded from Office 2002 to Office 2007. Now, none of my snapshot files will
open. Does anyone know how to fix this?
Any help provided is greatly appreciated.
Thanks
...
|
2 |
12/19/2008 12:57:01 AM |
|
|
queries MS Access 2003
I have a table with start date and end date, and I would like to create
"MONTHLY" report based on the month of star date. Let's say if start date is
12-18-2008 then I would like to call it December 2008 report. If start date
is 11-18-2008 then I would like to call it November 2008 report. If start
date is 01-18-2009 then I would like to call it January 2009 report. Also, I
would like ...
|
2 |
12/18/2008 11:01:11 PM |
|
|
*REPOST* If then Else Statment in Report
Someone tried helping me out with this before, but we couldn't get the
equation he suggested to work:
I currently have an if then else statment in my report that adds the sum of
another field to the sum of animal births (if animal births has data). I
would however like this whole equation to=0 if nothing is reported, however
instead it has an #error.
I thought that edited the equa...
|
13 |
12/18/2008 9:37:00 PM |
|
|
Adjusting print margins
I've got a report that has a left margin of .75" and right margin of .25".
I'd like to add some code to one of the forms events, that would shift this
to left (.25") and right (.75") when a report item wraps to a second page.
Basically, what I want to do is leave room for hole punch on the left side
of most pages, but if the report extends beyond one page for a particular
item, I want...
|
2 |
12/18/2008 6:37:32 PM |