|
Sub Report Procedure
I have created 2 Reports based on indepent queries (but child master linked).
The 2nd Report contains a procedure (to insert a set amount of lines 'On
Print)). Both work well alone.
I have inserted the 2nd report as a sub report into the first report.
When I print (or print preview) the 1st report is ok but I get a 'The
expression ON Print you entered as the event property setting produced ...
|
1 |
08.09.2006 09:31:01 |
|
|
Group by Name, Sort by Count
I have a report where I want to Group by the CallerName, but then sort
by the Number of Calls. Using the sorting/grouping, if I group by
CallerName then it wants to sort them. If I put the NumberOfCalls in
the sorting/grouping, it groups on the values of it, so if a couple
callers have the same number of calls, it only shows the first
instance.
Basically I want the output to look like thi...
|
7 |
08.09.2006 08:10:17 |
|
|
Auto top 10 in report
Hello,
I am a beginner in Access and i like to know if someone knows how to
make an automatical top 10.
example:
1 .......
2 .......
3 .......
4 .......
5 .......
what i want to know is how to get automatically the numers 1 / 10.
is there a special expression?
Many thanks in advance.
Nick
...
|
3 |
08.09.2006 07:06:00 |
|
|
How do I remove a parameter value request from a report?
I've created a report and am unable to open in print preview because the
expression Enter Parameter Value keeps popping up. I have removed the sorting
and grouping and this did not fix the problem. Please advise. Critical! Must
meet 9/8 deadline....
|
2 |
08.09.2006 05:01:19 |
|
|
Want report to pull data based on acount # on form.
I have a form with general account info. I would like to add a command
button that when clicked would launch a report that pulls all associated
service info for the account showing on the form. I've tried building the
report through query and by linking the tables in the report wizard. By
itself, the report runs (although it shows all the service info in the file
for every account) bu...
|
4 |
08.09.2006 03:58:14 |
|
|
Trying to change report title during report open event
I am trying to change the title of the report depending on the button used to
choose the report. Here is the code:
Private Sub Report_Open(Cancel As Integer)
Dim x As Integer
Dim base_title As String
base_title = "Comerica Continuous Audit Idea Status Report"
x = Forms!SFRMCA_SELECT_STATUS_RPT.ST_R_FLAG
Debug.Print x
Debug.Print base_title
...
|
3 |
08.09.2006 03:40:02 |
|
|
formatting initial caps
A name in my db is all caps like this: ST MARY COMMUNITY CHURCH. The name is
all in one field. I want the output to be initial caps only, like this: St
Mary Community Church. Is there a way in either an Input Mask or by using
the Format function, or other, to create initial caps?...
|
2 |
08.09.2006 03:03:31 |
|
|
report design
I am trying to create a report to reflect current job postings. I can import
the open job reqs into a table. This table does not include a job description
or educational requirements.
My question is, what is the best way to tie a job description and
requirements to a report as it relates to the main requisition table?
...
|
1 |
08.09.2006 01:25:43 |
|
|
Is it possible to move an Acces report into Crystal Reports
...
|
4 |
07.09.2006 23:19:51 |
|
|
Report header code looping for unknown reason
Hello and thanks for the help. This is my first foray into Access (2k)
reports and i'm having a hard time of it. In this particular report,
there is a report header, page footer and report footer where there
exists a subreport (I think of this report as a cover sheet used only
under certain circumstances). In the report header, my code loops for
no apparent reason, at least, not one that I...
|
1 |
07.09.2006 22:27:46 |
|
|
Why =sum([BilledAmount]) doesn't work
Hi all,
On my report,I set a textbox's control source =sum([BilledAmount]) but
doesn't work, when i run it has #Error.
My original data type for BilledAmount colume is Text, but when I query I
used CDbl(BilledAmount) to convert to double. What should I do in able to sum
at the footnote of the report?
Thanks...
|
9 |
07.09.2006 21:52:02 |
|
|
Format Date with Text
I am trying to put the date with text in a text box on a report but can not
figure out the syntax:
="Dated on " & Format(Date(), mmmm dd","yyyy) & "."
So I want this to show on the report: "Dated on September 7, 2006." I need
to format the date. Can all this be done in single text box?
Thanks for any help....
|
2 |
07.09.2006 19:56:54 |
|
|
Report Queueing
Is it possible to queue reports for printing in Access so that they can all
be printed at once?
I'm trying to cobble together a customer service database. Info is gathered
from a web contact form, and then handled by an administrator. Depending on
whether or not the contact is a compliment, complaint, or request for
information, a letter will be generated. I've got this part working usi...
|
1 |
07.09.2006 19:28:02 |
|
|
text box splitting across two pages
Hello,
I have a report with several text boxes in the detail section. There is a
page break after these boxes with more information on the next page. I also
have a subreport also in the detail section that is a datasheet that varies
in length and causes the text boxes to end up either on the first or second
page. The problem is when one of the text boxes is split horizontally
between...
|
3 |
07.09.2006 18:20:02 |
|
|
Text box alignment
This is a problem that affects lots of us and bothers the heck out of me. I
haven’t seen a resolution to the problem either.
When I add a text box to my report, the label and text box do not line up.
When I try to bottom align them, the objects themselves align correctly, but
the text within do not. It isn’t off by much, but it drives me nuts to see
them not “in line.†Chang...
|
1 |
07.09.2006 18:15:01 |
|
|
How do I show monthly data?
I work for a nonprofit org. Our donors give funds to specific causes usually
on a monthly basis. I need to generate a report that lists the donations by
cause over a three year period, catagorized by month. Each cause can have
several donors and I need to seee the donors grouped separately. I can get
it to generate a report with the information I need but it lists the
information in ...
|
2 |
07.09.2006 17:51:30 |
|
|
Using the sum option for 2 different codes in the same field
I want to use the Sum option on my report but I have 2 different currency
codes on the same field (MN and USD). How may I get a report with these two
codes separated? First all the expenses based on MN and then all the ones on
USD. I have this field using a combo box (created with the Wizard)...
|
11 |
07.09.2006 17:23:48 |
|
|
Adding up dates for a total
I have a database that I am tracking testing status of customers and need to
add a total to a report. I would like to get a total number if customers that
have a date in a particular status. Example:
Contacted Testing Approved Production
Customer A 01/01/06
Customer B 01/05/06 01/10/06
Customer D 02/15/06 02/20/06 0...
|
3 |
07.09.2006 17:14:01 |
|
|
Null value in two columns used for grouping are causing report to
Basically I have 3 groupings
ex:
Group 1 field
Group 2 Field
Group 3 Field
Group 1 and Group 3 have null values in the entire columns of result set
being used to generate the report. This is causing the report to show no
records/data in the detail section of the report and the word 'Error" in all
grouping headers.
Is there any programmatic way to fix this or by changing t...
|
1 |
07.09.2006 16:33:02 |
|
|
expression for invoicing $2.00 per unless under 25 or over 751?
I am using access 2003 and am trying to create an invoice in "REPORTS" that
will calculate the membership fees based on the number of students enrolled.
I need it to calculate the following excpetions. If the #of students is 1-25
= flat rate of $50.00; 26-750 is $2.00/student; 751- = flat rate of $1500.00....
|
1 |
07.09.2006 15:28:02 |
|
|
report mail
Hi all
I have the report which has 8-10 pages based on the name of sampler.
I want to email each sampler seperately his own page,But when I try it
emails all 8 pages to each of them.
Is there any way so that I can e mail particular page to particular
person
thanks
anil
...
|
2 |
07.09.2006 15:26:03 |
|
|
Sorting in a report
I have a report set up that only shows subtotals, no detail. I would like to
sort by the subtotal. I tried putting a calculation in the field/expression
section of the sorting and grouping box but that didn't work. Any thoughts?...
|
9 |
07.09.2006 14:52:02 |
|
|
Entering a line-break in a Label from VB
Hi folks,
I was tring to make a multiline label in a report. I wanted to seperate the
last line (from the one before) with an extra blank line. I used the
following:
label = label &" bla bla bla" & chr$(10)
label = label & "Email: " & txt_email
What I am getting behind the bla bla bla is a little square and then email
appears right after that.
What am I doing worng?
Thanks
...
|
2 |
07.09.2006 09:37:13 |
|
|
Email Individual Records within a Report / Query
I have created a query to identify the accounts that require attention.
My hope is that we can create a report that would contain only the
information for the first record and automatically send an email to the
account rep, and then do the same for the 2nd, 3rd, 4th, etc record.
The idea is that each record would go out as an independent email so
that they only receive information for those ...
|
3 |
07.09.2006 08:32:08 |
|
|
Filling out a Word document
Hello everyone,
I've been racking my brain trying to figure this out and have hit a
wall. Hopefully someone has an idea for this situation.
I have a query that gives me a list of teachers and their students.
Each teacher has multiple students. I have a paper form that is in
Word. The paper form has a table that has 15 blank rows for student
names and many boxes across for check marks. It's...
|
3 |
07.09.2006 08:31:50 |