Topics Search

horizontal line at bottom of the detail

horizontal line at bottom of the detail
Views: 24
Can I ask regarding to how to place a horizontal line at the bottom of the detail?
Sponsored Links:

More topics

 

Header must grow same amount as detail

Preview
I know this may seem odd, but honestly, this is what I need to make the layout proper.

I have GroupHeader1. It Can Grow.
I have GroupHeader2. It Can Grow.
I have Detail. It Can Grow.

The layout results in:
GroupHeader1 | GroupHeader2 | Detail Item1
Detail Item2
Detail Item3
GroupHeader2 | Detail Item1
Detail Item2
GroupHeader1 | GroupHeader2 Detail Item1

The report requires a horizontal row at each Detail Item.

Detail Items may vary in height.
GroupHeader1 Items may vary in height.
GroupHeader2 items may vary in height.

Here's the tricky part: At all times the height of GroupHeader1, GroupHeader2 and Detail Item MUST be the same WHICH EVER IS THE GREATEST AMOUNT.

Otherwise what happens in the horizontal line of Detail may cross through the verbiage of GroupHeader1 or Groupheader2.

The width of the textboxes cannot be adjusted further.
 

Group Header is on same line as detail?

Preview
I'm trying to create a report in the format at the bottom of this post.

I've changed the number of columns to 4 and have a new row for each group.

The new row was an attempt to get the rank at least on the left of the report, else it could be the 3rd entry in the detail line after the last detail data.?
However a side effect of multiple columns is that is that the group header appears as the first entry in the detail line, so the report looks like

Rank Name Name Name

How can I achieve the desired layout please?

Desired layout

Rank (Group Header)

Name Name Name Name
Name Name Name Name
Name Name Name Name

Rank

Name Name Name Name
Name Name Name Name
Name Name Name Name
 

Hide Duplicates

Preview
I have a report in Access 2003 that creates a report as follows:
Line # detail 1 detail 2 detail 3
1 Joe Frank Steve
2 Blank Blank Jake
3 blank Sam Larry
4 Arnold blank Sarah
5 blank Peter Ruth
6 blank Ralph Joe
7 blank blank Snoopy
I'm expecting to see Sam in detail 2 line 4. I'm trying to rid myself of duplicates of detail 2 resetting on a new detail 1 and duplicates of detail 3 resetting on a change of detail 3. Lines 5 - 7 work as expected. I'm using Hide Duplicates on the text fields for detail 1 and detial 2, but when detail detail 2 is the same in the previous line as the current line then detail 2 doesn't blank out correctly.

I'm expecting to see..
Line # detail 1 detail 2 detail 3
1 Joe Frank Steve
2 blank blank Jake
3 blank Sam Larry
4 Arnold Sam Sarah
5 blank Peter Ruth
6 blank Ralph Joe
7 blank blank Snoopy
Does anyone have suggestions?
 

Drawing horizontal lines in Detail Area (Access 2003 xp sp3)

Preview
I have a report that we will use as a job card with a fixed header and footer size and a sub header of variable size. (Can grow to fit multiple items on the to-do list) What I want to do is generate horizontal lines for writing on 1cm apart in the detail section. How can the size of the detail section be calculated.

I have in mind to create Do / Until loop that generates the lines at 1cm spaces until it runs out of space. I just don't know how to determine the size of the detail space per page.

Thought - A standard page will be a set height. Can I call the height of each header and footer, subtract it from the total height and then set the detail height to the result and then use that result as the max height in my Do/Until loop?
 

Draw line in report detail

Preview
I'm trying to draw a line in the detail section of the report using VBA. Can anyone give me some guidance? I've found some help pages from microsoft, but can't get it working.

I'm using Access 2007.

I have:

Me.ScaleMode = 7
Me.Line (1, 1)-(2, 2), RGB(0, 0, 0)

In the OnPrint event of detail. I've also tried the OnPage event of the report and the OnFormat event of the detail
 

Form in design view looks perfect but not in form view

Preview
I'm designing a relatively simple form, however I seem to be having a problem with the size of my detail section. In design view the form looks exactly the way I want it to appear, but when I switch to form view the last line of text boxes in the detail section vanishes. I've tried resizing the detail section but I don't seem to be able to lower the bottom edge of the detail section to make the text boxes visible.

I've turned on the lines to show where the sections are bounded in forms view, but they never change position no matter what I do in design view...
 

Replacing one line of data with multiple lines

Preview
I have a table, called Data1. Within this table exist raw paroll data but the data is consolidated by certain segments.

I have a 2nd table, called Payroll Detail. Within this table exist the detail payroll data by employee by segment that totals line consolidated line by segment in Data1.

I'm trying to create a query or something that allows me to combine the two sets of information. I need to include some data that is in Data1 and not in Payroll Detail table. However, instead of my results showing the consolidated line by segment, I want it to match up some criteria and give me the detail by employee by segment from Payroll Detail table.

So in otherwords, I want it to replace one line from one table with several lines from the 2nd table.
 

Control of horizontal scroll bar

Preview
I am working on a searchable form (left side is for entering criteria and right side is for displaying records matching criteria). The width of the form currently exceeds my screen so I see a horizontal scrollbar on the bottom. I would like to add a command button that when clicked will cause the scrollbar to move to the right. Can anyone assist
 

how to keep information in footer section in same place on pre-printed form

Preview
How do I keep the information in the footer section of a access report from expanding when the detail section changes?

The information in the detail section is description for an invoice. It could be 1 or many lines. In the report footer section are the totals for the detail section, sales tax, sub total, invoice total.

it prints ok when we have just one line in the detail section, but when more then one line, it moves the footer section down
 

detail.height not to shrink after accommodate a large text box

Preview
Have set detail.height in OnOpen event of report. Have set Detail to can grow/can shrink. Have set text boxes in Detail section to can grow/can shrink. Have set detail.height in OnFormat event of detail section.

However, after the first time the detail section needs to grow (which it does OK) it does not shrink back for other records displayed in Detail section. LIne height is changing as it should,but not Detail section height.