|
Multipal parameters input
I want to create a report that will be run with a parameter query in the back
ground where my users (students) can click a button and input several course
numbers that will then run a report for each course as a check-off sheet.
I have everything build, except the multipal input ability. A parameter
query will allow a maximum of two inputs for the course field. Any
suggestions, am I do...
|
1 |
12/31/2008 4:48:05 PM |
|
|
Printing group totals in the page or report header
I have a report grouped by department, with each department totaled in the
group footer, and the company total (grand total) in the report footer. All
of this is working just as desired.
However, I am trying to replicate a previous excel report (in formatting),
which has the department totals and company total repeated at the top of the
page. I could work with it in the report or page...
|
2 |
12/31/2008 4:43:01 PM |
|
|
Duane Hookom's Calendar Style Schedule
I have adapted the above report to suite my needs, however cant figure one
thing out. Since my calendar spans several months, i would like to try and
divide the months somehow. I have tried adding it to the query for a
'MonthOf' field, but cant get that to work, it looks right in the query, but
when i add a heading for 'MonthOf' and add it, they all go to January. Has
any one done this tha...
|
12 |
12/31/2008 4:21:00 PM |
|
|
Report causes 3048 error "Can't open more databases" after DB spli
I have report consisting of 20 subreports:
1) 13 single subreports of wich
2) 7 have charts (pies) and supporting information as sub-subreports.
All the sub- and sub-subreports as well as the charts are based on queries,
3 have DLast and DFirst domain aggregate functions, 2 have subqueries, 1 is
based on Union query. No other VB.
The charts were initially built in forms then copy-pasted to...
|
1 |
12/31/2008 4:17:01 PM |
|
|
Printing Lables
-- I have a data base that creates reports from the information input by the
user. These reports are in the form of a book. I have a form that allows the
user to input information for a header. I need to create a button that prints
the header information as a label for the book. I am using Avery 5164 labels
(two columns, three labels per column) and found the label wizard in 'new
repor...
|
5 |
12/31/2008 3:42:47 PM |
|
|
Output Multiple Values as One Field
Hello.
I have field for categories and lookup table linking mulitple categories to
a third table of items. I know I can create a sub-report for that category
but this creates a table style output.
On my report I would like the categories to appear as "category1; category2;
category3..." until all categories of the an item have been listed. Any idea?
Lori...
|
1 |
12/31/2008 2:34:01 PM |
|
|
report displaying field in different language
I am trying to do maintenance on a report that was created by someone else.
There is a field that displays and prints in a foreign language. I have
written queries and it displays in English, it also displays in English on a
Form. I am linked to a SQL server to retrieve the data. Any help would be
appreciated....
|
2 |
12/31/2008 2:22:45 PM |
|
|
Is there a bracket (financial) format?
On a report can a negative number be bracketed, rather than show the -ve sign?
e.g.
-123.45
(123.45)
Seems simple but, I just can't find the format. All help much appreciated....
|
2 |
12/31/2008 12:12:34 PM |
|
|
Report Printing Automatically Issue
I have a Form that when a button is pressed, it performs the DoCmd.OpenReport
command. Whenever the report is opened, it automatically prints. I am racking
my brain trying to find what setting I changed to have this happen and am
having a complete brain fart on this. I have even created a brand new report
and the issue is still there. I know the fix is simple, but I can't remember
where ...
|
3 |
12/31/2008 6:55:57 AM |
|
|
Remove Hidden Duplicates from sum
I have a report that tracks rev/expense. In both rev/expense I have misc
sales and misc expense. Both of these have detail. For example I may have
on a single line(date) a misc expense of $100 that breaks down into detail of
Misc Expense 1 $50, Misc Exoense 2 $30 Misc Expense 3 $20.
If I just run a single line per date with sums at the bottom (like below)
everything works.
Date ...
|
2 |
12/31/2008 6:30:00 AM |
|
|
Different size page footer on first page
I have a report that needs more fields in the footer on the first page than
on all consecutive pages. The total height of the footer on the first page
will be 1.5 inches, and the footer on all other pages will only be .5 inches.
The report has a header and enough room for one detail and a special page
footer on the first page, then a page header and four details and a page
footer on al...
|
2 |
12/31/2008 6:21:01 AM |
|
|
send reports from access to mail recipients
I look after the membership records for a club and each year produce invoices
for annual fees from various tables within our MS Access database.
I would like to email these to those members with email addresses recorded
in the members data base.
I know I could do this individually by selecting the Send to option for each
invoice but this would be very labourious , slow and labor intensive....
|
1 |
12/31/2008 5:40:04 AM |
|
|
Showing dates like in a Excel worksheet
Hi all! Access 2003.
How can I show dates, or better, days in sequence (
1,2,3,...,30,31,1,2,...,30,1,2,... grouping par 3 months) so to get a report
like a tipical excel worksheet with days in cells Bn,Cn,Dn,... and data on
rows A1,A2,A3 etc. Any table in my DB contains all these days but only short
periods using the fields (date/time) From and To. Periods will be show like
an X when t...
|
2 |
12/31/2008 4:23:00 AM |
|
|
How can I get a big "A" at the beginning of the A people, "B", etc
I have a report in an Access database that we're using for Names, addresses,
phone numbers, and pictures. I have a good report to get the pictures to
work, thanks to all the help I received. Now I have a need for the simple
"Name Address Phone" report (no pictures) to show a big ---A--- at the
beginning of all the folks whose last names begin with A, and then ----B----
when the B p...
|
4 |
12/31/2008 3:05:00 AM |
|
|
Grouping by a multi-value field
I have a contact database with a multi-value field for signers of
correspondence (multiple people can sign a single letter). I would like to
group contact lists by the multi-value field without getting a line for each
signer. For example, if the value of the multi-value field was "Smith,
Jones" I'd like the contact to be shown on only one line of the list with
"Smith, Jones" as the grou...
|
5 |
12/31/2008 12:10:31 AM |
|
|
Access 2.0 Format Question
Let me begin by apologizing for asking a question in this old an
application. However, our company has a program based on Access 2.0 and
still more than adequately continues to perform its designed task.
My question is:
Is it possible to format a reported field and force the first letter of
the verbiage to be capitalized. I found how to capitalize the entire
field but I would like fo...
|
2 |
12/30/2008 9:28:29 PM |
|
|
use same subreport in report
i'd like to use same subreport multiple times in a report; how would i change
the filter, or recordsource for each?
(subform to show data for week, month to date, then year to date) ...
|
2 |
12/30/2008 8:09:09 PM |
|
|
Export Report to Excel Worksheet
I am using Access 97. Is it possible to export two reports into the same
Excel worksheet but in different sheet?
As follows in the Same Excel Worksheet:
Access Report 1 to Sheet1
Access Report2 to Sheet2
--
EddieV
--
EddieV...
|
1 |
12/30/2008 6:41:00 PM |
|
|
Export Two Reports to the Same Excel Worksheet
I am using Access 97. Is it possible to export two reports into the same
worksheet but in different sheet?
--
EddieV...
|
2 |
12/30/2008 6:25:05 PM |
|
|
Duane Hookom's Line graph by code
Greetings all,
....asking a vague question...expecting a vague answer...
I have adapted Mr Hookom's line graph by code example report from
http://www.access.hookom.net/Samples.htm. It is based on a crosstab query and
it works fine. It graphs all the data on one graph without using MS graph.
Could the code be adapted to produce a separate graph for each series of data
in a group?
...
|
9 |
12/30/2008 6:16:14 PM |
|
|
How do I do this?
I have an Access database with 3 columns of data that have about 220,000 rows
of information in each. I want to take the vertical data and make it into a
more horizontal chart. Here's my example:
Number Job Sequence
A 10 10
A 5 20
A 20 30
A 5 40
B 10 10
B 5 20
B 70 30
B 5 40
B 25A 50
C 10 10
C 5 20
C 70 30
C 5 40
C 25A 50
C 5 60
10 20 30 40 5...
|
4 |
12/30/2008 6:09:01 PM |
|
|
"Enter Parameter Value" box problem
I know this is a common problem, but I haven't been able to find a solution
by reading through past Discussions. The "Enter Parameter Value" box pops up
when I try to view my report. I don't need to enter any parameters,
therefore I don't want this box coming up. It is looking for the "Price"
parameter.
The name of the control (text box) is "Price". The Control Source is:
=IIf([P...
|
9 |
12/30/2008 3:18:00 PM |
|
|
Error 3734
I have a data base on a local server which is accessed by users using a
viewing tool. All of a sudden after the first user opens the database, all
subsequent users get the following message?
"The database has been placed in a state by user <name> on machine <name>
that prevents it from being opened or locked. (Error 3734)
This error occurs when the new passive shutdown/conne...
|
2 |
12/30/2008 2:49:01 PM |
|
|
#Deleted - what does this mean
I have a table, one of the fields is a memo field. For some reason it has
become non updateable and contains the text
#Deleted
Your changes can not be made because the field"field name" has been updated
by another user.
The database is on a server and is accessed by multiple users, but even when
no one else is logged in this error occurs?
Any help or ideas appreciated.
Thanks
...
|
3 |
12/30/2008 2:08:35 PM |
|
|
Trying to extract stats from lots of information in access
Hello, I am in need of some help on how to create a report that gathers the
information needed below.
I currently have an Access file that has over 100,000 records with about 30
different columns of information.
One of the columns lists a "class" of customer. One, Two and Three (class).
Another column has a total amount they have paid over the lifetime of their
membership (all year...
|
4 |
12/30/2008 1:19:01 PM |