|
I want to not count something
I have a report with columns. At the bottom of each column is a count feature
which counts the number of expressions in that column. =Count([Expr2])
Now I want to modify it so that if Expr2 is "SampleText" then it won't count
that. How do I do this?
...
|
2 |
23.08.2006 17:57:00 |
|
|
Language Messed Up
Hi Folks. For some reason, all of the sudden, the dates on my reports seem
to be displaying (and printing) in another language. Any tips for me. I've
already checked that my default language is set to English.
Mike
--
Message posted via http://www.accessmonster.com
...
|
1 |
23.08.2006 17:18:37 |
|
|
Adding Another Footer In A Report
Hello all,
i have designed a invoice in my report and everything works fine expect when
i add a field to calculate the total for the invoice. The field appears after
every item on my report when i want the total only to appear once on the
invoice. I think i need to add another footer to accomodate this field. How
would i add another footer? All help would be great :) ...
|
2 |
23.08.2006 19:08:21 |
|
|
Having trouble creating a series in graph that is dependent on tab
I am trying to make a stacked bar graph. The total amount for the bar is the
summation of the same field from 3 different tables. How do i group this so i
can see how much each table contributes to the total amount of the bar. I
need the series to be, Math Data, People, and IssuesHere is my SQL statement
so far. This gets the sum right, bu tonly displays one color.
SELECT Null,Sum([Issu...
|
1 |
23.08.2006 18:49:03 |
|
|
conditional picture
In the report i have to make, i need to output a picture instead of a value.
The picture that is put on the report must coincide with the value. as an
example. If the value is 1 i need a red x, If it is 2 i need a Yellow
triangle, and if it is 3 i need a Green Circle. How would I go about doing
this??...
|
3 |
23.08.2006 18:42:02 |
|
|
Bug? Report displaying Chinese character sometimes but not always
I have a report that displays results based on criteria selected in a
subform. When a field is left to the default "all" my comments field
displays correctly. However, when any value is input into my search field,
the comments displays as a Chinese character.
Any assistance would be greatly appreciated!...
|
7 |
23.08.2006 17:42:01 |
|
|
cangrow text beside and under image
I am creating a student directory where I have data in canshrink and cangrow
txtboxes next to and under image. The report is a 2-column report, so output
is something like this:
txtbox1 -------------------------- txtbox1
--------------------------
txtbox2 | |
txtbox2 | |
t...
|
3 |
23.08.2006 17:25:58 |
|
|
Filter Function in Report Open
Im trying to use this code in the Open event of a Report:
Private Sub Report_Open(Cancel As Integer)
If ([Forms]![frmJobSetup2]![SelectJob].Column(2) <> "") Then
Me.Filter = [Forms]![frmJobSetup2]![SelectJob].Column(2).Text
Me.FilterOn = True
MsgBox Me.Filter
Else
End If
End Sub
to dynamically filter reports based on a selection from a combobox. If I do
it using the filter pro...
|
1 |
23.08.2006 16:48:02 |
|
|
Subreport not displaying all info
I have created a main report and a subreport.
The main report has a beginning and ending date parameter.
The subreport is based upon a query that is based upon a query that is based
upon a query that was used for the main report.
All queries run as they should when opened individually. The main report
works as it should.
The main report and the subreport are linked by PaymentDate....
|
7 |
23.08.2006 15:42:07 |
|
|
Search Not Working Correctly
I am using Access 2003, and when I search for numbers in any field, the
computer times out. When I search for any alpha characters, I get a response
(I find what I entered). I have searched for numbers in different fields and
get the same response (none), and I have searched the whole field and any
part of the field and still get no response. Why would my database find alpha
and not nume...
|
1 |
23.08.2006 14:07:02 |
|
|
Merge a Report to Word
Is it possible to keep the formatting of a report when merging it to word...
or is it possible to extract reports any other way in order to e-mail them to
clients?
Many thanks ...
|
5 |
23.08.2006 14:05:18 |
|
|
how do I show from and to dates on a report or week beginning
I need to show week of .... on a report I have a parameter set up in the
query between start date and end date but can't get it to transfer to show
on the report...
|
3 |
23.08.2006 13:40:02 |
|
|
Reports objects and wizards hang up
I am having problems accessing MS Access reports on my company computer.
I am unable to open exiting reports. There is no reponse to the Reports
design icon. New - Report wizard and AutoReport return a dialogue "The wizard
is unable to create your report".
I am running MS Access 2003 with Windows XP professional SP2 with all
available updates.
Please can you suggest any solutions oi...
|
3 |
23.08.2006 13:34:02 |
|
|
Database Map
Anyone ever heard of a Database Map?
I need to create a "Database Map" for the custom database I just finished.
I don't even know where to begin! It's a little puzzling. I think the end
result should look like a flow-chart. But the map should also list all the
database objects, and how they are linked/joined with other objects (ie
queries).
Has anyone done anything like this be...
|
5 |
23.08.2006 12:52:12 |
|
|
Format Property bug: "hh" doesn't display leading zero
A number of closed topics deal with problems displaying military time
with various suggested solutions, but none of the discussions I have
seen mention that the the underlying problem seems to be a bug in
Access' Format Property.
I was unable to find a discussion of this problem in the Microsoft
Knowlege Base.
Military time (and many scheduling and dispatching applications) always
displ...
|
16 |
23.08.2006 11:50:33 |
|
|
Date Range Query Information in a Report
Ok, I have battled this one for years and have never found an answer.
I have query criteria for a report Between [Enter Begin Date] And [Enter
End Date]
How would I get the Begin Date and End Date on the report Header?
Thanks,
Andy...
|
5 |
23.08.2006 08:32:01 |
|
|
Problem with JPG Image Import: Access Gets Tired
I've got a weird problem with an Access 2003 report. Each row of the report
presents the data from one row of the database, including a zoomed-down
thumbnail of an image. The database actually contains the filename of the
image, which is imported during the report's Format event. In the event
that the import fails, since some images may legitimately be missing, the
image is made invis...
|
2 |
23.08.2006 06:45:07 |
|
|
Report footer at bottom of last page
Most suggestions on this topic recommend to use a page footer and make
it visible only on the last page. My problem is that the footer is half
of the height of a page which means the detail would show on only the
top half of each page with whitepace at the bottom of each page.
How can I get the detail to fill each page with my "half page height"
report footer at the bottom of the last page?...
|
1 |
23.08.2006 06:05:59 |
|
|
>> Custom Printer bin/tray
Hi, there are plenty of sources on the net on how to retrieve and set the
default printer in windows. These sources include methods to set the printer
bin/tray when the bin/tray internal number matches a defined list from 1 to
15. In addition there is 256 for "Device-specific bins start here".
My problem is that the printers that I want to provide for, have numbers
starting from 257. Wh...
|
1 |
23.08.2006 04:14:01 |
|
|
Conditional parameter value
Hello All
I have a textbox on a report with the following expression:
=IIf([bacs direct]=True,UCase([Enter pasword for WAGES]))
The problem is that the parameter value [Enter pasword for WAGES] is
requested whether or not [bacs direct]=True.
I only want the parameter value to be requested if [bacs direct]=True - if
[bacs direct]=False I do not want to to be asked for a value for [Enter...
|
7 |
23.08.2006 03:02:48 |
|
|
How to set a custom default value on report or VBA Code for this?
How do I do this with VBA code?:
If txt1 and txt2 is = 0.0 display nothing, if else display whatever this
else is.
Thank you,
Adnan
--
Please post all your inquiries on this community so we can all benefit -
Thank you!...
|
3 |
22.08.2006 23:55:01 |
|
|
Report and Query Parameters (Yet again!)
I'm not sure I understand the use of parameter queries and reports.
I have a query that returns calculations for Categories. There are 6
Categories (A,B,C,D,E,F).
There are also two Types of results Y and Z.
The result may not have all Categories or Types, because there may not
have values yet for a particular Category and Type.
I called this query qryTotals.
Here are the results....
...
|
2 |
22.08.2006 23:43:02 |
|
|
Vector images ability?
Is there any kind of way to display/print vector images on an access report?
Kan
...
|
3 |
22.08.2006 21:18:52 |
|
|
Linking fields from a report to a chart
I am trying to link a child field and master field from a report to a chart,
however, I keep getting the message "Cannot build a link between unbound
forms". What does this mean?
--
Ronnie...
|
2 |
22.08.2006 20:51:18 |
|
|
ListBox/input box in detail section 'on format' event
Hello, MVPs, and thanks for all your help!
There is a report that is being migrated from Crystal Reports so that
the report will be available with the database. We run a sql server
2000 backend with an a2k front end and have been traditionally using
crystal as the reporting engine. This is my first foray into access
reporting and after 6 years of crystal, the last couple months of
acces...
|
1 |
22.08.2006 20:48:56 |