473,327 Members | 2,007 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Is there any way to find out the width of a closed report programatically?

I was just trying to get a list of all my reports along with their
widths.

I can't use the "Reports" collection because it only works on open
reports. So I tried looking into the "AllReports" collection and it
doesn't seem any more useful... only allows you to find out the name of
each report.

Sep 11 '06 #1
28 1896
"ry**********@yahoo.com" <ry**********@yahoo.comwrote in
news:11**********************@i3g2000cwc.googlegro ups.com:
I was just trying to get a list of all my reports along with
their widths.

I can't use the "Reports" collection because it only works on
open reports. So I tried looking into the "AllReports"
collection and it doesn't seem any more useful... only allows
you to find out the name of each report.
Open the report, get the width and close it again.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com
Warning: Do not use Ultimate-Anonymity
They are worthless spammers that are running a scam.

Sep 11 '06 #2
Bob Quintal wrote:
"ry**********@yahoo.com" <ry**********@yahoo.comwrote in
news:11**********************@i3g2000cwc.googlegro ups.com:
I was just trying to get a list of all my reports along with
their widths.

I can't use the "Reports" collection because it only works on
open reports. So I tried looking into the "AllReports"
collection and it doesn't seem any more useful... only allows
you to find out the name of each report.
Open the report, get the width and close it again.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com
Warning: Do not use Ultimate-Anonymity
They are worthless spammers that are running a scam.
Thanks, Bob!

But too late, actually. I'd already gotten answer from another "guru"
elsewhere...

Turns out to get the width of a closed report in Access (which is what
I was trying to do), all I have to do is open the report. Then I can
get the width! All I have to do at that point is close the report and
pretend it was closed the whole time. I make a fool out of myself this
way, but, since I am following "guru" advice I feel great about it...
which makes me doubly foolish; but still feeling fine!

Genius, huh?

It gets even better, though! If you'll recall (or maybe you won't?),
I'm trying to get the widths of all my reports. And there are a lot of
them - thus the idea to do it without opening each one -- so doing it
this way takes a long time, but with each reiteration I feel more and
more euphoric.

Supercalifragilistic!

Huh?

Sep 13 '06 #3

Well, you know what, I was going to post some code to help you in this task
but I don't know if I could stand the dazzling wit and sarcasm you throw at
people who try to help you, so I won't.

Don't despair though, there are millions of people out there who's goodwill
you can take advantage of and then abuse them for their trouble.

--

Terry Kreft
<ry**********@yahoo.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Bob Quintal wrote:
"ry**********@yahoo.com" <ry**********@yahoo.comwrote in
news:11**********************@i3g2000cwc.googlegro ups.com:
I was just trying to get a list of all my reports along with
their widths.
>
I can't use the "Reports" collection because it only works on
open reports. So I tried looking into the "AllReports"
collection and it doesn't seem any more useful... only allows
you to find out the name of each report.
>
Open the report, get the width and close it again.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com
Warning: Do not use Ultimate-Anonymity
They are worthless spammers that are running a scam.

Thanks, Bob!

But too late, actually. I'd already gotten answer from another "guru"
elsewhere...

Turns out to get the width of a closed report in Access (which is what
I was trying to do), all I have to do is open the report. Then I can
get the width! All I have to do at that point is close the report and
pretend it was closed the whole time. I make a fool out of myself this
way, but, since I am following "guru" advice I feel great about it...
which makes me doubly foolish; but still feeling fine!

Genius, huh?

It gets even better, though! If you'll recall (or maybe you won't?),
I'm trying to get the widths of all my reports. And there are a lot of
them - thus the idea to do it without opening each one -- so doing it
this way takes a long time, but with each reiteration I feel more and
more euphoric.

Supercalifragilistic!

Huh?

Sep 13 '06 #4

Terry Kreft wrote:
Well, you know what, I was going to post some code to help you in this task
but I don't know if I could stand the dazzling wit and sarcasm you throw at
people who try to help you, so I won't.

Don't despair though, there are millions of people out there who's goodwill
you can take advantage of and then abuse them for their trouble.

--

Terry Kreft
Wow, Terry, you're in rare form today. That MLH post was pure dead
brilliant!

Sep 14 '06 #5
pi********@hotmail.com wrote:
>
Wow, Terry, you're in rare form today. That MLH post was pure dead
brilliant!
Wow! Toady's got a toady!

