 | |
#11
 
| |||
| |||
|
Re: BringToFront -
03-08-2011
, 05:04 PM
|
Batch 4 Private Sub Place01_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) * * CtlMouseDown CInt(Right(Screen.ActiveControl.Name, 2)), X, Y End Sub Private Sub Place01_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) * * If Button And acLeftButton Then * * * * CtlMouseMove CInt(Right(Screen.ActiveControl.Name, 2)), X, Y * * End If * * CtlMouseUp CInt(Right(Screen.ActiveControl.Name, 2)) End Sub There is a lot of other stuff about setting the angle of the control and fitting the control to the data (fTextWidth routine) My main problem, and that is why I will have to abandone the project is that Stephen's ActiveX control does not support the BackStyle property, which I need to be transparent. If I have 2 spaces with the tecxt at 45 degrees, there are 2 squares, each about one and 1 half inches overlapping each other and the corner of one square obscures the text in the other square. I desparately need someone who can add the additional property to Stephen's ActiveX control, I have the source code, but no idea wher to begin. Suspect that being well into my 70's it's getting a bit late to start learning VB Anything more, please come back. Incidently, very successfully, I have used a similar system for planing the seating arangement for our formal dining events, where I drag the dining tables around, alter their sizes and all the chairs move along with the tables and the right number of chairs appear depending on the length of the table (and how tightly we sppace the seats) Phil |
You are correct about the created PDF being non-interactive, not that
that can't be done. I don't think you're going to like my advice.
What you are trying to do came up for me when a customer wanted to use
software for "what if" scenarios for placing pool tables within his
establishment. While looking for a good way to do that, I viewed one
of the PDC 05 sessions about GDI+. I even had a dream that night
about creating objects on a "canvas" by using mouse clicks. I went
out an purchased the following book:
GDI+ Programming in C# and VB.NET
APress 2002
Nick Symmonds
ISBN 1-59059-035-X
Note: I got it quite inexpensively, used on Amazon.
Later I got another GDI+ book:
Graphics Programming with GDI+
Addison-Wesley 2004
Mahesh Chand
ISBN 0-321-16077-0
and
Pro .NET 2.0 Graphics Programming
Building Custom Controls using GDI+
APress 2006
Eric White
ISBN 1-59059-445-2
Instead of jury-rigging an Access form, an interesting use BTW, I
think you will find it more productive to work with WPF, GDI+ and
managed code such as C# or VB.NET. Exporting the results to Excel is
still an option, but you are already taking Access' role a bit over
the top IMO. It might be nice later to gentrify Access with such .NET
possibilities, but Access doesn't seem to be the right tool at
present. I'm not saying that you can't get Access to do it somehow,
I'm just recommending doing it without using Access. You're never too
old to learn :-).
James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com
#12
| |||
| |||
|
|
On Mar 7, 6:36*pm, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote: Batch 4 Private Sub Place01_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) * * CtlMouseDown CInt(Right(Screen.ActiveControl.Name, 2)), X, Y End Sub Private Sub Place01_MouseUp(Button As Integer, Shift As Integer, X As Sin gle, Y As Single) * * If Button And acLeftButton Then * * * * CtlMouseMove CInt(Right(Screen.ActiveControl.Name, 2)), X , Y * * End If * * CtlMouseUp CInt(Right(Screen.ActiveControl.Name, 2)) End Sub There is a lot of other stuff about setting the angle of the control and fitting the control to the data (fTextWidth routine) My main problem, and that is why I will have to abandone the project is t hat Stephen's ActiveX control does not support the BackStyle property, which I need to be transparent. If I have 2 spaces with the tecxt at 45 degrees, there are 2 squares, each about one and 1 half inches overlapping each ot her and the corner of one square obscures the text in the other square. I desparately need someone who can add the additional property to Stephen's ActiveX control, I have the source code, but no idea wher to begin. Suspe ct that being well into my 70's it's getting a bit late to start learning VB Anything more, please come back. Incidently, very successfully, I have used a similar system for planing t he seating arangement for our formal dining events, where I drag the dining tables around, alter their sizes and all the chairs move along with the tables and the right number of chairs appear depending on the length of t he table (and how tightly we sppace the seats) Phil Phil, You are correct about the created PDF being non-interactive, not that that can't be done. I don't think you're going to like my advice. What you are trying to do came up for me when a customer wanted to use software for "what if" scenarios for placing pool tables within his establishment. While looking for a good way to do that, I viewed one of the PDC 05 sessions about GDI+. I even had a dream that night about creating objects on a "canvas" by using mouse clicks. I went out an purchased the following book: GDI+ Programming in C# and VB.NET APress 2002 Nick Symmonds ISBN 1-59059-035-X Note: I got it quite inexpensively, used on Amazon. Later I got another GDI+ book: Graphics Programming with GDI+ Addison-Wesley 2004 Mahesh Chand ISBN 0-321-16077-0 and Pro .NET 2.0 Graphics Programming Building Custom Controls using GDI+ APress 2006 Eric White ISBN 1-59059-445-2 Instead of jury-rigging an Access form, an interesting use BTW, I think you will find it more productive to work with WPF, GDI+ and managed code such as C# or VB.NET. Exporting the results to Excel is still an option, but you are already taking Access' role a bit over the top IMO. It might be nice later to gentrify Access with such .NET possibilities, but Access doesn't seem to be the right tool at present. I'm not saying that you can't get Access to do it somehow, I'm just recommending doing it without using Access. You're never too old to learn :-). James A. Fortune CDMAPoster (AT) FortuneJames (DOT) com |
It's so frustrating that everything is working perfectly other than the fact
that I can't set the ActiveX box BackStyle to being transparent. What I need
is somepne who understands VB to play with the ActiveX. I have what I believe
is the source, but haven't the foggiest to know where to start. Stephen
created his control 12 years ago. I have downloaded VB 2008, and it seems to
throw so many Upgrade issues.
Any volunteers?
Phil
#13
| |||
| |||
|
|
I am involved with a yacht club and we need a diagram of the space number where each boat is parked and who owns the boat. |
(pick space you want to move) and then "desired new diagram" that
would allow the user to click on the destination spot. While it's
not nearly as spiffy an interface as drag-and-drop, it's an order of
magnitude easier to program.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
#14
| |||
| |||
|
|
"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in news:il3orn$pe8$1 (AT) speranza (DOT) aioe.org: I am involved with a yacht club and we need a diagram of the space number where each boat is parked and who owns the boat. I think I'd avoid the whole issue and just present "current diagram" (pick space you want to move) and then "desired new diagram" that would allow the user to click on the destination spot. While it's not nearly as spiffy an interface as drag-and-drop, it's an order of magnitude easier to program. |
It's sooo close, other than finding out what program I have to learn to
modify Stephens Rotate Text AcliveX. Other than the transparancy issue with
the rotated control, it's there. Any idea what you use to create an OCX? The
source appears to be some form of basic. Don't think it is n C++
Phil
#15
| |||
| |||
|
|
On 09/03/2011 18:22:45, "David-W-Fenton" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in news:il3orn$pe8$1 (AT) speranza (DOT) aioe.org: I am involved with a yacht club and we need a diagram of the space number where each boat is parked and who owns the boat. I think I'd avoid the whole issue and just present "current diagram" (pick space you want to move) and then "desired new diagram" that would allow the user to click on the destination spot. While it's not nearly as spiffy an interface as drag-and-drop, it's an order of magnitude easier to program. David - where's your sense of adventure? It's sooo close, other than finding out what program I have to learn to modify Stephens Rotate Text AcliveX. Other than the transparancy issue with the rotated control, it's there. Any idea what you use to create an OCX? The source appears to be some form of basic. Don't think it is n C++ It's probably VB5 or VB6, neither of which you are going to be able to use |
#16
| |||
| |||
|
|
On 09/03/2011 18:22:45, "David-W-Fenton" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in news:il3orn$pe8$1 (AT) speranza (DOT) aioe.org: I am involved with a yacht club and we need a diagram of the space number where each boat is parked and who owns the boat. I think I'd avoid the whole issue and just present "current diagram" (pick space you want to move) and then "desired new diagram" that would allow the user to click on the destination spot. While it's not nearly as spiffy an interface as drag-and-drop, it's an order of magnitude easier to program. David - where's your sense of adventure? It's sooo close, other than finding out what program I have to learn to modify Stephens Rotate Text AcliveX. Other than the transparancy issue with the rotated control, it's there. Any idea what you use to create an OCX? The source appears to be some form of basic. Don't think it is n C++ |
I've been there and done that, and it's just too much of a problem.
And it's only getting worse with the move to 64-bit Windows and all
the issues with different versions of the OCX's and such.
Basically, since I can't use OCX's (or any ActiveX control) with any
form of late binding, I just won't use it at all unless forced to do
so.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
#17
| |||
| |||
|
|
On 09/03/2011 18:22:45, "David-W-Fenton" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in news:il3orn$pe8$1 (AT) speranza (DOT) aioe.org: I am involved with a yacht club and we need a diagram of the space number where each boat is parked and who owns the boat. I think I'd avoid the whole issue and just present "current diagram" (pick space you want to move) and then "desired new diagram" that would allow the user to click on the destination spot. While it's not nearly as spiffy an interface as drag-and-drop, it's an order of magnitude easier to program. David - where's your sense of adventure? It's sooo close, other than finding out what program I have to learn to modify Stephens Rotate Text AcliveX. Other than the transparancy issue with the rotated control, it's there. Any idea what you use to create an OCX? The source appears to be some form of basic. Don't think it is n C++ |
you can make is to try to make your tools work in a way different
from what they were intended. I didn't like the Paradox WAIT TABLE
approach, nor the default keyboard commands. So I wrote all sorts of
code to try to do the same things and remap the keyboard to
something that made sense. The end result was a complete mess that
never really worked well. Had I just used Paradox the way it was
designed, I would have saved all that time writing all that code and
would have had a working app much sooner (and one that was much more
reliable, in fact).
To me, you're trying to engineer something that Access was never
intended to do, and you're investing a huge amount of time in
something that may never work -- the problem you're encountering
right now may be completely insurmountable (I don't know if it is or
not, but NEITHER DO YOU!). To me, that's a sign that you're either
mis-using your tools or you're using the wrong tools entirely. You
can either switch to something else, or change the way you use your
tools.
I vote for the latter.
Also, you're fixated on a particular solution to the problem,
instead of on solving the problem by whatever method is easiest to
do so. This is something I hate with clients, who tell me HOW they
want something done instead of just telling me what the problem is
that needs to be solved and letting me design the solution.
--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
#18
| |||
| |||
|
|
"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in news:il8lg2$dak$1 (AT) speranza (DOT) aioe.org: On 09/03/2011 18:22:45, "David-W-Fenton" wrote: "Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in news:il3orn$pe8$1 (AT) speranza (DOT) aioe.org: I am involved with a yacht club and we need a diagram of the space number where each boat is parked and who owns the boat. I think I'd avoid the whole issue and just present "current diagram" (pick space you want to move) and then "desired new diagram" that would allow the user to click on the destination spot. While it's not nearly as spiffy an interface as drag-and-drop, it's an order of magnitude easier to program. David - where's your sense of adventure? It's sooo close, other than finding out what program I have to learn to modify Stephens Rotate Text AcliveX. Other than the transparancy issue with the rotated control, it's there. Any idea what you use to create an OCX? The source appears to be some form of basic. Don't think it is n C++ Also, I learned in my Paradox days that one of the biggest mistakes you can make is to try to make your tools work in a way different from what they were intended. I didn't like the Paradox WAIT TABLE approach, nor the default keyboard commands. So I wrote all sorts of code to try to do the same things and remap the keyboard to something that made sense. The end result was a complete mess that never really worked well. Had I just used Paradox the way it was designed, I would have saved all that time writing all that code and would have had a working app much sooner (and one that was much more reliable, in fact). To me, you're trying to engineer something that Access was never intended to do, and you're investing a huge amount of time in something that may never work -- the problem you're encountering right now may be completely insurmountable (I don't know if it is or not, but NEITHER DO YOU!). To me, that's a sign that you're either mis-using your tools or you're using the wrong tools entirely. You can either switch to something else, or change the way you use your tools. I vote for the latter. Also, you're fixated on a particular solution to the problem, instead of on solving the problem by whatever method is easiest to do so. This is something I hate with clients, who tell me HOW they want something done instead of just telling me what the problem is that needs to be solved and letting me design the solution. |
Access tools ... but.... All I want is a straightforward TextBox or Label
with all the normal properties of an Access Textbox or Label + the additional
one of the ability to rotate it together with the text. Everything works in
that I can drag the controls around, position them and rotate them other than
the OCX I am using doesn't have the ability to set the BackStyle to
Transparent so the "empty" corner of one box can obscure the text in the box
it is overlapping. Stephen's Rotate Text control is also missing properties
like DoubleClick, but I can live without that. I'm not disputing that this is
an unusual use of Access, but havind designed a pretty comrehensive database
that fulfils pretty well all our requirements, it goes against the grain to
have to export to Excel to get rotated labels, then import the GIF file that
Excel generates back into Access to see the results.
Phil
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.