Reports

run-time error 2501
I keep getting 'runtime error 2501', and I am unsure of what code to use to fix. Here is what I'm doing. Click open a report, then the report 'On Open' event triggers a form to open. This form allows user to select the parameter (in this case, the employee) to use in the query that populates the report. All wor... 25 Aug 2006 15:31

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 b... 24 Aug 2006 12:35

Custom toolbar icon prints form instead of report
I have a report with a custom toolbar. When I open the report and press the printer icon, it prints the report to my printer. However, when my user opens the report and presses the printer icon, it prints an image of another open form, a menu that is hidden behind the report. What causes this and how can I fix i... 21 Aug 2006 21:04

Crosstab
I recently researched how to make dynamic crosstab reports, and settled on a solution by Duane Hookum. However, the solution was written in Access97 format, and I seem to be running across a small snag. When I try to compile the database I get an error: "Method or data member not found", and the line ..E... 17 Aug 2006 17:07

#Error Message in Report
The query parameters correctly return no records. The report that is run based on this query returns #Error in the report controls. What is syntax to use so that when the query correctly returns no records a Zero is displayed in the report instead of #Error. Thank you for your help on this. ... 18 Aug 2006 10:08

Report not showing record with a blank field
I have noticed that when i print my report if the organisation field is blank the particular record does not show for a person even though it appears the table source??? how do i fix this?? ... 17 Aug 2006 05:12

field within label
Hi, I have a field called "Bearing from [Daughter Site] to Parent Site:" Each record is based on Sites. I would like the report to populate the [Daughter Site] with the current site name within that label. Can this be done? Example: Record 1 Site Name: Auckland Label: Bearing from Auckland to Pare... 18 Aug 2006 10:40

Printing from an MS Access Database
All Superior Termite receives the following error on their server when they try to print Reports from Access: “There was an error found when printing the document "R_orderCUSTOMER" to IP_192.168.20.137.” The printer in question is a HP LaserJet 4200 and the server is SBS2000. They also use a Dymo LabelW... 14 Aug 2006 17:56

report problem
Hi; I have a report/subreport that has suddenly run into a problem loading, that did not previously exist. When I try to load the report in print preview format, I'm getting an errmsg of "you must define a sort field or expression for the group header or footer in the report you triewd to preview or paint". If I tr... 14 Aug 2006 13:19

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... 14 Sep 2006 10:45