|
Fixed :) reports don't open in access 2003 after converting from Access 97
FIXED!
RE reports don't open in access 2003 after converting from Access 97
Just to let you all know, changing the default printer to a different
printer allowed Reports to open (and be edited and created) again :)
It must have been something to do with margins out of printable area or
something... I still cannot use the [network-conencted] Kyocera Mita KM
2050 with its current settings, b...
|
2 |
27.09.2006 02:28:42 |
|
|
fLoadPicture only for runtime version and problems printing
System info: SQLServer backend, Access XP adp front end delivered to each PC
on boot.
I am using Leban's fLoadPicture code to counteract memory leak. The report
is a student directory that loads each student's jpg picture or a "No Image
Available" jpg, 6 students to a page. When a 143 page report was printed,
starting around page 117, random pictures did not load correctly. There are
bl...
|
4 |
27.09.2006 02:28:22 |
|
|
SubReports
I have a report with 2 subrpt this is my formula on my 2ndsubrpt
=Reports!rptLotterysalesByStore!Text51-Reports!rptLotterysalesByStore![LotteryInventoryPaid
Grand Total Sum]+Reports!rptLotterysalesByStore![TerminalFee Grand Total
Sum]+Reports!rptLotterysalesByStore!qryScratchOffTicketsActivatedByStore.Report![Grand Sum Of Cost]
My problem is if the [Grand Sum Of Cost] is null my 2 subrpt =...
|
2 |
27.09.2006 01:20:24 |
|
|
do not repeat section headers with each record
in accesss reports: for some reason my section header ( the header is a range
such as $200,000-$300,000, $300,000-$400,000,etc)repeates with each record
from the detail section. I just want it once, till the range changes....
|
2 |
26.09.2006 23:43:01 |
|
|
suppress last blank page
I have a report to print instructors' roster with student name listing. I
groupped by instructor with force new page before so each instructor is on
his/her own page.
Report preview is fine, with each instructor on his/her own page without
blank page.
However, if I print, it always print 1 additional blank page at the end.
That means:
If I select print page 1-1, it print 2 pages w...
|
5 |
26.09.2006 22:21:19 |
|
|
Form Feed after report print.
I have a report bound to a query using Access 2003. The report is exactly
3.5 inches by 7.5 inches and is intended to be used on a continuous supply of
checks printed on a OkiData 321.
The report prints 2 checks then form feeds as if it was an 8.5 x 11" sheet
of paper. This messes up a whole batch of checks.
A few weeks ago I had this all set up and it seemed to print properly.
...
|
2 |
26.09.2006 21:59:03 |
|
|
How do I get list box data to display properly in a report?
I'm using Access 2003.
My database has several fields set up as list boxes with a value list and
specified items. I've done a query including these fields and set up a
report on the query. When I print the report, the fields in question come up
as white on black. If some of the fields are empty, the first value from my
list prints out. In some cases, a field that has been entered does...
|
2 |
26.09.2006 20:57:55 |
|
|
Subreport is causing page break
hello
after a little looking into what i am experiencing i would have to say its
wierd that i am the only one having this problem.
i have a main report which has a report header, page header,
"mysectionheader", detail, page footer and a report footer.
in the detail section of the main report, i have a subreport which has a
"mysectionheader" and detail.
no where in either report i...
|
3 |
26.09.2006 19:57:02 |
|
|
IIf statement - checking for text
Hi,
I'm trying to use an IIf statement to essentially say:
If the following field contains text, then make this field 1, otherwise
make this field 0
The expression I'm using is:
IIf([field containing text]="",0,1)
Any thoughts on why this does not always work?
Thanks!
...
|
2 |
26.09.2006 19:30:40 |
|
|
$123,456 displayed as $ 123,456?
Is it possible to have the value right justified but the dollar sign left
justified in a report field?
-Adam...
|
3 |
26.09.2006 18:41:37 |
|
|
Ticket values on a printed sheet.
I developed an application using VB.NET 2003 and Access XP. The program is a
Ticket Generation System and my client wants that only the values must be
printed on the ticket and the rest of the text will be pre-printed on it. I
want to know how to synchronize the dimension of my report variables so that
they fall in front of their exact printed headings on the pre-printed ticket
sheet....
|
1 |
26.09.2006 18:32:02 |
|
|
Open form, show first record
I have a very basic problem that I cannot seem to fix.
I want to open a form and display (only a few fields) the first record in
the table. Then, after clicking the NEXT button, I want to dispaly (on
another form) only a few more fields in the same record (the first record in
the table).
I've tried setting the Data Entry property to No and still, the form opens
with a blank record. ...
|
4 |
26.09.2006 18:04:21 |
|
|
Report Printing all blank pages
Ok. I've designed 100s of Access reports and have never had this
problem. I created a landscape report that where the layout is exactly
9". When I preview the report, there is always data, but more often
than not it will just print all blank pages. Sometimes it will print
just fine. It's always going to the same printer. When one of my
users prints it, he always gets blank pages. When ...
|
1 |
26.09.2006 17:57:26 |
|
|
Getting an error when using expressions for reports
I am trying to pull data from different fileds in a table, called Master
Table. I want to create a report that would output this information in a
pragraph form like below...
The epsression I used is this:
= [MasterTable]![Type of Observation] & ". " & [MasterTable]![Observation] &
". " & [MasterTable]![Name]
This is what I want it to look like:
Bad Finding. Person did not do ...
|
3 |
26.09.2006 17:31:37 |
|
|
Report Filter????
I know the problem is with my Where clause but I am not sure how to fix
it. Here is the error.
Syntax error in date in query expression '([RCName]= 'Athletics' AND
[DeptName] Like '*' AND [Date Entered] Between ## and #9/22/06 >0)'.
Here is the current code:
Private Sub Apply_Filter1_Click()
Dim strRCName As String
Dim strDeptName As String
Dim strDate ...
|
9 |
26.09.2006 16:39:46 |
|
|
Grouping Question
My setup: One form ("Soccer or Baseball") and one report. I have two fields
"Designated Area" and "Product Type" that I am working with. "Designated
Area" is the group, and "Product Type" is the restrictor.
There are two options in product type: "Soccer" and "baseball"
Ideally, I only want to display results for either soccer or baseball when
the corresponding "Product Type" is sel...
|
2 |
26.09.2006 14:31:27 |
|
|
Dividing one Control by another Control to find the Average.
Please help,
I am trying to divide one Control, call it Text 1 by another Control
Text 2 to find the average of several entries in a Access Report. I am
placing the Controls in the the Style Footer where I am adding the Values of
Control One and Counting the Number of entries in Control 2.
Control 1 - =Sum(Val(nz([Header Stitch #1])))+Sum(Val(nz([Header Stitch
#2])))+Sum(Val(nz(...
|
10 |
26.09.2006 13:43:02 |
|
|
Print an individual record via a Report
Hi there, I'm quite new to Access, so please be gentle!
I've created a Report to set the format in which I want my records
printed, however at the moment, when I click the Print Record button
that I created with a Wizard, if prints every single record in the
table I referred it to.
What I have is a 'View Work Requests' form called "View Request2" which
prompts me for a Work request numbe...
|
3 |
26.09.2006 11:21:08 |
|
|
how to sort in access without defaulting to the primary key
how do i keep from defaulting to the primary key within a nested sort.
Thank you very much.
Lance...
|
3 |
26.09.2006 02:12:01 |
|
|
Resizing fields in design view
Hello: I am printing a tabular report on a list of names. The tabular report
has five fields. The five columns are too wide to print on one page. In
design view I did click and drag to reduce the width of the columns, It's too
tedious and takes too much time and still takes up two pages. What am I
missing here? Thank You much.
Bob Levin...
|
3 |
26.09.2006 01:04:42 |
|
|
Sizing Design View Window
Hi, I have a report I created in design view. If I have the "design view
window" smaller than the Access database window/work space, I am unable to
resize the window. I do this when I have 2 reports open in design view at
the same time and I comparing property settings from one report to the next.
I resize the windows of each report to a size where I can see the most info
at one time...
|
3 |
25.09.2006 21:06:02 |
|
|
Duplicated records in a report
I am running a report that is generated from a table field called "SrvID".
There are several individual reports that can be generated by the same query
with SrvID as the driving condition. Several of the reports run perfectly
but two or three of them, using the same query, print out all of the records
duplicated six times on a page. Does anyone have any ideas as to why some
reports wo...
|
2 |
25.09.2006 20:34:30 |
|
|
Year Subtotals
Something is just skipping my mind. All I want to do is set up a report that
details out data by year, then give totals by year. Not one line grand
total. See below data and report structure. I know this is probably simple,
but I just can't seem to grasp it. Thanks in advance for the help
Data:
2000 A 100
2000 B 100
2001 A 100
2001 B 100
Report:
A
2000 100
20...
|
2 |
25.09.2006 18:40:02 |
|
|
"0" in a sum calculation not showing up?
I have the following code, but "0" is not showing up (it's blank). Any ideas
why? (By the way, "Allocated Case Volume" is a number.")
=Sum(IIf([Product Type]=Forms![Allied or Monster]!ProductTypeV And
[Transition Complete YN]=True,[Allocated Case Volume],Null))
-Adam
...
|
2 |
25.09.2006 16:43:03 |
|
|
#Name? in one of the reports
Hi folks
I have stumbled upon an issue and hopefully somebody has an idea.
I have reports in my application and they seem to be fine on some
computers running
XP SP2 / Access 2003. On one of the computers, with the same
configuration i.e.
XPSP2/ Access 2003, 2 fields Full Name and Address always appear as
#Name?
The underlying query is fine and returns all the fields. The report
con...
|
4 |
25.09.2006 16:34:41 |