| Thread | Last Post | Replies |
|
| returning a value from a form | 21 Feb 2005 12:50 GMT | 3 |
Using Access 2002 on WinXP. In one of the event procedures of Form1, I'm opening Form2, which has a Print button which opens a report (if the user clicks a button) which must be printed for the operation to continue.
|
| count records | 21 Feb 2005 07:59 GMT | 2 |
I am trying to set up a report that will give me a percentage of employees who are meeting their goals. I have the report set up to group the data by employee service level. However, I am having problems counting the records to show the percentage of reps that meet their goal ...
|
| growing a report for me.print statments | 21 Feb 2005 01:35 GMT | 2 |
how can i get my report to automaticly grow depending on how many lines of text i print using ME.PRINT() statment? access 97.
|
| Manipulate Page Break | 21 Feb 2005 01:15 GMT | 1 |
In Access 2000 I have a report with two group headers and the detail band: Part # Location Detail
|
| Having problems with charts (access 2002-2003) | 20 Feb 2005 21:50 GMT | 1 |
All, I am sure that I am missing something basic here, but maybe someone can lend a hand. I am trying to insert a chart to my report. The horizontal data will be
|
| Modify text box display in detail based on a value | 20 Feb 2005 21:35 GMT | 6 |
I have a text box in the detail called txtAccountNo. It populates from a variable called AccountNo and it is usually 13 characters long. However, if the record being read has AccountType = "WC" or "CO", then I want txtAccountNo to display only the first 6 characters of the ...
|
| A bit perplexed here | 20 Feb 2005 20:00 GMT | 4 |
I'm trying to create a report that will effectively print a #10 envelope, 4.125 x 9.5 inches. The headers and footers are both 0" high. The page setup properties are "page size" is
|
| Calculating pay based on start and end time | 20 Feb 2005 12:37 GMT | 1 |
I use Allen Browne's formula, PayAmount: Round(CCur(Nz(DateDiff("n", [StartDateTime], [EndDateTime]) * [HourlyRate] / 60, 0)), 2) to compute pay. But I'm having a difficult time when someone works from, say, 9:00pm to 2:00 am. I get the wrong values. How do I compute time
|
| Report Label Caption Property at Runtime | 20 Feb 2005 00:07 GMT | 5 |
I would like to give a user the ability to set the caption for a report at runtime, or in other words give the user the ability to change the title of the report header. I have a form that allows the user to enter a report title into a text box.
|
| Date Range Parameters | 19 Feb 2005 22:45 GMT | 4 |
I often use Date Range Parameters to allow users to select a report date range. Between [Start Date] And [End Date] I also use...
|
| Parameters from copied report | 19 Feb 2005 22:05 GMT | 1 |
I have copied a report from another database into my current one. I've then changed the control source in the report properties to the tables etc in the current database, and done the same in the subreport. But I keep getting pop up parameter queries each time I open the report ...
|
| Setting GroupHeaders Top Property | 19 Feb 2005 18:23 GMT | 1 |
I use the following code to determine the top of each control that will print in Groupheader3. I take the Top value of the lowest pirnted control (in the section) add a number to it and try to set the GroupHeader.Top value. My attempt is to minimize the size of the GroupHeader to ...
|
| date() and now() don't work | 19 Feb 2005 13:33 GMT | 2 |
All of a sudden all my report dates don't work. It used to use NOW() for today's date. I've tried everything to insert today's date and nothing works. I have no idea why. Help!
|
| Report hangs on certain criteria | 19 Feb 2005 13:30 GMT | 1 |
I have an Access ADP with a repots and sub report. Basically, there are about 7 subreports. The main report (rptStyles) creates a PROFILE of a design style. This profile has subreports that present the characteristics of the style.
|
| ??? Enter Parameter Value - Trim | 19 Feb 2005 06:38 GMT | 1 |
I made a change in my table (name and address) to separate city, state and zip Now when I try to create a new set of labels I get the prompt: Enter Parameter Value - Trim
|