If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
a permanent frame for report
Hello,
How do I put a permanent frame to a report? I have problems with the right & left lines. |
#2
|
|||
|
|||
a permanent frame for report
hi,
ברקת wrote: How do I put a permanent frame to a report? I have problems with the right & left lines. What kind of problems? btw, as this is English speaking news group, not really many people can read your name. Can you maybe use a transcript? mfG -- stefan -- |
#3
|
|||
|
|||
a permanent frame for report
The problem is -
If I put lines in the left & right of Detailes, the frame last only till the end of the data, and not till the footer. I want it to be on all the page, permanently. Thnx, Bareket. "Stefan Hoffmann" wrote: hi, ברקת wrote: How do I put a permanent frame to a report? I have problems with the right & left lines. What kind of problems? btw, as this is English speaking news group, not really many people can read your name. Can you maybe use a transcript? mfG -- stefan -- |
#4
|
|||
|
|||
a permanent frame for report
hi Bareket,
ברקת wrote: If I put lines in the left & right of Detailes, the frame last only till the end of the data, and not till the footer. I want it to be on all the page, permanently. Ah, okay. I don't know any smooth solution. The only thing you can do is this: You have to place lines also in the footer section and align them. mfG -- stefan -- |
#5
|
|||
|
|||
a permanent frame for report
Use the line method to draw your lines.
Private Sub Report_Page() Me.Line (50, 50)-(50, 9.5 * 1440), 0 End Sub Lookup Line Method in the help. -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County .. "Stefan Hoffmann" wrote in message ... hi Bareket, ???? wrote: If I put lines in the left & right of Detailes, the frame last only till the end of the data, and not till the footer. I want it to be on all the page, permanently. Ah, okay. I don't know any smooth solution. The only thing you can do is this: You have to place lines also in the footer section and align them. mfG -- stefan -- |
#6
|
|||
|
|||
a permanent frame for report
hi John,
John Spencer wrote: Use the line method to draw your lines. Private Sub Report_Page() Me.Line (50, 50)-(50, 9.5 * 1440), 0 End Sub Lookup Line Method in the help. As I said, not a smooth solution mfG -- stefan -- |
#7
|
|||
|
|||
a permanent frame for report
I'm sorry, I don't understand why you think that is not a "smooth" solution.
Perhaps our assumptions are different. I assumed that the user wanted to draw a line (actually lines) from the top of the first detail to the top of the page footer. I could have complicated the code by grabbing the height of the footer section and the heights of any header sections. True if there are group headers with can grow, etc. this could complicate the calculations (and perhaps introduce failure). ON the other hand if all the user wanted was to build a frame around the page excluding the page header and page footer, all she would have to do would be to define four lines. If the user wanted to change line widths, colors, etc, then they would need to do further research on those calls -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County .. "Stefan Hoffmann" wrote in message ... hi John, John Spencer wrote: Use the line method to draw your lines. Private Sub Report_Page() Me.Line (50, 50)-(50, 9.5 * 1440), 0 End Sub Lookup Line Method in the help. As I said, not a smooth solution mfG -- stefan -- |
#8
|
|||
|
|||
a permanent frame for report
hi John,
John Spencer wrote: I'm sorry, I don't understand why you think that is not a "smooth" solution. Using code here is such a non-smooth solution. imho Access should be able to render such a kind of object by itself. But it can't. Perhaps our assumptions are different. Maybe. mfG -- stefan -- |
#9
|
|||
|
|||
a permanent frame for report
John
Thank you, you helped me a lot. Bareket. "John Spencer" wrote: Use the line method to draw your lines. Private Sub Report_Page() Me.Line (50, 50)-(50, 9.5 * 1440), 0 End Sub Lookup Line Method in the help. -- John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County .. "Stefan Hoffmann" wrote in message ... hi Bareket, ???? wrote: If I put lines in the left & right of Detailes, the frame last only till the end of the data, and not till the footer. I want it to be on all the page, permanently. Ah, okay. I don't know any smooth solution. The only thing you can do is this: You have to place lines also in the footer section and align them. mfG -- stefan -- |
Thread Tools | |
Display Modes | |
|
|