There was no attempt "help" in the first reply to my request for info
on how to get the width of a *closed* report. Just a smart-assed "open
the report"... And I wouldn't have bothered responding, but I thought
I'd check to see if the respondent was just a good-natured doofus.
Guess what? The *very first* thread I came across in which Bob Q had
participated prior to coming in here and giving his smart-assed
response? Bob Q was *joining in* in attacking the first responder of
*that* thread for apparently not reading the question asked.

Too much.

As is Terry's claim that Bob was "trying to help" with his "open the
report, get the width, close the report."

As is Terry's other claim, I suspect.

Thanks for all your help, gurus. Do you guys have a paypal account or
something so that I can send some money?

Sep 14 '06 #6
On 13 Sep 2006 21:12:20 -0700, "Ryan H" <qu****************@yahoo.comwrote:
>Thanks for all your help, gurus. Do you guys have a paypal account or
something so that I can send some money?
Don't send money, just don't come back.
Wayne Gillespie
Gosford NSW Australia
Sep 14 '06 #7

Against my better judgement I'm going to try and educate you.

Consider:-
1) Just because you think of a way you want to do something doesn't mean
that you can actually do it that way.
2) With respect to getting a reports width; Bob Quintal's answer was
correct.

Now we can turn this into a fairly simple logical exercise by reiterating
the original statements
1) (paraphrased) "I want to be able to get the widths of all reports
without opening them"
2) "Open the report, get the width and close it again"

Can you see that by combining the information we have at this point we can
come to the conclusion that you can't do what you want?

By expanding on what Bob says you can see that what you have to do is
iterate through the AllReports collection to get the name of each report,
you can then use that to open each report and get the report width and close
the report again.

BTW despite your libellous allegation the people in this NG (with one
notable exception who shall remain nameless) respond for free, in their own
time with out expecting any recompense.

You on the other hand appear arrogant and really quite incapable of taking
advice in the manner in which it was meant.

Consider; being a smart-arse doesn't mean your smart.

--

Terry Kreft
"Ryan H" <qu****************@yahoo.comwrote in message
news:11*********************@e63g2000cwd.googlegro ups.com...
pi********@hotmail.com wrote:

Wow, Terry, you're in rare form today. That MLH post was pure dead
brilliant!

Wow! Toady's got a toady!

There was no attempt "help" in the first reply to my request for info
on how to get the width of a *closed* report. Just a smart-assed "open
the report"... And I wouldn't have bothered responding, but I thought
I'd check to see if the respondent was just a good-natured doofus.
Guess what? The *very first* thread I came across in which Bob Q had
participated prior to coming in here and giving his smart-assed
response? Bob Q was *joining in* in attacking the first responder of
*that* thread for apparently not reading the question asked.

Too much.

As is Terry's claim that Bob was "trying to help" with his "open the
report, get the width, close the report."

As is Terry's other claim, I suspect.

Thanks for all your help, gurus. Do you guys have a paypal account or
something so that I can send some money?

Sep 14 '06 #8
"Ryan H" <qu****************@yahoo.comwrote in
news:11*********************@e63g2000cwd.googlegro ups.com:
pi********@hotmail.com wrote:
>>
Wow, Terry, you're in rare form today. That MLH post was pure dead
brilliant!

Wow! Toady's got a toady!

There was no attempt "help" in the first reply to my request for info
on how to get the width of a *closed* report. Just a smart-assed "open
the report"... And I wouldn't have bothered responding, but I thought
I'd check to see if the respondent was just a good-natured doofus.
Guess what? The *very first* thread I came across in which Bob Q had
participated prior to coming in here and giving his smart-assed
response? Bob Q was *joining in* in attacking the first responder of
*that* thread for apparently not reading the question asked.

Too much.

As is Terry's claim that Bob was "trying to help" with his "open the
report, get the width, close the report."

As is Terry's other claim, I suspect.

Thanks for all your help, gurus. Do you guys have a paypal account or
something so that I can send some money?
Well, you know what, I was going to post some code to help you in this task
but I don't know if I could stand the dazzling wit and sarcasm you throw at
people who try to help you, so I won't.

Don't despair though, there are millions of people out there who's goodwill
you can take advantage of and then abuse them for their trouble.

