|
Help with equation
I am trying to get this formula to work in my report. I have three number
fields:
1. Setuphr (already in hrs/minutes, i.e. 5.5)
2. Cyclemin (in minutes
3. Qty (quantity)
I want to be able to convert setuphr to minutes, then add to the results to
the cyclemin/qty field (which would be minutes) then divide by 60 to get
total hours.
This is what I wrote:
=Sum([set up hours]*60)+(sum[...
|
6 |
24.08.2006 16:11:12 |
|
|
age calculate on form wont show in table: need age for reports
i work on access as my tool for lots reports:
when i made a form and create the birthdate and year area for input data,
the age get calculate fine: But: age dosnt show on my main table from which i
will make my reports: How i fix this? Age data its a must for reports i have
to made on students....
|
3 |
24.08.2006 16:06:02 |
|
|
Speed Up Loop Process
I have a report that OnClose the following code is set to run. Its purpose
is to check to see if the field "Print" is checked or not. If it is, I want
it unchecked. The code works fine, but takes forever as it has 5000 plus
records to loop through and that number will only grow. Is there anyway to
speed the process up?
Thanks!
Private Sub Report_Close()
strTableName = "tblFile...
|
6 |
24.08.2006 16:01:02 |
|
|
Avoid being prompted during Queries
I am an XP user with Access 2003. I recently created a Macro for a
client that will run certain queries and create newly exported tables.
Everything works great, but I do not want the prompts that tell me I'm
about to delete a table, etc... I've gone into Tools-->Options and
have unchecked all three boxes in the "confirm" area. Unfortunatley,
this did not get rid of the prompts that ask...
|
5 |
24.08.2006 15:39:17 |
|
|
record count
What is the easiest way to display the number of records in a report footer?
I tried using RecordsetClone.Count like I do in forms but apparently that is
not available to you in the report world. I tried =Count([myIDfield]) and
got #Error.
Thanks.
...
|
5 |
24.08.2006 14:57:06 |
|
|
Filtering subreports
Hi All,
I have a report which contains a subreport. The subreport returns a
complete list of Career History information for all employees.
When the report opens, it only opens for a single Employee, and the
subreport opens containing correctly all the Career History for that
Employee.
Is it possible to filter this list to only return the top 10 rows of
Career History?
I originally...
|
2 |
24.08.2006 14:54:04 |
|
|
Print Preview of Report prints blank
This really is quite annoying.
Have produced a report based on a query that is perfectly displayed in every
way on the print preview. However, when I press the print button, all that is
produced is a blank page. Can you help?
Most annoyingly, I remember having the same problem with another database,
came on here, found the answer and fixed it in about 30 secs. Can't remember
how I di...
|
4 |
24.08.2006 14:39:19 |
|
|
Where condition on reports doesn't work when passing parameter from the forms
DoCmd.OpenReport stDocName, acPreview, , "[ORDERID] =
Forms![OrderForm].[ORDERID]"
On access 2003 only the orderid selected on the form shown on the
report. on access 2007, all the records shows on the report. it ignore
the where condition...
Any ideas?
...
|
5 |
24.08.2006 14:30:32 |
|
|
merging and sum two text boxes
I have a report for employee production based on orders filled. For each
order we assign an employee ( each employee has its own unique number to
identify him), we put his number in a text box [EIDC], there is some orders
that we need to assign two employees and in that case we have a second text
box [EIDC2] that we assign the other employee number, in this case the order
which is based ...
|
1 |
24.08.2006 14:26:02 |
|
|
Can a displayed field not be printed?
I display a recordon the screen and if the user wants to print the record,
there is a field I do not want to show on the printout (it's ok for the user
to see it but I don't want it passed around to others).
Is there some 'property' attached to the field that will allow it to be
displayed but not printed?
Thanks for your help....
|
2 |
24.08.2006 13:48:16 |
|
|
Access2000 to 2003 problem with reports
Im currently in the process of moving a couple of databases over from
office2000 on win2k to office2003 on winXP. I've moved a couple with few
problems (mainly dao2535.tlb) but now I've been trying to move my IT
inventory db over and am having difficulties.
The main problem is that I cant seem to run any reports. I keep getting a
"OpenReport Action was cancelled" message. When i try to ...
|
7 |
24.08.2006 13:42:02 |
|
|
Making selected records in a report bold
Howdy Folks,
I have an Access report and I would like to make certain records bold
based on their value. Here's my problem. If a record has a less than
sign in it (<), I want it to be left alone. Anything that doesn't have a
less than sign should be displayed in boldface.
I tried pulling this off with conditional formatting, but I was not able
to get it to work. Since my values ar...
|
4 |
24.08.2006 13:07:07 |
|
|
Help required launching reports from a form
Hi,
I'm really new to Access 2000 and would appreciate any help with a
problem I am facing.
I have created a form which displays Employee Details. On this form I
have a button which launches a Report.
However the report I have created has details for all Employees.
If I am on record 15 on the form and click the report button, the
report opens and displays details for record 1. I would...
|
3 |
24.08.2006 11:06:21 |
|
|
How can I sum date records in an ADP report
I have converted an Access database to and ADP. We had a report which showed
helpdesk calls and the time it took to complete each one and at the bottom of
the report and at the end of each group was a text box with the countrol
source as =sum([Time to Complete]). This worked OK in Access, however now
that it is an ADP, it does not work. I have tried to change the control
source and go...
|
1 |
24.08.2006 09:55:02 |
|
|
#error on some computers
When i try to use the Sum(abs) in a report it works great on my system on the
network But on some when it prints some totals are correcr but the grand
total displays an #error in the field Other computers on same network works
ok Prints all totals with out an error message Grand total is (4) different
Sum(abs) to generate the grand total If I sum (3) the report works great When
I add the...
|
10 |
24.08.2006 01:14:34 |
|
|
Adding a hyperlinked textfile into a report
I have been given an Access database to maintain which the original author
(no longer with the organisation) used several hyperlink fields to include
additional information in the database. When I produce a report, I only get
the path to the textfile rather than the information/text in the text file.
Am I able to get the report to read the textfile and drag that information
into a report...
|
1 |
24.08.2006 00:31:02 |
|
|
data in query not on report
I have a query selecting account name, account #, # of deliveries, and time
of delivery. I've built a report on this query as well. However, I notice
on the report that the multiple account numbers and time of delivery (AM/PM)
do not display. It appears that the report is "grouping" the records by
account name or account number (I cannot figure which) and subsequently the
various time...
|
4 |
23.08.2006 22:14:21 |
|
|
Report Fields
I have two tables with data. The first has all my employees with their info,
and the second has my computer hardware and one field that refers back to the
SSN on the employee table
I want to create a report that shows all my computer hardware with the
employee name rather than their SSN showing. How can I do this?...
|
2 |
23.08.2006 21:57:15 |
|
|
Displaying a user input entry on a report
I have an ADP connected to a SQL backend. My SQL back-end creates a
temporary table for me using a Stored Procedure that only pulls records from
a master table based on input parameter prompt @As_Of_Date. Once the temp
table is created, a function is executed that further refines the dataset and
a report is created from the results. I would like to know if there is any
wayt that the...
|
1 |
23.08.2006 20:31:03 |
|
|
Printing Current Record
I posted this yesterday under the thread for "How can I print screen a
report?"
I tried your code Rick, but either get the error shown below, or when I add
the table name to the field name I get a box to enter the ID number in...
Here is the code that I am using:
If Me.Dirty Then 'Save any edits.
Me.Dirty = False
End If
If Me.NewRecord Then 'Check there is a record to...
|
1 |
23.08.2006 20:05:38 |
|
|
Error 2185, 2427, and converted report
I've converted an Access 97 database to Access 2003.
Several reports are failing, apparently because A2K3 handles the code
below differently than A97. In the report, the first line in
Detail_Format section generates error 2185 can't reference the property
of a control unless the control has focus.
If [SubR: Coverage]![Full Name].Text <> "" Then
lineStrikeOut.Visible = True...
|
1 |
23.08.2006 20:05:11 |
|
|
Mailing labels for one record
Hello,
I'd like to print a page of Avery 5264 labels of the a single record. Can
someone help me? I have Access 2003.
Thanks in advance,
Ellen...
|
2 |
23.08.2006 20:02:23 |
|
|
Setting Focus to a Report
I have a button on a form that calls up a form Dialog box with 2 radio
buttons on it. When you select a specific button, it opens a report in
Preview. Then the Dialog box is closed. This is working fine, except the
report is always hidden behind my remaining form. I need to show the report,
then when the user is finished reviewing it and closes it, the original form
will still be the...
|
2 |
23.08.2006 19:58:02 |
|
|
Using report function
I can't open an existing report and I can't create a new one????...
|
2 |
23.08.2006 19:40:41 |
|
|
duplicates repeating
If I add a field from the field list that happens to be a list box I am
getting duplicate pages. I have 'hide duplicates' set to yes on each
property of all the other fields including the list box, but I'm still
getting it. I remember there was a simple fix for this, but I cannot
remember.
help!
thanks!
...
|
1 |
23.08.2006 19:30:53 |