Sorting Reports & Combining categories
Mon, 3 Nov 2008 13:05:02 -0800
I have a report that I need to sort by customer type and alphabetically by
name.
We have three customer types, let's call them A, Bsub1, and Bsub2. I would
like to sort these customers into groups by their type and then
alphabetically, but would like to combine Bsub1 and Bsub2 so that we have
them in o ...
|
report with several unbound fields
Mon, 3 Nov 2008 12:58:17 -0800
I have a report that has several unbound fields. If one particular field is
blank I want the whole report to be blank in print preview
...
|
Conditional formatting problem
Mon, 3 Nov 2008 10:50:01 -0800
Hi
I have a report based on a student grades crosstab query with a number of
different cases:
a) Point scores
b) Residual point scores
c) Grades
d) Grades (with Residual scores)
I have successfully used code to apply conditional formatting where the
field values are numbers i.e. a) & b) above
e.g.Set f ...
|
Graph in Access Report
Mon, 3 Nov 2008 09:05:01 -0800
I have created a database that tracks sales prices of homes in various
developments in my area, going back eight years. Ideally, I would like to
be able to insert an 'micrograph,' like you see with stock reports, that
gives a quick visual as to the performance of each development. I cannot
find such an a ...
|
Numbering Labels
Mon, 3 Nov 2008 08:40:01 -0800
I need to print labels that consist only of a single number! When the report
is opened a dialog box "frmMaxNo" opens and asks for the Last number and that
value is inputted in text box "txtMaxNo". When you click "OK this form is
minimized and the report opens in print preview.
I have a text box in the deta ...
|
How do i create a report to be used as a form to track attendance?
Mon, 3 Nov 2008 07:24:01 -0800
i need to create a report/form that i can hand out that will contain the
following;
class [this would be from a query] Lname Fname 11/02 11/09 11/16
the date fields would have a box below each date [] [] [], woul
like to have the date ncrement by 7 for 1 quarter. i would print this form
each qu ...
|
Conditional highlight
Mon, 3 Nov 2008 07:09:02 -0800
Access 2007 I would like to highlight a text box (border style) based on a
value in another text box.
I have tried OnGotFocus and AfterUpdate and OnFormat for the detail section:
no joy.
Any advice on how to do this?
Both text boxes are direct from the table record, not calculated within the
report.
Many T ...
|
|
|
Lebans ConvertReportToPDF on 64 bit PC
Mon, 3 Nov 2008 12:40:39 -0000
Access 2003.
Has anyone got this working on a 64 bit PC. When I try running it I get the
message that it cannot find the dynapdf.dll and strStorage.dll. I think the
problem is that it cannot load the dll's, rather than cannot find them, as I
am logged in with Administrators rights and have checked access to ...
|
Bar code
Mon, 03 Nov 2008 04:10:17 -0800
i am writing a program which is capable of printing a specific bar code.
software include text box and we input the data use with a font (Times new roman) and i need to convert that font in to a bar code font and to print through the program. can u please send the codes for it. assume for a one text box. thank you ...
|
Subreport groupheader appears although there are no records tot sh
Mon, 3 Nov 2008 02:19:00 -0800
In access 2007 subreport headers appear although there are no records.
This was not the case within access 2003. Now my reports look a little silly
since in my reports I sometimes have subreports containing no data. I do not
want to see their headers then.
Doe somebody no how to re create the former functional ...
|