473,320 Members | 2,083 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,320 software developers and data experts.

Does anyone care about DFS?

I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!
Jul 12 '06 #1
12 2408
rkc
polite person wrote:
I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!
Deeply.
Jul 12 '06 #2
polite person wrote:
I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!
Please restate the problem you're having with Access. Perhaps we can
help you, but right now, we have no idea what your problem is.

8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Jul 12 '06 #3
DFS
polite person wrote:
I posted a reply to his scatter chart problem over 24 hours ago and
still he hasn't replied!

Still hasn't...

Jul 12 '06 #4
polite person wrote:
I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!
Sure, I do. He's fine ... a bit prickly and no respecter of experience
or old age (especially mine), but that's OK. He has a mind and tries to
use it. One can actually understand what he writes! More often than not
he's right.Those traits put him in the top 5% of posters here.

Jul 12 '06 #5
On Wed, 12 Jul 2006 18:55:54 GMT, polite person <sn**@snippers.comwrote:
>I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!
Well,nobody understood my post either.
Actually I was the only one who actually DID anything but I should have known better.

Jul 12 '06 #6
polite person wrote:
On Wed, 12 Jul 2006 18:55:54 GMT, polite person <sn**@snippers.comwrote:
I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!

Well,nobody understood my post either.
Actually I was the only one who actually DID anything but I should have known better.
Geez! Not only do I know nothing about Scatter Charts but now I learn
that I know nothing about a post about a poster of a post about a post
about a scatter chart.

muttering ...

"Oh, somewhere in this favored land the sun is shining bright.
The band is playing somewhere, and somewhere hearts are light.
And, somewhere men are laughing, and little children shout,

but there is no joy in Mudville --
mighty Casey has struck out."

Jul 12 '06 #7
Lyle Fairfield wrote:
polite person wrote:
On Wed, 12 Jul 2006 18:55:54 GMT, polite person <sn**@snippers.comwrote:
>I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!
>
Well,nobody understood my post either.
Actually I was the only one who actually DID anything but I should have known better.

Geez! Not only do I know nothing about Scatter Charts but now I learn
that I know nothing about a post about a poster of a post about a post
about a scatter chart.
Ha! But that's only two strikes by my count Casey. You've still got
time...for another strike!!
>
muttering ...

"Oh, somewhere in this favored land the sun is shining bright.
The band is playing somewhere, and somewhere hearts are light.
And, somewhere men are laughing, and little children shout,

but there is no joy in Mudville --
mighty Casey has struck out."
It's interesting that words like 'playing,' 'children,' and 'mighty'
caused the Google Sponsored links all to go to Mighty World toys.

I'll try to find time this week to work on a PDF scatter chart mdb.
Any requests for features DFS? I care.

I'm thinking about small red circles with a black border for that
points. PDF has to use Bezier Curves for circles so I'm thinking along
these lines:

'PDF commands to draw a circle in a given color with the option to fill
in a color-----
Public Function DrawCircle(ByVal dblCenterX As Double, ByVal dblCenterY
As Double, ByVal dblRadius As Double, ByVal dblR As Double, dblG As
Double, dblB As Double, ByVal dblLineWidth, ByVal boolFill As Boolean,
Optional ByVal dblFillR As Double, Optional ByVal dblFillG As Double,
Optional ByVal dblFillB As Double) As String
Dim strTemp As String
Dim strCR As String
Const CRatio = 0.55228475

DrawCircle = ""
If boolFill Then
If IsMissing(dblFillR) Or IsMissing(dblFillG) Or IsMissing(dblFillB)
Then
MsgBox ("Fill color values are required.")
Exit Function
ElseIf Abs(dblFillR - 0.5) 0.5 Or Abs(dblFillG - 0.5) 0.5 Or
Abs(dblFillB - 0.5) 0.5 Then
MsgBox ("Fill color values must be between 0 and 1.")
Exit Function
End If
End If
strCR = Chr(13)
strTemp = "q" & strCR
strTemp = strTemp & CStr(dblLineWidth) & " w" & strCR
If boolFill Then
strTemp = strTemp & CStr(dblFillR) & " " & CStr(dblFillG) & " " &
CStr(dblFillB) & " rg" & strCR
End If
strTemp = strTemp & CStr(dblR) & " " & CStr(dblG) & " " & CStr(dblB) &
" RG" & strCR
strTemp = strTemp & CStr(dblCenterX + dblRadius) & " " &
CStr(dblCenterY) & " m" & strCR
strTemp = strTemp & CStr(dblCenterX + dblRadius) & " " &
CStr(dblCenterY + CRatio * dblRadius) & " " & CStr(dblCenterX + CRatio
* dblRadius) & " " & CStr(dblCenterY + dblRadius) & " " &
CStr(dblCenterX) & " " & CStr(dblCenterY + dblRadius) & " c" & strCR
strTemp = strTemp & CStr(dblCenterX - CRatio * dblRadius) & " " &
CStr(dblCenterY + dblRadius) & " " & CStr(dblCenterX - dblRadius) & " "
& CStr(dblCenterY + CRatio * dblRadius) & " " & CStr(dblCenterX -
dblRadius) & " " & CStr(dblCenterY) & " c" & strCR
strTemp = strTemp & CStr(dblCenterX - dblRadius) & " " &
CStr(dblCenterY - CRatio * dblRadius) & " " & CStr(dblCenterX - CRatio
* dblRadius) & " " & CStr(dblCenterY - dblRadius) & " " &
CStr(dblCenterX) & " " & CStr(dblCenterY - dblRadius) & " c" & strCR
strTemp = strTemp & CStr(dblCenterX + CRatio * dblRadius) & " " &
CStr(dblCenterY - dblRadius) & " " & CStr(dblCenterX + dblRadius) & " "
& CStr(dblCenterY - CRatio * dblRadius) & " " & CStr(dblCenterX +
dblRadius) & " " & CStr(dblCenterY) & " c" & strCR
If boolFill Then
strTemp = strTemp & "b" & strCR
End If
strTemp = strTemp & "S" & strCR
strTemp = strTemp & "Q" & strCR
DrawCircle = strTemp
End Function
'------

