Does anyone care about DFS? - Microsoft Access / VBA

polite person

I posted a reply to his scatter chart problem over 24 hours ago and still he hasn't replied!

Jul 12 '06 #1

Subscribe Reply

2456

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

Tim Marshall

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

Lyle Fairfield

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

polite person

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

Lyle Fairfield

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

CDMAPoster

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(ByVa l 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(dblFi llR) Or IsMissing(dblFi llG) Or IsMissing(dblFi llB)
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(dblLineWid th) & " 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(Roun d(dblXCenterPoi nts + DataRS("X") * dblPointsPerUni t, 3),
Round(dblYCente rPoints + DataRS("Y") * dblPointsPerUni t, 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********@Fort uneJames.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********@Fort uneJames.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

Similar topics

2662

Anyone knows a technical comparison of IPB and VB and UBB?

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 anyone who knows PHP inside out tell me the technical comparison of IPB and vB and UBB? Which one is the fastest? Which takes the least MySQL update? Which one can handle the largest BBS?

PHP

1706

Is anyone using Python for .NET?

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 ActiveState stuff, which tried to compile IL and apparently didn't succeed. Two motives for the question: 1) whether to use it for my C++ / C# / .NET / Python (?) game project. It's a prototype, so in this context a "mostly working beta" is...

Python

4680

Does this allocate memory?

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 values in (as would be required if I used the hideous, evil, much-abused #define :) ----------- const int constantA = 10; static const int constantB = 20;

C / C++

162

7297

Does anyone pay attention to standards?

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 (microsoft.com, cnn.com, etc.) at the W3 Validator; to my surprise none of them passed. Doesn't anyone care anymore, or are the standards more-or-less looked at as guidlines for web design?

HTML / CSS

3381

Does C have function to get angle?

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 'atan2( )' Also, is there any function to get the round value, similar with floor and ceil, such like: round(3.1) = 3 round(3.6) = 4

C / C++

1476

Does this look good?

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", True) sw.WriteLine(str) sw.Close() End SyncLock

Visual Basic .NET

4863

Does C#.Net support Layout managers?

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 can be done using the designer but I intentionally don't want to use that. The one reason is that you cannot change the code generated by the designer. The other could be that you have more free hand and control to design your GUI. 2....

C# / C Sharp

1458

Does anyone else use this little idiom?

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 want to execute "some code." In Python, the direct translation of this is a for loop. When the index doesn't matter to me, I tend to write it as: for _ in xrange (1,n): some code

Python

162

10298

Why does python not have a mechanism for data hiding?

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 prefix them with 2 underscores, but I hate prefixing my vars, I'd rather add a keyword before it. Python advertises himself as a full OOP language, but why does it miss one of the basic principles of OOP? Will it ever be added to python?

Python

9619

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10260

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10102

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10038

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8933

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7460

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5354

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5482

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2850

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General