--
Lyle Fairfield
Sep 14 '06 #9
LOL!

Lyle, if you weren't in this world I'd have to invent you!

--

Terry Kreft
"Lyle Fairfield" <ly***********@aim.comwrote in message
news:Xn*********************************@216.221.8 1.119...
"Ryan H" <qu****************@yahoo.comwrote in
news:11*********************@e63g2000cwd.googlegro ups.com:
pi********@hotmail.com wrote:
>
Wow, Terry, you're in rare form today. That MLH post was pure dead
brilliant!
Wow! Toady's got a toady!

There was no attempt "help" in the first reply to my request for info
on how to get the width of a *closed* report. Just a smart-assed "open
the report"... And I wouldn't have bothered responding, but I thought
I'd check to see if the respondent was just a good-natured doofus.
Guess what? The *very first* thread I came across in which Bob Q had
participated prior to coming in here and giving his smart-assed
response? Bob Q was *joining in* in attacking the first responder of
*that* thread for apparently not reading the question asked.

Too much.

As is Terry's claim that Bob was "trying to help" with his "open the
report, get the width, close the report."

As is Terry's other claim, I suspect.

Thanks for all your help, gurus. Do you guys have a paypal account or
something so that I can send some money?

Well, you know what, I was going to post some code to help you in this
task
but I don't know if I could stand the dazzling wit and sarcasm you throw
at
people who try to help you, so I won't.

Don't despair though, there are millions of people out there who's
goodwill
you can take advantage of and then abuse them for their trouble.

--
Lyle Fairfield

Sep 14 '06 #10
Terry Kreft wrote:
LOL!
I've been using your stuff since back in the last century, Terry. Why
stop now?

Sep 14 '06 #11
"Ryan H" <qu****************@yahoo.comwrote in
news:11*********************@e63g2000cwd.googlegro ups.com:
pi********@hotmail.com wrote:
>>
Wow, Terry, you're in rare form today. That MLH post was
pure dead brilliant!

Wow! Toady's got a toady!

There was no attempt "help" in the first reply to my request
for info on how to get the width of a *closed* report. Just a
smart-assed "open the report"...
First of all it wasn't smartassed! What you failed to read in my
message is that ther is NO WAY you can get a VALID width or
height value from a closed report.

All the original idiot poster said is I can't use the reports
collection because it only works on open reports.

There are people who get their head so far up their rectum in
their concept of how do do something that they overlook the
obvious alternative solution. .

And I wouldn't have bothered
responding, but I thought I'd check to see if the respondent
was just a good-natured doofus. Guess what? The *very first*
thread I came across in which Bob Q had participated prior to
coming in here and giving his smart-assed response? Bob Q was
*joining in* in attacking the first responder of *that* thread
for apparently not reading the question asked.
Well you obviously didn't read far enough. I suppose you've
posted here before under such aliases as PCDatasheet or Steve?
You certainly come off as dense as he.
What you failed to read in my message is that there is NO WAY
you can get a VALID width or height value from a closed report.

Too much.
You certainly are.
As is Terry's claim that Bob was "trying to help" with his
"open the report, get the width, close the report."

As is Terry's other claim, I suspect.

Thanks for all your help, gurus. Do you guys have a paypal
account or something so that I can send some money?
No. Just go away. Don't go away mad, just go away.


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Sep 14 '06 #12
Bob Quintal wrote:
What you failed to read in my message is that there is NO WAY
you can get a VALID width or height value from a closed report.
Well ...

If one saves the report as text and reads the text (all with code, of
course), one can extract a "width" in (I believe) pixels. And one could
convert this number of pixels to chains, centimeters, nautical miles,
inches or whatever as well.

This may sound expensive in terms of time, but it should take only a
second or two for each report.

Now is the width so obtained "the" width, or a Valid Width, or any use
at all? I have no idea. It certainly is of no value for me, which is
why I haven't got a code sample to post.

And some might argue that a report saved as text was opened. I wouldn't
agree but I can't think of why that matters.

My inclination on reading the OP was to reply, "Sure, there's a way.
Write down zero (0). That is the width of every closed report." But
something happened as I was about to send, and the post was cancelled.
Maybe that was a good thing.