The call would be something like:

strXYDataStream = strXYDataStream &
DrawCircle(Round(dblXCenterPoints + DataRS("X") * dblPointsPerUnit, 3),
Round(dblYCenterPoints + DataRS("Y") * dblPointsPerUnit, 3), 2, 0.1,
0.1, 0.1, 0.3, True, 1#, 0#, 0#)

Some of the information found for drawing PDF circles was from
www.tinaja.com. The black border for the circle is actually 0.1 0.1
0.1 instead of 0 0 0 so it's not quite fully black. A small circle in
the center of the Adobe Reader screen can be seen using the following
layout text in my PDFLayoutViewer:

q
0.3 w
1 0 0 rg
0.1 0.1 0.1 RG
308 396 m
308 397.1045695 307.1045695 398 306 398 c
304.8954305 398 304 397.1045695 304 396 c
304 394.8954305 304.8954305 394 306 394 c
307.1045695 394 308 394.8954305 308 396 c
b
S
Q

Huge circles should require more than four Bezier Curves in order to
display properly. I did some autoscaling with the histogram program so
doing that would not be difficult. I think the UI will be the hardest
part. Titles are easy. A light gray grid underneath would be pretty
easy to do. I can also let the user choose landscape or portrait
through toggle buttons on a form and changing one of the PDF functions
(AddPage) to accept a boolean:

If boolPortrait Then
strTemp = strTemp & " /MediaBox [0 0 612 792]" & strCR
strTemp = strTemp & " /CropBox [0 0 612 792]" & strCR
Else
strTemp = strTemp & " /MediaBox [0 0 792 612]" & strCR
strTemp = strTemp & " /CropBox [0 0 792 612]" & strCR
End If

This might bring some joy.

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

Jul 12 '06 #8
DFS
Lyle Fairfield wrote:
polite person wrote:
>I posted a reply to his scatter chart problem over 24 hours ago and
still he hasn't replied!

Sure, I do. He's fine ... a bit prickly and no respecter of
experience or old age (especially mine), but that's OK. He has a mind
and tries to use it. One can actually understand what he writes! More
often than not he's right.Those traits put him in the top 5% of
posters here.
Are you gabbing about me?

If so, that's [95%] nice of you to say. Wish I could hang out on cdma more,
but I'm swamped with work.

Jul 12 '06 #9
DFS
CD********@FortuneJames.com wrote:
I'll try to find time this week to work on a PDF scatter chart mdb.
Any requests for features DFS? I care.
It's so nice to find people who care... sniff sniff...

But seriously, no need to burn your time unless you can't help yourself. My
hand-coded scatter chart works well for my needs:

http://www.angelfire.com/planet/dfs0/Scatter.PNG

See that datasheet on the right? As you scroll it, the current month is
highlighted in red on the chart. Kewl!

Here's the positioning code (added some height/width kludges to deal with
the labels in the corners). I may work on autoscaling (would be easy), but
the data sets have pretty tight ranges.
'X-AXIS POSITION
XPos = ((rs("X") - 0.8) / 0.2) * (0.5 * frm.scatterBox.Width)
If XPos <= 0 Then
XPos = 10
ElseIf XPos frm.scatterBox.Width Then
XPos = frm.scatterBox.Width - 100
End If
frm("point" & i).Left = scatterLeft + XPos
'Y-AXIS POSITION
YPos = ((rs("Y") - 0.8) / 0.2) * (0.5 * frm.scatterBox.Height)
If YPos <= 0 Then
YPos = 10
ElseIf YPos frm.scatterBox.Height Then
YPos = frm.scatterBox.Height - 300
End If
frm("point" & i).Top = scatterBottom - YPos


