|
Reports freeze on a shared database
Good afternoon, all:
I have a database that is shared to a limited group of people using
network level security. The database is based on the Microsoft
template for "Issues". There doesn't seem to be any problem completing
any of the tasks (adding issues, editing records, etc.) in terms of
sharing. However, attempting to open some of the reports will cause
the database to freeze. The res...
|
1 |
21.08.2006 17:03:25 |
|
|
Converting Access report from multiple subreports to Excel
I have developed a fairly complicated report in Access based on a dozen or so
subreports with quite a few calculated fields on the main form. Now the users
want to be able to work with this data in Excel. Simply exporting the report
to Excel does not work, because Excel wants to put each field in its own
column. So far my research has lead me to two basic paths.
1. Save the report in HT...
|
1 |
21.08.2006 16:42:01 |
|
|
Highlight number one issue?
I have a report that sums the number of defects in about 50 different
categories. Is there any way to highlight or make the number one issue stand
out every time?...
|
4 |
21.08.2006 15:31:55 |
|
|
Section width greater than page
I have several reports which look fine on my set up, but when tested by a
colleague on another machine they get blank pages and the error message about
the section width greater than the page width.
Is this something to do with printer setups?
Many thanks
Helen...
|
6 |
21.08.2006 15:12:01 |
|
|
Complex Mailing Labels
Hi,
I have a list of customers that I need to print mailing lables for. We
have many customers living in the same household and I want to send a
brochure only to each household but address the customer(s) individually.
I created the query:
Select FName + " " + LName as [Name], Address, City + ", " + State + " " +
Zip as CSZ
From Customers
How can I create the Report so the lab...
|
3 |
21.08.2006 15:03:43 |
|
|
go from code to open form and back access 2003
I run some code that fills in a form. I would like to have it jump to
the form and after someone edits it continue on in code.
Is there a way to do this. I tried setfocus; open another form;
gotocontrol so far...
Thanks.
Lewie
...
|
3 |
21.08.2006 14:55:48 |
|
|
How do I format an Access report to print data on 1/3 page
I need to print on forms that are 1/3 of a regular letter sized page cut
horizontally (8.5" x 3.667"). I cannot figure out how to format a report in
Access that accurately prints the data where it should go--one that prints
three identical 8.5" x 3.667" reports on a page.
I've tried changing the page format, the detail format, the column format.
Nothing works. Any hints?...
|
4 |
21.08.2006 13:50:02 |
|
|
Need help on printing statement of accounts
I had an Order database on my access. it is in the table, and query.
currently all my orders are recorded. by using the "fliter by selection"
function, i am able to get particular customer orders. but i am unable to
print them out. whenever i print, it shows me the whole chunk of orders data
i had.
should i keep a order table for every individual customers? is it too
inefficency as it takes...
|
1 |
21.08.2006 13:26:15 |
|
|
Order by sum value in group footer section
Hello All
I have a report with a currency field [fee] in the detail section and a
field in a group footer section with a value set to =Sum([fee]). Is it
possible for this report to display the 'groups' in order of the value of
Sum([fee]? I have tried all sorts to get this to happen, but have failed!
Hope someone can help.
Many thanks
Les
...
|
3 |
21.08.2006 06:40:39 |
|
|
issue with RTF2 control
I downloaded and installed the RTF2 ActiveX control becuase i need to format
individual words. I have a report set up a lot like the Northwinds Invoice
report. There is a main Quotation entry and then the quotation details for
that quote grouped by the quote's Quotation No. It is a listing of tasks to
be performed, their respective prices, etc. The headings are Description,
Quantity, an...
|
4 |
21.08.2006 02:29:55 |
|
|
report printsd but does not display on the screen
I have created a lot of reports successfully but I am having this problem
only in this one case.
I create the report on a table (no criteria) and it displays only, it does
not print automatically.
I then put some code in REPORT_OPEN that changes ME.REPORTSOURCE to a string
like:
SELECT * FROM tbl WHERE deliveryDate >= #1/1/2006# AND deliveryDate <=
6/1/2006#
Suddenly, it ...
|
1 |
20.08.2006 22:25:48 |
|
|
Report sums based on record dates
I have a table of transactions, some with past dates, some dated the
current date, and some dated in the near future. On a report, I'm
looking for a way to get four different sums using the transactions in
the table, each sum based on the dates of the transactions. I need a
sum of transactions in the current month dated the 15 though the 31st,
the sum of transactions from next month dated 1st...
|
2 |
20.08.2006 21:55:01 |
|
|
Calculate Total
In my report i have a sum of withdrawal box and a some of deposit box which
work fine. I am trying to create another box next to these boxes called final
balance with a formula of :
=Sum([DepositAmount]-[WithdrawalAmount])
I have used a text box and the above formula in the expression builder but
the text box i inserted does not even appear when i do a review. ...
|
5 |
20.08.2006 19:53:02 |
|
|
No data entered in table
I have a form that the user enters data into the database detail section as
below:
Machine #
Shift #
Tons
Waste
On the form I have in the header an unbound date field. This date is linked
to update the detail date on the form (I did not want the user to have to
enter the date for each production entry). All of this data goes into my
prodTable. If the user fails to enter the date (i...
|
6 |
20.08.2006 16:15:38 |
|
|
requerying sub reports
my report shows employee name/address (subreport where DATA is from a query)
in the header AND EMPLOYEE EARNINGS in the detail. The DATA table to the
report is EMPLOYEE EARNINGS. How do I requery the employee name/addrees for
the header each time the EMPLOYEE EARNINGS changes on employee id...
|
1 |
20.08.2006 06:45:01 |
|
|
Accessing control that sums in header of subreport
I've got a control [HrsMult] in the header of a subreport that calculates
the hours to multiply wage by.
It multiplies regular hours by 1, time and a half hours by 1.5, etc, and
adds them all up.
So 40 regular hours plus 2.5 hours at time and a half comes to 43.75 hours.
This I multiply by the basic wage and get the weeks wages for the guy.
I'm trying to put this amount in the detai...
|
1 |
20.08.2006 04:46:49 |
|
|
I need an accounting template for self storage warehouse units?
I need an Accounting Program similar to this one
http://www.tredd.com/features.htm I think that this could be done in Access
or Excel. I need it to accept payments for any month. Print letters. View
reports of income, deposit, late list, status list by unit size, Customer
History Report, Current Customers Report, Deposit Sheet Report, Late List
Report, Income Report, Receipt List Report,...
|
2 |
20.08.2006 03:41:56 |
|
|
PLEASE HELP....TOC item numbers
Is there a way to number item in a report that shows some like this:
Apple Pie.........................................................1
Banan Nut Bread...............................................3
I one record continues to the next page how can you keep track of the report
numbering. In the current TOC I have it's placing everthing on page 1.....ANY
HELP OUT THERE!!
--
Message...
|
13 |
19.08.2006 18:08:24 |
|
|
chart: line-column with 2 Y axes
Hello;
Is there any way to set up a chart that has a line and a column with 2 Y
axes using the Chart Wizard? This type of chart is available as a custom
chart in Excel but I can't find it in Access.
Thanks for your help.
G....
|
1 |
19.08.2006 12:51:02 |
|
|
Using variables in control sources
how can i set a variable for the control source of a field in a report so
that i can use a form to determine what the control source should be. for
example, my report will show budgets for a select group of fiscal years. i
want use a form that will allow me to choose which fiscal years are shown.
My report is linked to a crosstab query that breaks down my information as
follows:
Bu...
|
13 |
19.08.2006 09:05:32 |
|
|
Dynamic Reports?
If I have a table which has 56 columns and on average only 22 columns
are filled, but these change, depending on what is selected. The
defaut(s) are blank. With an input form I need all 56 bound controls
as all "may" be used. In terms of a report: I only want returned the
data for a record. Specifically for an individual record, is there a
way that only the 22 columns that have changed ...
|
4 |
19.08.2006 03:14:15 |
|
|
repeat a copy of a report based on a parameter
I have a report for generating labels with specific customer information on
them. Customers have the ability to 'split' individual items on their order.
When this happens, I need to duplicate that individual item by printing a
second report label.
I do all printing in batch at the beginning of the day and would like the
split duplicate report labels to be batched combined into the sam...
|
2 |
18.08.2006 23:58:51 |
|
|
Access Question about Reports
Hello. I am trying to combine three queries onto one report - one query is
on the left, one is on the top right, and one is on the bottom right - and I
am having a problem combining the data from all three. There is a common
field which I have grouped the data by and which is common in all three
queries, let's call it the "Baseball Teams" field. I want the baseball team
headings from ...
|
2 |
18.08.2006 23:36:02 |
|
|
Getting rid of blank spaces in a report
I have a display issue that I am unable to resolve. I have a table setup as
follows:
Text--Num--Item1--Item2--Item3--Item4
T1-------6-------A--------B-------C
T2-------3-------A--------D
T3-------5-------C--------E-------G-------J
(NOTE: the dashes are just to make my message look clean). Each “item†column
uses a combo box. The sub-table for each combo box is the same. I want to...
|
6 |
18.08.2006 21:24:52 |
|
|
Duplications created
Okay, I have one more problem.
I have a log of subcontractors and for the most part it works perfect,
however, I have one subcontract who is working on 4 different parts of the
job and has 4 separate contracts. When I generate my report it give me
Danica with each separate contract number four times instead of once with
each contract number. How do I get it to show only one entry wit...
|
2 |
18.08.2006 21:18:04 |