None of the people who live around here are buried in the local
cemetery. Why? It's because they're not dead, yet. The closed report is
like that.
(Grammar apologies)

I think your original answer was complete and sufficient.

Sep 15 '06 #13
I think most everyone here, with the exception of the OP, understood
the answer. He was so anxious to get into a pissing contest with
everyone here that was able to help him that he couldn't be bothered
to ask for further explanation.
Sep 15 '06 #14
Lateral Lyle,
Yes, it's pixels.

Thing is I'm desperately trying not to code it now.

--

Terry Kreft
"Lyle Fairfield" <ly***********@aim.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Bob Quintal wrote:
What you failed to read in my message is that there is NO WAY
you can get a VALID width or height value from a closed report.

Well ...

If one saves the report as text and reads the text (all with code, of
course), one can extract a "width" in (I believe) pixels. And one could
convert this number of pixels to chains, centimeters, nautical miles,
inches or whatever as well.
<SNIP>
I think your original answer was complete and sufficient.

Sep 15 '06 #15
Randy Harris wrote:
I think most everyone here, with the exception of the OP, understood
the answer. He was so anxious to get into a pissing contest with
everyone here that was able to help him that he couldn't be bothered
to ask for further explanation.
Wrong. I wasn't anxious to get into a pissing contest with anyone; what
I was looking for was an answer to my question: is there a way to get
the width of reports without opening them? What I got was a
smart-assed, flippant answer.

Question: I'm trying to get to Hawaii without getting wet.

Random Wiseass: Swim! And when you reach the beach, towel off.

(This reply from Random-Wiseass *obviously* means there are no boats or
planes!)

I see now that Bob Q claims his answer was meant to be serious. He is
honestly claiming that it's something clever to explain to people that
in fact reports *can* be opened. His buddies seem to think this is
beyond the rest of us too and that he should be commended for letting
the rest of us in on this arcane bit of knowledge...

