|
Adjust the height of a line automatically
Hi,
I have a report in Access, and I would like to delimit each colums by a
vertical line. The problem is that in my detail section I have an memo field
which is set to automatically increase its length as the memo content grows.
Then, the height of each record vary from record to record. When I draw a
vertical line in the detail section, its height is fixed and does not enlarge
with ...
|
5 |
14.09.2006 23:03:40 |
|
|
layout on A4 landscape
Hi,
I am confused about page lenght and width...
I want to print a report on an A4 paper, landscape.
The correct width of an A4 paper is 29,7 cm.
When I set the left side of the paper to 29,7cm I get a message saying
the section is wider then the page itself.
When I reduce it to 24cm it's OK.
The width of the title is also 24cm and nicely centered but, the text on
the bottom of the page,...
|
1 |
14.09.2006 21:42:44 |
|
|
Columnar sub-report in a non-columnar Detail section
How can one insert a columnar sub-report (established by using Page Setup) in
the Detail section of a report where other Detail fields need to be non-
columnar? No headings are required.
--
RodH
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200609/1
...
|
15 |
14.09.2006 20:44:17 |
|
|
print using acrobat distiller
I was creating PDF files of Access reports. I use Access 2003 and Acrobat
distiller 5 and 6. Of late the Distiller is reporting an error without
creating the PDF file. ...
|
7 |
14.09.2006 19:43:02 |
|
|
DoCmd.OpenReport not opening subreports
Hi all
I have a report that runs on a query (duh) :) that allows the user to
select a few parameters.
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 running the query and then including
an event trigger to run the report once the query has been run (or
something like th...
|
1 |
14.09.2006 18:35:34 |
|
|
selected items on report are fully blacked out
I'm on a network with some stations on Access 2002 - SP 3 and others on
Access 2003. When printing reports out of Access 2002, items that have
reverse lettering (white on black) appear all black on the print preview and
the actual paper printing. However when I open the same database with Access
2003 and print the same report, the reverse lettering lines appear properly
and print correct...
|
1 |
14.09.2006 16:49:02 |
|
|
Intentionally put blank rows down the pag
I have built a report and it works great for what it does. But a question
was posed to me about adding blank lines on the page. For example:
If the page for instance can hold 25 rows but the query only results in 5
rows of information, when I print the report it currently only shows the 5
rows that contain data can I have it still fill the empty rows with the same
outlines as the fill...
|
2 |
14.09.2006 16:39:05 |
|
|
Default Zoom Level for Reports
Hello,
I converted an Access 97 database to Access 2002 and now when I open
reports, the default zoom level is Fit. Is there a way to make it default to
zoom level 100%?
Thanks in advance
Steve
...
|
3 |
14.09.2006 16:35:23 |
|
|
changing the layout of a report
I have a report now that I made with the wizard that looks something like this:
Month [Month]
Channel [Channel]
Sales: [Count]
Technical: [Count]
etc.
the records are grouped by date (on month), then by channel. The sales and
technical of the two types of records that could belong to a channel in ...
|
2 |
14.09.2006 15:12:40 |
|
|
Parameter Passing
Dear All,
I have to pass a variable to a report that is not entered by the user,
it's a two part variable, basically a between a and b where a is a
subquery and b is a user entered date. I can get the relevant text box
on my form to pick up the user entered variable, but the moment I try
to get it to pick up the subquery variable I get the name? error. The
text box should ideally end up lo...
|
5 |
14.09.2006 14:21:07 |
|
|
Unrecognised table field in report
Hi all,
I am trying to create a simple report. My current problem is that if I try
altering an existing report by simply adding a field name to the list of
fields in the 'SELECT...' statement, when I preview the report it requests
the value of the added field. I have checked the spelling etc etc. I have
also tried adding it from a query, where the query was built by double
clicking fi...
|
3 |
14.09.2006 14:17:02 |
|
|
Part of report 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 |
14.09.2006 14:13:02 |
|
|
Hyperlink
Is there a way that you can make a hyperlink active in a report? I've read
other posts that recommend to use a form instead, but a form will not work
for me because I need to be able to view multiple records all at once and not
have to scroll through records, like a form. Any suggestions?...
|
2 |
14.09.2006 13:35:10 |
|
|
Rotate label
Hi
Using Access 2002 is it possible to have a report label angled at 45
degrees?
If so any advice on how can it be achieved would be appreciated.
many thanks
Josie
...
|
1 |
14.09.2006 13:11:35 |
|
|
records from query not populating report
I have a report that pulls records from a query. (This query pulls records
from another query.) When I run the query on its own, the records that I
need to see come up okay. Further, if I attach the query to the report to
run without any VBA code in the report, the records from the query populate
the report. However, when I add the following code to the 'on open' event in
the report to op...
|
1 |
14.09.2006 12:56:32 |
|
|
Blank page when using NewRowOrCol property
In an Access 97 multi column report, I am using the NewRowOrCol AfterSection
propety in a group footer to nicely group the data in three columns per
page.
If the report consists of only three (or six, or nine) columns, however, the
footer will force a new column, and therefore a blank page will be added.
At this moment there is no report footer.
Is there a way to suppress the new co...
|
3 |
14.09.2006 12:31:02 |
|
|
Filling rotation fields on a report
I have a query which selects 16 students from a registration list for a
two-day class I run. Part of the course involves hands-on skills rotations
(for example, four groups of four students, rotating thru four sixty-minute
stations over a four-hour span). Is there some way I can construct a grid
on a report which displays the rotations (time intervals on one axis, skills
station names on th...
|
4 |
14.09.2006 12:29:00 |
|
|
This expression is typed incorrectly, or is too complex
Hi,
I am trying to create a report but get the error "This expression is typed
incorrectly, or is too complex..."
I have tried numerous approaches - adapting existing reports, starting
afresh, putting the expression in a query and referencing the query...
I finally got a query to work and return the data that I wanted it to
return. It works even now, but if I create a report and jus...
|
3 |
14.09.2006 10:20:01 |
|
|
How do I use recordsets in a report?
I'm trying to use recordsets in my report but I get an error
message--Run-time error '2448' on the following code at the Line Me!CityCode
= rst!CityCode
Dim rst As Recordset
Dim dbs As Database
Dim strSQL As String
Dim strRate As String
Dim strRoute As String
Dim strDriver As String
Dim strlocation As String
Dim intCounter As Integer
Set dbs = CurrentDb
strSQL = "SELE...
|
5 |
14.09.2006 10:12:37 |
|
|
Default printer Option
Hello, I upgraded an application I have in Access 97 to Access 2003 early in
the year. One issue I have is that users report sometimes getting prompted
when printing a report that the printer selected for the report doesn't
exist. I can fix this by going into the page setup properties and changing
the option from specific printer to default printer.
The issue is that the next time I updat...
|
3 |
14.09.2006 10:00:43 |
|
|
Chart by Date
I wish to create a chart, histogram, that shows the number of occurances in
each month of three unrelated events for which I have the dates. I've tried:
Group by - Date By Month: Format$(Date1,'mmmm yyyy')
Count - DateA: Date1
Count - DateB: Date2
Count - DateC: Date3
The SQL comes out as:
SELECT DISTINCTROW Format$(Client.DateOfReferral,'mmmm yyyy') AS [Date By
Month], Count(Date1) ...
|
1 |
14.09.2006 08:53:01 |
|
|
Reports won't open
hi,
I have several clients, where reports will not be displayed. They have
Windows XP and Access 2003 installed (mixed service packs).
The
DoCmd.OpenReport "ReportName"
throws no error, but won't display the report. Also the report events
are not called. I used break points as well as a message box to confirm
this.
The .mdb is not corrupted (its a fresh one, all objects cop...
|
3 |
14.09.2006 08:18:19 |
|
|
Form & Report
I have a form called Maintenance, when this form is filled in I can print the
Service Order for it. The Service Order is a report. I would like to be
able to fill in Maintenance ...say... 100 and in the Service Order report
print the same...100...
Now I have to go to print select pages to print...type in from...1...to...1
and am able to print the service order for Maintenance 100. Can ...
|
13 |
14.09.2006 01:12:01 |
|
|
Device Context
I would like to draw gradients directly onto my sub-report. The best method
(most flexible and cool) I have found to do that is API-based, so I need the
report's DC. How can I get that?...
|
4 |
14.09.2006 00:20:25 |
|
|
Combo box as control source
I am using a combo box on a form as the control source for a text box on my
report. This works when I put the name of the combo in the report's control
source, but I am trying to do it programmatically in the report open event
because I have several of these to manage.
This is what I have been trying thus far:
Me.txtItem01.ControlSource = Forms!frmItemTester5!cboItem01.Column(1)
Can s...
|
7 |
13.09.2006 22:01:02 |