I'm thinking about small red circles with a black border for that
points. PDF has to use Bezier Curves for circles so I'm thinking
along these lines:
<snip nice code>
Thanks for the offer.


Jul 12 '06 #10
DFS wrote:
CD********@FortuneJames.com wrote:
I'll try to find time this week to work on a PDF scatter chart mdb.
Any requests for features DFS? I care.

It's so nice to find people who care... sniff sniff...

But seriously, no need to burn your time unless you can't help yourself. My
hand-coded scatter chart works well for my needs:

http://www.angelfire.com/planet/dfs0/Scatter.PNG

See that datasheet on the right? As you scroll it, the current month is
highlighted in red on the chart. Kewl!

Here's the positioning code (added some height/width kludges to deal with
the labels in the corners). I may work on autoscaling (would be easy), but
the data sets have pretty tight ranges.
'X-AXIS POSITION
XPos = ((rs("X") - 0.8) / 0.2) * (0.5 * frm.scatterBox.Width)
If XPos <= 0 Then
XPos = 10
ElseIf XPos frm.scatterBox.Width Then
XPos = frm.scatterBox.Width - 100
End If
frm("point" & i).Left = scatterLeft + XPos
'Y-AXIS POSITION
YPos = ((rs("Y") - 0.8) / 0.2) * (0.5 * frm.scatterBox.Height)
If YPos <= 0 Then
YPos = 10
ElseIf YPos frm.scatterBox.Height Then
YPos = frm.scatterBox.Height - 300
End If
frm("point" & i).Top = scatterBottom - YPos


I'm thinking about small red circles with a black border for that
points. PDF has to use Bezier Curves for circles so I'm thinking
along these lines:

<snip nice code>
Thanks for the offer.
I think I need at least one person to request that I do the scatter
plot to justify spending time on it although it sounds fun. What you
have looks nice. I think the PDF output gives more flexibility
although being able to show a scrollable view of the data next to the
plot is very nice. I'd end up going into the graphics API to retain
the kind of flexibility I like in order to have that feature. The API
calls can handle the red month also, but I agree that it's a nice touch
either way. I'm glad it worked out for you.

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

Jul 13 '06 #11
I do
http://www.dfsonline.co.uk/

They're forever interrupting my TV programmes with their "we've got a sale
on" adverts.

I'm guessing the scatter chart is to work out which 5 days of the year they
haven't got a sale on.

--

Terry Kreft
"polite person" <sn**@snippers.comwrote in message
news:2a********************************@4ax.com...
I posted a reply to his scatter chart problem over 24 hours ago and still
he hasn't replied!
>

Jul 13 '06 #12
On Thu, 13 Jul 2006 12:23:08 +0100, "Terry Kreft" <te*********@mps.co.ukwrote:
>I do
http://www.dfsonline.co.uk/
Ha!

Jul 13 '06 #13

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

Similar topics

1
by: Market Mutant | last post by:
I don't care about money. I want the best board: low CPU/memory take. Low MySQl usage. I have heard that PHPBB is the worst if you know PHP and read the codes. So I pass on that one. Can...
15
by: Brandon J. Van Every | last post by:
Is anyone using Python for .NET? I mean Brian's version at Zope, which simply accesses .NET in a one-way fashion from Python. http://www.zope.org/Members/Brian/PythonNet Not the experimental...
37
by: Curt | last post by:
If this is the complete program (ie, the address of the const is never taken, only its value used) is it likely the compiler will allocate ram for constantA or constantB? Or simply substitute the...
162
by: Isaac Grover | last post by:
Hi everyone, Just out of curiosity I recently pointed one of my hand-typed pages at the W3 Validator, and my hand-typed code was just ripped to shreds. Then I pointed some major sites...
29
by: Vol | last post by:
I think 'atan' can get the angle but it is not the four quadrant angle. Is there any function that i can get the angle from -pi to pi? or I have to use some if ... else? I know in Matlab, we use...
11
by: cj | last post by:
Public Class MyStringLogger Private Shared m_loglock As New Object Public Shared Sub Write(ByVal str As String) SyncLock (m_loglock) Dim sw As New System.io.StreamWriter("c:\validate.log",...
14
by: Anoop | last post by:
Hi, I am new to this newsgroup and need help in the following questions. 1. I am workin' on a GUI application. Does C# provides Layout Managers the way Java does to design GUI? I know that it...
18
by: miller.paul.w | last post by:
Ruby has a neat little convenience when writing loops where you don't care about the loop index: you just do n.times do { ... some code ... } where n is an integer representing how many times you...
162
by: Sh4wn | last post by:
Hi, first, python is one of my fav languages, and i'll definitely keep developing with it. But, there's 1 one thing what I -really- miss: data hiding. I know member vars are private when you...
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...
1
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
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...
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.