|
Charts - Legend Colours
I have a Pie Chart and a Legend and I want to match the colours up to
specific colours, i.e. Legeng is..
Red
Amber
Green
Blue
and I want the colours on the Pie to be Red, amber, Green & Blue to match
the legend.
Is this possible ?...
|
2 |
19.09.2006 23:41:28 |
|
|
Report Format
I created a report and would like to use the format in other databses. How
or is it even possible to take just the format and use it with different data
in a different database?...
|
3 |
19.09.2006 23:40:20 |
|
|
Visibility problem
Hi Groupies!!
I am trying to make a field invisible based on the content of another field.
I don't think this should be that difficult, but I am unable to find out how
to do it.
My code is as follows:
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Me.strDeptName = "Occupational Therapy" Then Me.SumOflngPufHrsPT
Visible = False
End Sub
I keep receiving...
|
4 |
19.09.2006 22:59:39 |
|
|
Problem with multiple copies of report
I have an access report (actually a 5" round label) that I am trying to
print to a Zebra label printer. If I try to send a large quantity of labels
(continuous roll of labels) of approx 100 or more, Access will print 5 or 6
labels, pause then print 4-6 more, pause, etc. until all 100 are printed.
Does anyone know of a solution to end this pausing between reports?
Thanks,
Terry
...
|
2 |
19.09.2006 22:39:02 |
|
|
Sum in bottom of report
Hi all,
I have a field that your source is a Sql Query. I need show the sum of
field in bottom of report, but =Sum([field]) not functions, because
your Source is a Query SQL. how to do?
thanks
Michel Ank
...
|
9 |
19.09.2006 21:29:56 |
|
|
automatically emailing reports to users
Hello all,
I'm not very experienced with Access, I do more of SQL. I'm creating a
database for a college radio station to keep track of the songs they
play.
They want it to email playlists for every show to their music
department managers. I've already modified a database from a program
they use called CDTrustee (it gives lists and such of ALL the music the
station owns). The idea is...
|
2 |
19.09.2006 20:20:53 |
|
|
Limit toolbar options in ViewPreview?
In MS Access, how can I limit the options in ViewPreview of a report to
either print the report or to close ViewPreview?...
|
2 |
19.09.2006 17:46:04 |
|
|
adding text box under report header section
I created a report in access 2003 to be grouped by a certain field. I
wanted to move that field to the report header section but when I do
and go to print preview or try to print I can't see the data from that
field. I tried multiple fields and none will show. Labels show fine,
but not text boxs. The thing is it worked fine at one point and another
report that I created after this one is work...
|
2 |
19.09.2006 17:45:21 |
|
|
Question about VBA in the report
Hi,
I have a report that is based on a query, but I want to use VBA code to
force something to display in the textbox, according to what is store
in the table.
For example,
If text1.text = "yes" then
text2.text ="N/A" <-- I want to force textbox2 to show me N/A
end if
but this code will work in normal VB application, not in VB inside
access....
because it give me an error
...
|
8 |
19.09.2006 17:24:01 |
|
|
Report page numbers
I am compiling a booklet that consists of 5 different report designs - how do
I make the page numbers continuous instead of starting over with 1 for each
report?
--
Sandra...
|
2 |
19.09.2006 17:22:01 |
|
|
splitting a group into columns
I have this report that has too much white space in it:
MonthA
CompanyA
CompanyB etc
MonthB
CompanyA
CompanyB
I want it to look like this:
MonthA
CompanyA CompanyB
CompanyC CompanyD etc...
|
4 |
19.09.2006 16:17:44 |
|
|
counting values
Hi
I am having a mental block at the end of the day.
I am wanting to count the responses in a questionnaire. I have a field
called 'attending' and the possible values are 'valuable' 'okay' or 'not
valuable'. I want to report on how many thought that attending was 'valuable'
how many thought it was'okay' and so on. In my report I have used
=Count([attending]="valuable")
as the expressi...
|
7 |
19.09.2006 15:09:51 |
|
|
Colour coding query results using the report tool in Ms Access 200
Colour coding query results using the report tool in Ms Access 2000?
I know its possible but how do it do it?
Help...
...
|
2 |
19.09.2006 14:29:23 |
|
|
Display Last Entry in field footer
Hi, I have a report based from a query with the following fields.
Loan#
LoanName
Amount
Analyst
TransactionNotes
I have multiple entries within the detail section and I am only going
to display the footer where I have a sum field on the Amount. The
Loan#, Name and Analyst stay the same across all transactions but a new
note is occasionally entered, so sometimes the field is blank.
...
|
7 |
19.09.2006 13:59:39 |
|
|
Summary within a report
Having generated a detailed report/schedule of all upcoming school classes, I
want to summarize all these classes on the first page of the report. Is this
possible? Thanks in advance for your time on my issue....
|
2 |
19.09.2006 13:58:43 |
|
|
=[PowerBallTicketsSold]*"0.07%"
I have this in my control source of my report for commissions what am i doing
wrong...
|
3 |
19.09.2006 09:52:22 |
|
|
Report for Current Record
I have a control for printing details of an existing record only in a report
form with the following Onclick event procedure:
Private Sub Extract_Click()
On Error GoTo Err_Extract_Click
Dim stDocName As String
Dim strcriteria As String
stDocName = "Extract"
stcriteria = "Autonumber = " & Me.Autonumber
DoCmd.OpenReport stDocName, acPreview, , strciteria
Exit_Extrac...
|
11 |
19.09.2006 09:15:06 |
|
|
Export Access 2003 report to Word 2003 using XP
When I export a report from Access 2003 to Word 2003 using XP, some
characters are being truncated. If I export the same report using Win 2000,
there is no truncation. The report that I am attempting to export has about
10 columns with numeric figures under each column. The truncation drops 1 or
more right most digits when the number exceeds 9 positions. Appreciate any
assistance....
|
2 |
19.09.2006 07:24:15 |
|
|
Error with OnClose, linking to UpdateQuery
Me...again. :) I have a form where users can enter their initials to
identify records to print. The print report prompts for the initials to
return a specific subset of records. I have an UpdateQuery which prompts for
the initials to change the value to Null. Independently these work fine,
however, when I add to the OnClose property of the report I receive: "Runtime
error '3061': To...
|
7 |
19.09.2006 00:50:01 |
|
|
Create a Report by Entering Data
Is there a way to create somethig in Access (report, form) in which there
are several fields and the user enters just the field info with the criteria
that he wants to pull out from a table or querry?
In other words, let's say I have 5 fields (first name, last name, address,
city, state). Could something be created in which the user enters, for
example, in the Last Name field "Roberts...
|
3 |
18.09.2006 21:12:02 |
|
|
Create paragraph format of data
I am trying to pull data from a master table that has several fields. I want
to pull one field, then add a period, then a space, and then data from the
other field. This is what I have tried:
Master Table Fields include:
Type of Observation: "Major Deficiency"
Observation: "Person did not do anything"
Supporting Data: "They ignored their boss"
I want it to come out like this:
M...
|
3 |
18.09.2006 19:58:01 |
|
|
how do I change tables with-in a report without starting over
I created a report using a table but I forgot to arrange in ABC order. I went
back to the table and arranged it in ABC order but when I go back to the
report it's still not showing in abc order? Is there a way to delete the
table from the report and pull the table that is in ABC order without having
to redo the report again? Please say "yes"...............
|
7 |
18.09.2006 19:45:44 |
|
|
Passing arguments between a main report & a sub report.
I need to count the number of records for a (complicated) condition in a main
report then add to that count the number of records listed in the subreport,
then print the total count (in either the main or sub-report, I don't think
it matters which).
eg: main part of report list (by query) all students that receive meals and
indicates (marks) which of those students may also receive milk...
|
1 |
18.09.2006 19:33:02 |
|
|
Report Question
I am not sure how to proceed with a report I am creating.
The form that I am using to gather the criteria for the report has two
listboxes (with multiple selections allowed) and two text boxes.
Can I create the query on the fly within the form? Could someone point me
in the right direction?
...
|
4 |
18.09.2006 18:58:24 |
|
|
DoCmd.OpenReport not opening subreport
Hi all
I have a report that runs on a query (duh) :).
I set up a combo box on a form to select these parameters.
The code of the "OK" button includes a DoCmd.OpenReport so it'll go
straight to the report rather than runnin the query and then including
an event trigger to run the report once the query has been run (or
something like that).
However, when the report is run, the (2) sub...
|
3 |
18.09.2006 17:40:42 |