It was a smart-assed answer and deserved the derision it received. I'm
sorry if it was so biting that it caused a bunch of toadies to come
clamoring in here disappointed by the fact that they wouldn't have the
chance to put forth their smart-assed answers (eg., "Sure, there's a
way. Write down zero (0). That is the width of every closed report."),
and, instead, were only able to try and defend the thoroughly
smacked-down Bob Q.

I really wasn't looking for an argument. And I didn't insult anyone who
didn't attempt to insult my intelligence with inanities. I certainly
didn't insult the *whole NG*. This is the truth.

Don't be a fool and come at me with idiotic tripe and I won't have to
make fun of you. That's easy enough, eh? And don't come shuffling up
beside the fool, dumbstruck and disappointed, and pretend that you have
something less foolish to say... else you'll be ridiculed as well.

Lastly -- when you've recovered from your smack-down and your toadies
have received their own -- don't try and distort the record, claiming
that your flippancy was clarity and that my clairty was unclear. I
*specifically* asked if there was a way to get the width of reports
*without* opening them; the clown responded, "Yes, just open them!"

The clown, now stumbling over his big, floppy shoes as he fumbles with
the eraser and the chalk to re-write both sides of what was said, will
only end up a sad clown. Ignored rather than responded to, but laughed
at all the same.

I have no beef with you, Randy. Should I begin to?

Do you honestly think it's a revelation to me or anyone else that I
could open the reports?

The reply wasn't, "No. I don't know of any way that you can get to any
properties beyond the name of a closed report. I suppose you'll have to
use the "Reports" collection you mentioned and go ahead and open them."

The reply was smug.

And my reply to that silly reply was sarcasm so brutal that the
recipents adolescent children felt the blow... and unhappily came
crying to me for more.

I was *not* looking to do this, but I certainly do not regret it. I am
sorry if there are those of you that got confused by the whimpers of
the children and their papa and took offense.

Sep 15 '06 #16
You really don't have to keep posting to the NG, we do get it; you're an
illiterate, juvenile fool who actually believes that the appropriate
response to someone trying to help you is to spout insults attempt sarcasm
and generally spit your dummy out.

Of course, you never for one second thought that the appropriate response to
Bob's post was to point out that you thought it should be possible to do
this with the reports closed, which then would have allowed Bob (or indeed
anyone with a smidgen of knowledge of the subject) to realise you had missed
the point of his response and explicitly state that this is not possible
(excepting Lyles lateral idea of using SaveAsText).

Stop trying to twist it, you asked a stupid question to which you received a
sensible reply. Just because you didn't appreciate the implication of the
answer and it wasn't the answer you wanted doesn't make it flippant,
smart-arse or anything else.

You need to realise that your responses in this thread are much more
illustrative of your own character than they are descriptive of anyone else
involved.

Try to put yourself in an objective frame of mind instead of the emotional
one you seem to live in, review the thread and see if you can spot the
person who really shines as the disruptive influence.

--
Terry Kreft


"Ryan H" <qu****************@yahoo.comwrote in message
news:11*********************@m73g2000cwd.googlegro ups.com...
Randy Harris wrote:
I think most everyone here, with the exception of the OP, understood
the answer. He was so anxious to get into a pissing contest with
everyone here that was able to help him that he couldn't be bothered
to ask for further explanation.

Wrong. I wasn't anxious to get into a pissing contest with anyone; what
I was looking for was an answer to my question: is there a way to get
the width of reports without opening them? What I got was a
smart-assed, flippant answer.

Question: I'm trying to get to Hawaii without getting wet.

Random Wiseass: Swim! And when you reach the beach, towel off.

(This reply from Random-Wiseass *obviously* means there are no boats or
planes!)

I see now that Bob Q claims his answer was meant to be serious. He is
honestly claiming that it's something clever to explain to people that
in fact reports *can* be opened. His buddies seem to think this is
beyond the rest of us too and that he should be commended for letting
the rest of us in on this arcane bit of knowledge...

It was a smart-assed answer and deserved the derision it received. I'm
sorry if it was so biting that it caused a bunch of toadies to come
clamoring in here disappointed by the fact that they wouldn't have the
chance to put forth their smart-assed answers (eg., "Sure, there's a
way. Write down zero (0). That is the width of every closed report."),
and, instead, were only able to try and defend the thoroughly
smacked-down Bob Q.

I really wasn't looking for an argument. And I didn't insult anyone who
didn't attempt to insult my intelligence with inanities. I certainly
didn't insult the *whole NG*. This is the truth.

Don't be a fool and come at me with idiotic tripe and I won't have to
make fun of you. That's easy enough, eh? And don't come shuffling up
beside the fool, dumbstruck and disappointed, and pretend that you have
something less foolish to say... else you'll be ridiculed as well.

Lastly -- when you've recovered from your smack-down and your toadies
have received their own -- don't try and distort the record, claiming
that your flippancy was clarity and that my clairty was unclear. I
*specifically* asked if there was a way to get the width of reports
*without* opening them; the clown responded, "Yes, just open them!"

The clown, now stumbling over his big, floppy shoes as he fumbles with
the eraser and the chalk to re-write both sides of what was said, will
only end up a sad clown. Ignored rather than responded to, but laughed
at all the same.

I have no beef with you, Randy. Should I begin to?

Do you honestly think it's a revelation to me or anyone else that I
could open the reports?

The reply wasn't, "No. I don't know of any way that you can get to any
properties beyond the name of a closed report. I suppose you'll have to
use the "Reports" collection you mentioned and go ahead and open them."

The reply was smug.

And my reply to that silly reply was sarcasm so brutal that the
recipents adolescent children felt the blow... and unhappily came
crying to me for more.

I was *not* looking to do this, but I certainly do not regret it. I am
sorry if there are those of you that got confused by the whimpers of
the children and their papa and took offense.

Sep 15 '06 #17
rkc
Terry Kreft wrote:
Stop trying to twist it, you asked a stupid question to which you received a
sensible reply.
Actually, he recieved a sensible reply without ever asking a question.
Sep 15 '06 #18
In my opinion you misinterpreted the nature and intent of Bob's reply.
It is correct and suggicient. If you had asked, "How can I obtain the
width of a report simply and easily using code?" and explained your
reason for wanting to be able to do so, answers might have been
different and more helpful.

This is morning coffee whimsical code; as such it is not tested very
well and could be inefficient or even produce results which are not
correct.

Public Sub NoteReportWidths()
Dim b As String
Dim f As String
Dim n As Integer
Dim r As AccessObject
Dim tw As Long
Dim iw As Double
Dim cw As Double
f = "temp" & Format(Date, "yyyymmddhhnnss")
n = FreeFile()
For Each r In CurrentProject.AllReports
With r
SaveAsText acReport, .Name, f
Open f For Binary As #n
b = String(LOF(n), vbNullChar)
Get #n, , b
tw = Val(Mid$(b, InStr(b, "Width =") + 7, 96))
iw = tw / 1440
cw = iw * 2.54
iw = Round(iw, 2)
cw = Round(cw, 2)
Close #n
With .Properties
.Add "TwipWidth", tw
.Item("TwipWidth").Value = tw
.Add "InchWidth", iw
.Item("InchWidth").Value = CStr(iw)
.Add "CentimeterWidth", cw
.Item("CentimeterWidth").Value = CStr(cw)
End With
End With
Next r
NoteReportExit:
Close
Kill f
Exit Sub
NoteReportError:
With Err
MsgBox .Description, vbCritical, "Error #" & .Number
End With
Resume NoteReportExit
End Sub

Sub Test()
Dim r As AccessObject
Dim p As AccessObjectProperty
For Each r In CurrentProject.AllReports
With r
Debug.Print .Name
For Each p In .Properties
With p
Debug.Print .Name, .Value
End With
Next p
Debug.Print
End With
Next r
End Sub

For my play instance of Northwind the test sub shows the following in
the immediate window.

Alphabetical List of Products
TwipWidth 9360
InchWidth 6.5
CentimeterWidth 16.51

Catalog
TwipWidth 9363
InchWidth 6.5
CentimeterWidth 16.52

Customer Labels
TwipWidth 3715
InchWidth 2.58
CentimeterWidth 6.55

Invoice
TwipWidth 9367
InchWidth 6.5
CentimeterWidth 16.52

Products by Category
TwipWidth 13680
InchWidth 9.5
CentimeterWidth 24.13

Sales by Category
TwipWidth 12915
InchWidth 8.97
CentimeterWidth 22.78

Sales by Category Subreport
TwipWidth 4032
InchWidth 2.8
CentimeterWidth 7.11

Sales by Year Subreport
TwipWidth 8640
InchWidth 6
CentimeterWidth 15.24

Sales Totals by Amount
TwipWidth 9360
InchWidth 6.5
CentimeterWidth 16.51

Summary of Sales by Quarter
TwipWidth 9345
InchWidth 6.49
CentimeterWidth 16.48

Summary of Sales by Year
TwipWidth 8625
InchWidth 5.99
CentimeterWidth 15.21

Employee Sales by Country
TwipWidth 9360
InchWidth 6.5
CentimeterWidth 16.51

Sales by Year
TwipWidth 9360
InchWidth 6.5
CentimeterWidth 16.51

Of course, the new properties are entirely independent of report
Design. Creating a new report or modifying the design of an existing
report requires that the code be run again to ensure that the
properties are up-to-date.

Sep 15 '06 #19
----- Original Message -----
From: "Bob Quintal" <rq******@sPAmpatico.ca>
Well you obviously didn't read far enough. I suppose you've
posted here before under such aliases as PCDatasheet or Steve?
You certainly come off as dense as he.
Ssstttt !!. IMO this is not Steve, but please don't wake him .... ;-)
No. Just go away. Don't go away mad, just go away.
I remember you saying this (to Steve)...
In the end it worked out. He got lost in the woodworks ... ??

Arno R
Sep 15 '06 #20
I stand corrected.
--
Terry Kreft
"rkc" <rk*@rochester.yabba.dabba.do.rr.bombwrote in message
news:RZ******************@twister.nyroc.rr.com...
Terry Kreft wrote:
Stop trying to twist it, you asked a stupid question to which you
received a
sensible reply.

Actually, he recieved a sensible reply without ever asking a question.

Sep 15 '06 #21
ry**********@yahoo.com wrote:
them - thus the idea to do it without opening each one -- so doing it
this way takes a long time, but with each reiteration I feel more and
more euphoric.
Why should opening the reports in design mode take that long? Are you
changing the widths dynamically, making design mode inappropriate?
Then again, I don't want to interrupt your euphoria so feel free to
reiterate :-).

James A. Fortune
CD********@FortuneJames.com

Never work on an engineering project in isolation. Always consider how
it fits in with the rest of the organization. -- Dr. Wedekind

Sep 15 '06 #22
"Ryan H" <qu****************@yahoo.comwrote in
news:11*********************@m73g2000cwd.googlegro ups.com:
Question: I'm trying to get to Hawaii without getting wet.

Random Wiseass: Swim! And when you reach the beach, towel off.
Before the invention of boats, and airplanes, that *was* the only
option.

Unless you want to take Lyle's suggestion and read the pixel value
from the SaveAsText version of the report, and then figure out a
method for calculating a screen-resolution-independent value from
that, then you're in the same circumstance.

Have you somewhere provided a good reason for why opening the report
(the easiest possible way to get your answer) is not going to work?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Sep 15 '06 #23
"Terry Kreft" <te*********@mps.co.ukwrote in
news:WK******************************@eclipse.net. uk:
Lyles lateral idea of using SaveAsText
But the pixel value would have to be converted into a
screen-resolution-independent value, and that means poking into APIs
that tell you how big pixels are and what the screen resolution is
and so forth.

That's orders of magnitude *harder* than just opening the bleeding
report.

Has the OP supplied a reason as to *why* in his situation opening
the report is not a satisfactory solution? Is it just too *easy*?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Sep 15 '06 #24
"Ryan H" <qu****************@yahoo.comwrote in
news:11*********************@m73g2000cwd.googlegro ups.com:
Randy Harris wrote:
>I think most everyone here, with the exception of the OP,
understood the answer. He was so anxious to get into a
pissing contest with everyone here that was able to help him
that he couldn't be bothered to ask for further explanation.

Wrong. I wasn't anxious to get into a pissing contest with
anyone; what I was looking for was an answer to my question:
No, what you ask below is a different question. Stop trying to
squirm out of the spot you got yourself into.

For reference, the original post was
I was just trying to get a list of all my reports along with
their widths.

I can't use the "Reports" collection because it only works on
open reports. So I tried looking into the "AllReports"
collection and it doesn't seem any more useful... only allows
you to find out the name of each report.
So I concluded, from what you wrote that
1) you need a list of all reports, open and closed.

