M
Michael
Does anyone know how to rotate a subreport 90 degrees?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve
What are you trying to accomplish?
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
S
Steve
I am still not sure of exactly what you want. Take a look at basing your
subform on a crosstab query. In a crosstab query, you can specify which
field(s) are displayed as rows, which field is displayed as columns and
which field is displayed at the intersection of each row and column.
However, a crosstab query is not updateabe. If this will not work for you,
post some sample data from your subform.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
subform on a crosstab query. In a crosstab query, you can specify which
field(s) are displayed as rows, which field is displayed as columns and
which field is displayed at the intersection of each row and column.
However, a crosstab query is not updateabe. If this will not work for you,
post some sample data from your subform.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
M
Michael
I have a main deposit sheet that has our side on the top 1/2 and a coded
part on the bottom couple inches. I have the bank portion in between those
and my boss wants it to be rotated so the test is vertical while the rows
that would normally appear top to bottom go left to right.
So in other words I want to rotate the subreport 90 degrees so that it it
fits perfectly into that space with the appearance that he wants.
part on the bottom couple inches. I have the bank portion in between those
and my boss wants it to be rotated so the test is vertical while the rows
that would normally appear top to bottom go left to right.
So in other words I want to rotate the subreport 90 degrees so that it it
fits perfectly into that space with the appearance that he wants.
S
Steve
As far as I know, there is no way to just rotate a form ninety degrees.
I don't understand why your boss would want this; it makes reading the data
more difficult. Wht does he want the change in format? Perhaps we can come
up with a compromise that he will be happy with.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
I don't understand why your boss would want this; it makes reading the data
more difficult. Wht does he want the change in format? Perhaps we can come
up with a compromise that he will be happy with.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
M
Michael
Because it is a cut out sort of like paystub on check or a pro sporting
event ticket.
event ticket.
P
playmkr278
Not sure if my reply got through. The reasoning behind it is the same
reasoning behind a ticket and ticket stub. One goes one way and the other
goes the other way.
reasoning behind a ticket and ticket stub. One goes one way and the other
goes the other way.
S
Steve
Sorry, as far as I know, there is no way to just rotate a form ninety
degrees.
You might want to look in lebans.com. He has a lot of tricks up his sleeve
and if you are going to find something, that's the most ;ilely place it will
be.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
degrees.
You might want to look in lebans.com. He has a lot of tricks up his sleeve
and if you are going to find something, that's the most ;ilely place it will
be.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
S
Stephen Lebans
Michael as I have told you earlier you cannot simply rotate a section of
your report 90 degrees. You cannot mix landscape and portrait within a
single report.
Why don't you simply use several of my RotateText ActiveX controls and allow
them to rotate the contents of the relevant section?
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
your report 90 degrees. You cannot mix landscape and portrait within a
single report.
Why don't you simply use several of my RotateText ActiveX controls and allow
them to rotate the contents of the relevant section?
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
J
John Marshall, MVP
You could consider using Word's mail merge function. You can place the
information in a Word table and then rotate the text.
John... Visio MVP
information in a Word table and then rotate the text.
John... Visio MVP
M
Michael
What I don't understand is that we have a label control that can be rotated
so it only stands to reason that a subreport should be able to be rotated
similarly because aren't they both controls?
so it only stands to reason that a subreport should be able to be rotated
similarly because aren't they both controls?
M
Michael
Anyway to get it the right way for printing with as much automation (but
with as little code) as possible would be great.
with as little code) as possible would be great.
M
Michael
The RotateLabel ActiveX control works great but I cannot get the resulting
labels to go the same direction because Access reports go top to bottom by
default. And if I put them all in the footer I cannot get them to loop so
I'd have to have a way to loop them with VB at that point.
labels to go the same direction because Access reports go top to bottom by
default. And if I put them all in the footer I cannot get them to loop so
I'd have to have a way to loop them with VB at that point.
M
Michael
Also, once again, how can you code rotation for one control (that doesn't
normally have rotation) but not for another?
normally have rotation) but not for another?
M
Michael
How hard would it be to export it to excel and rotate the part I need
rotated.
rotated.
M
Michael
What wouldn't the following create a control?
Dim Rotatereport As Object
' This is a Template Report with only one Control: RotateLabel
DoCmd.OpenReport "RptRotReport", acDesign
' New control in my Report
Set Rotatereport = CreateReportControl(rpt.Name, acCustomControl, acDetail,
, , x, y)
' Get OLE Data from Template Object RotText
Rotatereport.OleData = Reports!RptRotReport!RotReport.OleData
DoCmd.Restore
' Close Template Report
DoCmd.Close acReport, "RptRotReport"
' Do cosmetics
Rotatereport.Escapement = 90 ' Rotation
Rotatereport.ControlSource = "=VDONUMMER" ' Formula of Field
Rotatereport.SpecialEffect = 0 ' no Borders
Rotatereport.Width = 300
Rotatereport.Height = 1600
Dim Rotatereport As Object
' This is a Template Report with only one Control: RotateLabel
DoCmd.OpenReport "RptRotReport", acDesign
' New control in my Report
Set Rotatereport = CreateReportControl(rpt.Name, acCustomControl, acDetail,
, , x, y)
' Get OLE Data from Template Object RotText
Rotatereport.OleData = Reports!RptRotReport!RotReport.OleData
DoCmd.Restore
' Close Template Report
DoCmd.Close acReport, "RptRotReport"
' Do cosmetics
Rotatereport.Escapement = 90 ' Rotation
Rotatereport.ControlSource = "=VDONUMMER" ' Formula of Field
Rotatereport.SpecialEffect = 0 ' no Borders
Rotatereport.Width = 300
Rotatereport.Height = 1600
M
Michael
Why wouldn't the following create a control?
Dim Rotatereport As Object
' This is a Template Report with only one Control: RotateLabel
DoCmd.OpenReport "RptRotReport", acDesign
' New control in my Report
Set Rotatereport = CreateReportControl(rpt.Name, acCustomControl, acDetail,
, , x, y)
' Get OLE Data from Template Object RotText
Rotatereport.OleData = Reports!RptRotReport!RotReport.OleData
DoCmd.Restore
' Close Template Report
DoCmd.Close acReport, "RptRotReport"
' Do cosmetics
Rotatereport.Escapement = 90 ' Rotation
Rotatereport.ControlSource = "=VDONUMMER" ' Formula of Field
Rotatereport.SpecialEffect = 0 ' no Borders
Rotatereport.Width = 300
Rotatereport.Height = 1600
Dim Rotatereport As Object
' This is a Template Report with only one Control: RotateLabel
DoCmd.OpenReport "RptRotReport", acDesign
' New control in my Report
Set Rotatereport = CreateReportControl(rpt.Name, acCustomControl, acDetail,
, , x, y)
' Get OLE Data from Template Object RotText
Rotatereport.OleData = Reports!RptRotReport!RotReport.OleData
DoCmd.Restore
' Close Template Report
DoCmd.Close acReport, "RptRotReport"
' Do cosmetics
Rotatereport.Escapement = 90 ' Rotation
Rotatereport.ControlSource = "=VDONUMMER" ' Formula of Field
Rotatereport.SpecialEffect = 0 ' no Borders
Rotatereport.Width = 300
Rotatereport.Height = 1600
M
Michael
How would I achieve a RunningSum = Overall with your rotated label?
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.