|
Reports no longer work
I have a number of reports in my app. I've been using this app for some time
now. I modified the app to include a calender icon and Access abended. Ever
since then, I cannot get the Reports to run or to even edit the report in the
design view.
I have already disabled the calendar option in the references dialog.
Any help would be apprciated.
Thanks,
_____Casey G....
|
3 |
16.09.2006 02:29:05 |
|
|
Verticle lines between columns
I have a report where I am separating the columns of data with a line. I am
using a small vertical line the height of the detail and usually works well.
Once in a while, I have a field ("can grow" property set to "yes") with
enough data to grow. That makes the vertical line look "broken" all across
the row. Is there a way to make all the vertical lines extend their length
to match the ne...
|
12 |
16.09.2006 06:59:05 |
|
|
Report from different tables which are not related
Hello,
I´m designing a DB for a dress shop in which there are 4 different sections:
-babies
-children
-men
-women
For each section there is a table, eg:
Women:
Code_women
product_women
price
Men:
Code_men
product_men
price
These tables are not related between them.
My aim is to create a report with the sales of all the sections:
Babies
T-shirts
red 40
b...
|
2 |
16.09.2006 02:27:21 |
|
|
Subreport Headers
I have a subreport which contains headers. How do I have the subreport
headers show up when placed in the main report?
...
|
7 |
16.09.2006 02:23:21 |
|
|
Report Footer on Page 1 of a three page report
Is there a way to have a report footer print only on the first page of a
report ? This is necessary because there is information and signatures that
have to be on the first page. The additional backup pages only have page
headers and no footers of any kind.
The first page has a Report Header then a memo section that starts on page 1
and could continue to more pages. Then the report fo...
|
1 |
15.09.2006 21:51:01 |
|
|
Report being cut off
I have a table that I copied from another table due to it having similar
information. There were fields that I changed the name and/or data type
within the TABLE section. I then created a form to input the info.
However, when I went to create the report via the wizard, I got all the way
through the wizard and it tells me the report could not be created.
Therefore, I proceeded to cre...
|
1 |
15.09.2006 20:20:02 |
|
|
report labels rotated
Access 2002 report: Would like the labels for the data in the report to be
rotated 90 deg. Tried help be no banana. Anyone got any ideas? TIA
--
____________________________________
In Christ's matchless name
ted & colleen
n6trf kc6rue
...
|
2 |
15.09.2006 20:18:27 |
|
|
How do you adjust the space between lines on a report?
I have a report that pulls several results from a query. Though, I need to
reduce the amount of space in between the results for the "detail" section.
Any ideas?
-Adam...
|
3 |
15.09.2006 18:52:01 |
|
|
Pass recordset from form to report?
Is there any way to pass a recordset from a form to a report and have the
report print based on that recordset?
Thanks....
|
1 |
15.09.2006 18:39:01 |
|
|
Show "347" as "00347" in a report?
I have a report that is populating a field from a table that saves data as
text.
In the report, 347 is showing as 347 but we want it to display as 00347.
Any ideas?
Thanks for the help!
-Adam ...
|
5 |
15.09.2006 18:15:40 |
|
|
How do I make an address book from an access report
...
|
1 |
15.09.2006 17:54:01 |
|
|
Sum of field in report
Hi, I have a report with 7 different fields based off a single query.
In the report I have a field "Amount" that I would like to have a total
for at the bottom of the report. Right now I was reading through the
forums and someone suggested creating a text box within a group footer
for the field that you want to total. I did that and it almost works
except that I am getting two totals. One sho...
|
2 |
15.09.2006 16:43:35 |
|
|
Calculation not working
Hi. Access 2K. I have a financial report. In the footer I have three text
boxes where I have totaled Revenues, Expenses, and Indirects that are grouped,
for the total budget field, in the detail section. I need to calculate the
overall total budget in the report footer. The three text box names are Rev,
Exp, and EID. The formula in the fourth text box =sum(Rev - Exp - EID) does
not work...
|
3 |
15.09.2006 15:58:26 |
|
|
Nested IIf
Hi,
I think this is easy but not for me. If Field1 contains certain text i.e.
Ugly data or Bad data it should be left out of final result.
Example: Field1 Field2
Field3
Record1) Ugly data Keep always
Keep always also
Record2) Good data Keep always
Keep always also
Record3) Bad d...
|
2 |
15.09.2006 15:44:29 |
|
|
Snapshot viewer question
Is it possible to make the an Access report in snapshot viewer to default to
fill the screen?
My report in Access has small font and it is harder for users to view at 100%
...
|
1 |
15.09.2006 14:21:02 |
|
|
tristate check box
I have a tristate check box.The default behavour of tristate check box
in windows is that, the grayed check box will become unchecked after
click on grayed check box.
But i want , the grayed check box will become checked after click on
grayed check box in VC++ .Pls help me its urgent.
...
|
1 |
15.09.2006 14:14:37 |
|
|
How do I Turn a Spreadsheet Type format INTO....PLEASE HELP!
a standard type spreadsheet Access report? I have the following fields in my
table and they look like this.
Start Date Effective Date Interest Rate
05/01/2001 05/01/2001 5.65
05/01/2001 05/01/2004 4.00
05/01/2001 06/01/2004 4.10
05/01/2001 05/01/2005 3.00
05/01/2001 05/01/2006 3.41
05/01/2001 06/01/2006 3.30
I need the report to look like this. Notice that the Interest rate above is ...
|
9 |
15.09.2006 14:14:02 |
|
|
convert text characters to a symbol
I have a text box in a report in access that displays a size 10 1/2 (Ten and
a half). I want to display the half as the "half symbol" to save space on a
very tight label. Does any one know how to do this please. I am using MS
Access 2002 Professional on a WinXp Operating System.
This is the text box
=Trim([NLabSize])...
|
5 |
15.09.2006 14:05:29 |
|
|
change the text color in the report
Hi,
I have a report base on a query that will calculate the sum of the
percentage.
I need to change the color of the text according to my result.
If it's less then 100, I want to display it in red and if it's 100,
then display it in black.
How can I do that? Is it possible?
Cheers!
Claudi
...
|
4 |
15.09.2006 13:25:50 |
|
|
White space in multi-columnar subreport with duplicates hidden
Because a multi-columnar subreport requires snaking across then down, is
there a way of eliminating white spaces caused by hidden duplicates? E.g.
horizontal shrinking.
--
RodH
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200609/1
...
|
2 |
15.09.2006 13:22:26 |
|
|
Can I export an access report into a word document?
Simple question and I get the feeling the answer is no. But if anyone has
any ideas it would be a great help. I need to be able to export an access
report to word to merge with other data and then place into a powerpoint and
word report. Thanks in advance for the help....
|
2 |
15.09.2006 12:34:35 |
|
|
Links in a report
Within a report in Access 2003, is it possible to add a link to other reports
via a command button?
Many Thanks,
Matt...
|
1 |
15.09.2006 10:24:02 |
|
|
elminating duplicate lines
I am making a report listing contact ID,contact address, and contact mailing
code. Each contact has a mailing code. However they can have more then one.
When I run the report and filter the mailing code I have some contacts that
appear 2 times because they have both mailing codes. I found a way to not
show the contact id number if it is duplicated, but I also want to delete the
conta...
|
1 |
15.09.2006 09:21:01 |
|
|
Printing "creep"
I have an Access report which prints mailing labels on Avery 5160 (3 across
by 10 down) stock. The format is fine when I print it to my HP Laserjet 6L.
I made a PDF of the report and sent it to a colleague so she could print the
labels herself. She had a problem with each page creeping up by a small
increment. The PDF, however, seems correctly aligned for each page. Any ideas
on what's ...
|
3 |
14.09.2006 23:37:56 |
|
|
dlookup problem
Hi there
think my statements are too complex.
I created a Tblboatmen with 3 fields ID Length and Tarriff
however first record starts with 50mtr and the last record ends 400mtr
The problem is the records don't jump upwards with the same amount
meters
a third party created this tarriff which i have to use.
ID Length Tarriff
1 50 mtr $100
2 75 mtr $120
3 80 mtr ...
|
5 |
14.09.2006 23:14:01 |