To get this you use the allReports.
2) you need to determine the width of each of those reports.

Once you obtain the name of a report, which must come from the
AllReports collection, you determine it's width by opening it,
getting the .width property, and closing the report,

My big mistake was assuming that you were intelligent enough to
figure out those steps from my response.
is there a way to get the width of reports without opening
them? What I got was a smart-assed, flippant answer.
You should have said that in your original post.

You sounded like a normal guy who had overlooked the obvious
solution. It happens to the best of us.
It was a smart-assed answer and deserved the derision it
received.
Maybe it was a smart-assed response to a dumb-assed question.
I'm sorry if it was so biting that it caused a bunch
of toadies to come clamoring in here disappointed by the fact
that they wouldn't have the chance to put forth their
smart-assed answers (eg., "Sure, there's a way. Write down
zero (0). That is the width of every closed report."), and,
instead, were only able to try and defend the thoroughly
smacked-down Bob Q.
I really wasn't looking for an argument. And I didn't insult
anyone who didn't attempt to insult my intelligence with
inanities. I certainly didn't insult the *whole NG*. This is
the truth.
Get off your high horse. I suspect the real reason you took
offense is that you realized that you had missed such an obvious
response.

Lastly -- when you've recovered from your smack-down and your
toadies have received their own -- don't try and distort the
record, claiming that your flippancy was clarity and that my
clairty was unclear. I *specifically* asked if there was a way
to get the width of reports *without* opening them; the clown
responded, "Yes, just open them!"
You have just made m4e angry enough to call you a stupid,
belligerent, f@#King liar. I reinserted your original post
above.
I was *not* looking to do this, but I certainly do not regret
it. I am sorry if there are those of you that got confused by
the whimpers of the children and their papa and took offense.
You do seem very offensive. You have no regrets, just like that
punk vampire that shot up 20 kids in a school where I used to
teach.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Sep 15 '06 #25
On 15 Sep 2006 01:07:19 -0700, "Ryan H" <qu****************@yahoo.com>
wrote:
>Randy Harris wrote:
>I think most everyone here, with the exception of the OP, understood
the answer. He was so anxious to get into a pissing contest with
everyone here that was able to help him that he couldn't be bothered
to ask for further explanation.

Wrong. I wasn't anxious to get into a pissing contest with anyone; what
I was looking for was an answer to my question: is there a way to get
the width of reports without opening them? What I got was a
smart-assed, flippant answer.
You might want to go back and read your original post. You did not
ask that question. Simply look at the subject line that you posted.
The answer to that question is precisely what Bob posted.
>
I have no beef with you, Randy. Should I begin to?
You seem anxious to pick another fight.
>
Do you honestly think it's a revelation to me or anyone else that I
could open the reports?
In fact, I think it was a revelation to you that it could not be done
without opening the report. I further suspect that your nasty follow
up posts are largely a result of your embarrassment over not
understanding the answer that you were given initially.

-=-=-=-=-=-=-=-=-=-=-=-=
Randy Harris
tech at promail dot com
Sep 15 '06 #26
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in
news:Xn**********************************@127.0.0. 1:
Unless you want to take Lyle's suggestion and read the pixel value
from the SaveAsText version of the report,
I know it's hard to believe but I think I made an error, when I suggested
it was pixels; I should have said twips, and twips are easy (to convert).

--
Lyle Fairfield
Sep 16 '06 #27
David,
Are you by any chance trying to turn this back into a technical discussion?
<g>.

I believe you are right but as I only included the reference for the sake
of completeness I wont argue the point.

The OP
asked a question
received a correct reply
apparently didn't understand the answer (or at least it's implications)
tried to be a smart-arse (ass)
showed his character with a lot of drive-by insults.

