|
If controls in subreport are null, dont print black page
/diagram
<header>
<subreport1>
<subreport2>
<subreport3>
/end diagram
each sub report eats a full page.
i am testing for null and setting the visibile property of the subreport and
page break to false. still getting a blank page (with header) for the hidden
subreport.
on the details format event:
if isnull(Report_thatreport.thatfield) then
Report_t...
|
3 |
18.09.2006 16:35:52 |
|
|
Printing Multiple Reports
I have set a button up on a form so the user can print out reports for
distrubution. Depending on the branch it will print different reports out.
Some time a report will have no information on it and I want it to not print
but then continue on to the next reprt.
I have tried adding the "No Data" event to the report but then if one report
at the begining has no data the rest of the reports ...
|
7 |
18.09.2006 17:19:30 |
|
|
[Report] Group by a field not sorting by it
Hi all
In an access report, is it possible to group by a field but not sort by
it?
Example:
Table Sales
Prod Invoice Movement Quantity
P1 4019 005 1
P1 4019 006 1
P2 4019 003 5
P2 4019 004 2
P1 4020 001 5
P1 4020 002 ...
|
4 |
18.09.2006 15:46:57 |
|
|
Placing textbox linked to parameter on a chart
I've made a chart in a report based on a parameter query. What I want to do
is simply make the title of the chart the name the user typed in for the
parameter, followed by the word: "chart".
One of the problems I've encountered in trying to do this is that the report
doesn't actually have a record source, only the chart in the report does. If
I give the report a record source, which i...
|
3 |
18.09.2006 15:03:01 |
|
|
multiple one-many reporting...
I have a report that includes two different 1-M child tables - hence varying
amounts of data per detail line...
The SQL that this report is based on, is a dynamically created statement
based on a criteria screen. Because of this, if there happen to be one or
more entries in one or both of the 1-M tables I am selecting values from,
you get multiple rows back in your query - for the same ...
|
3 |
18.09.2006 14:27:42 |
|
|
Rename report fields and linked data fields via VB
I have a report that is linked to a query which has around 52 fields that
change when the fiscal years changes. For example the fields may be
txtFY06sales, txtFY06inventory, etc.... Also the linked data fields in the
query are similarly named. Changing the query is no problem, but changing 52
fields in a report(actually it may be more then 52) is very labor intensive.
Is there an e...
|
4 |
18.09.2006 14:19:37 |
|
|
force a page break
When a field on my report changes is there a way to make it force a new page?...
|
2 |
18.09.2006 13:41:09 |
|
|
Access reports
Do I have to strat with a blank report (Not Wizard) to enable me to bind
controls from different sources?
Kingy...
|
3 |
18.09.2006 05:25:46 |
|
|
Printing report wrong
I have formatted a report to print envelopes. The first time I open the
report, it says it is out of margin. When I view this one, it puts two labels
on a letter size paper. If I close this, and reopen, it shows fine. As long
as I am still in the database, it will keep showing the envelopes. As soon as
I close and reopen, the first report goes back to letter size. Is there a way
to resol...
|
2 |
18.09.2006 05:19:14 |
|
|
How do I make an address book from an access report
I want to make a sorted Access report into a folded booklet. Word make an
extra record for each item in a related table. can I make a booklet in access
2003...
|
2 |
18.09.2006 05:17:10 |
|
|
Report using Parameter query
Hi
I have a report which runs through the query and has the following
parameters .
1. Enter Ethnic Group
2. Enter Starting Date
3. Enter Ending Date
I have only one date field in the original field which I put a criteria
as: BETWEEN ( Ending Starting Date ) AND ( Enter Ending Date ).
As of now, the report works fine. When opened it asks for the above
parameters.
This is what ...
|
2 |
18.09.2006 03:21:14 |
|
|
in Access, how do I restore a field to a report?
I have successfully been using a report I designed some time ago, by trial
and error. In doing this (the revision) I inadvertently deleted a field from
the design view. Simply typing the field name back into the design does not
restore the field to the design. How do I do this?
I'm embarassed at how this stupidity demonstrates my amateurish approach to
this, but I'm stuck....
|
2 |
18.09.2006 03:15:50 |
|
|
Text box that has either No arrow or Up Arrow or Down Arrow in it.
I would like to have an arrow entered into a text box, based on my Result
Field. If the number is above a certain number or below a certain number.
Can I do this in conditional formatting?
If I can how would I phrase this?
Is there another way?
Diane...
|
12 |
18.09.2006 01:49:59 |
|
|
report 2 pdf
Our MS Access reports works perfect with the Stephen Leban's Report2PDF
module. But only on a Windows XP machine. On a Windows 2003 servers it
wil not display all the fonts & symbols correctly. Thanks
Carlo
...
|
2 |
17.09.2006 23:04:20 |
|
|
Lebans RTF2 control...
Hi,
I used Lebans RTF2 control in my report. However, my report contain two RTF2
control instead of one. The code below is alomost perfect except that if the
height of second RTF2 control is heigher than control 1, It just cut of the
rest of the text. I am having a hard time, as a newbie, to modify the code
to address the case state above. Could someone advice?
Private Sub Detail_F...
|
2 |
17.09.2006 23:02:40 |
|
|
Report with 2 columns
I have a report that is a work ticket. This work ticket prints one record per
ticket per page. What I want is for the report to print two work tickets per
page. Although I belive that the setup is correct, the report refuses to do
what I wish. The report dimensions are 3.3021" wide and 5.5" long. In page
set-up the page is set for 2 columns, Row Spacing is 0" and Column Spacing is
0.1"....
|
2 |
17.09.2006 20:05:02 |
|
|
Margin settings for Reports
My margin settings won't stay in my reports. I have to keep setting and
resetting them in design view. I save the report each time but when I open
it again they just keep defaulting back to 1 inch around.
HELP!!
...
|
4 |
17.09.2006 19:20:28 |
|
|
Page total & continued total on each page
I have a report which has some time one page print some time 2 pages and
sometime 3 and some more than that about 10 pages.
At the report footer the Amount field sum is there, I mean it sum the
complete amount of the report at the end of the report.
But my requirement is something like below :
If the report is of one page then no need any thing as the report footer
SumField will be...
|
2 |
17.09.2006 18:57:30 |
|
|
Password protected report problem
Hello,
I have just password protected a form and report according to Microsoft
Article 209871. It works fine on the form but I keep getting Error# 13, type
mismatch when I try to open the report. I checked the references and
Microsoft DAO 3.6 Object Library is checked, and the declaration of the
recordset is: Dim rs As DAO.Recordset. Now I'm totally befuddled....
Any help/suggesti...
|
5 |
17.09.2006 16:32:01 |
|
|
levy-jennings chart ??? Posting again under reports. No respones
How can I do a levy-jennings chart in access? I have a Mean and Standard
Dev. with many control data points to chart over 30 days (time frame). I
would like it to appear in a report. I would also like to be able to change
the Mean & SD automatily, when I chose another Control. Is this possible???
Diane
...
|
1 |
17.09.2006 16:08:01 |
|
|
Report sort by
Hi
I created a report by vendors with all the items they sold.
I must print this report, by vendor, means that even there 1 or 2 pages of
items when the vendor change it must end of page and open a new page with
the second vendor.
Impossible with the group by vendor. It give me One title , and repeat the
header detail, and then the items of the second vendor. what should I do.
Please thank...
|
3 |
17.09.2006 11:31:08 |
|
|
docmd.runsql
Hi,
I previously had a query that was too complex to be evaluated (apparently).
A nice person on this site told me to construct a 'make table' query.
The results are for a report, so I have made the report have the onopen
event as below:
Private Sub Report_Open(CANCEL As Integer)
Dim self1 As String
If <statement> Then
self1 = "SELECT <variables> IN...
|
4 |
17.09.2006 11:02:01 |
|
|
Label Wizard Access 2000
The label wizard is not installed and I need to make some Avery #5163
address labels. Is there a way to re-install the wizard?
...
|
2 |
17.09.2006 04:59:23 |
|
|
How can I publish my report to the web the way I want?
I didn't know that Access could use HTML templates. I am using 97 at
the moment. All I found was the raw data going to an html file and
displayed.
What if I want to wrap the fields in HTML tags? There didn't appear to
be any tokens for that.
What if I have, for example, a URL of an image in the database. I want
to put that URL in an <img src=myField /> tag.
Is this possible ...
|
2 |
17.09.2006 01:27:25 |
|
|
Conversion of 4 tables in one
Hello
I would like to modify the design of my database and convert 4 different
tables whose only difference is the main code, the rest of the fields are
the same, in one table.I mean;
Code_man
product
color
design
Code_woman
product
color
design
And convert in
Code
sex: woman/man
product
color
design
Is there any special method instead of doing it manually?
thanks
...
|
3 |
16.09.2006 18:16:09 |