but no, never once explained why he couldn't do this the obvious way.

--

Terry Kreft
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Terry Kreft" <te*********@mps.co.ukwrote in
news:WK******************************@eclipse.net. uk:
Lyles lateral idea of using SaveAsText

But the pixel value would have to be converted into a
screen-resolution-independent value, and that means poking into APIs
that tell you how big pixels are and what the screen resolution is
and so forth.

That's orders of magnitude *harder* than just opening the bleeding
report.

Has the OP supplied a reason as to *why* in his situation opening
the report is not a satisfactory solution? Is it just too *easy*?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Sep 16 '06 #28
I believe that if the OP just held his breath, he could generate enough hot
air to just float there.

--

Terry Kreft
"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...
"Ryan H" <qu****************@yahoo.comwrote in
news:11*********************@m73g2000cwd.googlegro ups.com:
Question: I'm trying to get to Hawaii without getting wet.

Random Wiseass: Swim! And when you reach the beach, towel off.

Before the invention of boats, and airplanes, that *was* the only
option.
<SNIP>
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Sep 16 '06 #29

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: CoreyMas | last post by:
Hello Everyone, I have been successful in creating a template column programatically using the examples provided in VS 2003. However I have not been able to programatically set the width of a...
8
by: brett | last post by:
How can I find the height and width of a webpage? Say I want to make sure someone's webpage is within an 800X600 viewing area. Width is the most important but if I can get width, I should also be...
2
by: Martin | last post by:
Hi, I have an Access 97 report that mimics an official UK Covernment Customs document, with Page Headers and Footers presenting static data for each page (logos etc). The report is made up...
2
by: Marie | last post by:
When a report is open in preview mode, you can go to the Zoom button on the toolbar at the top of the screen, type in a zoom percent different from what is in the list and the magnification changes...
15
by: Richard Hollenbeck | last post by:
I tried to ask this question before on the 14th of January but I never got a reply. I'm still struggling with the problem. I'll try to rephrase the question: I have a crosstab query with rows...
4
by: swingingming | last post by:
If Form A opens Form B with a filter set based a value on Form A. Then I closed Form A, in navigating Form B, I got some error says Access can not find Form A. How can I detect this...
28
by: Gaby | last post by:
Hi guys, I have this ASP code that is a little long to post so but you can download it off of http://whatthedeuce.net/Form.asp I cant find out what my error is. I know it is not in my Access...
16
by: vikas000000a | last post by:
Hello all, I am creating a report generation program with VB 6.0 as front-end and Oracle 10i as back-end. My reqiurements are 1. User will query the database through the front-end. 2. The...
30
ADezii
by: ADezii | last post by:
This week’s Tip of the Week will clearly demonstrate how you can dynamically set the Drop Down List Width of a Combo Box to the length of the longest item in its Row Source. The inspiration for this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.