Stephen Lebans - PositionFormRelativeToControl module

[Guest]

I would like to know if there is a way to open an app --- I use: Call
Shell("calc.exe", 1)-- but be able to place the Calculator form on my screen
relevant to a control on my Access form. I use Stephen Lebans module and it
works excellent with Access forms! Is there a way to accomplish the same
thing with a non-Access form like the Calculator??
Thanks

 

[Stephen Lebans]

Look at how I do it in my MonthCalendar class. Once you find the relevant
code you can just copy and paste.
The Window's Calculator Class name is:
SciCalc

The Window Title/Caption is "Calculator" in English versions of Windows.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Stephen,
Thanks for the reply, however, I am not able to understand the code in your
MonthCalendar class...(too complicated for me!) Could you tell me
specifically what code I need to use? I want to position the Calculator
relative to one of the controls on my form.
I appreciate the help.
Thanks, Joey

 

[Douglas J. Steele]

No offense, but I think you're expecting a little too much! Stephen's busy
building absolutely incredible utilities for others.

Look in his code for FindWindow, which is how you find a particular window
in code.

 

[Guest]

sorry for asking for help

 

[Guest]

I thought the whole idea here was to help and learn from each other. And,
you, an MVP scolding someone for asking questions and looking for help.
Consider that someone else may not have your "expertise" and level of
understanding.
tsk, tsk, tsk
Not very nice, Douglas.

 

[Stephen Lebans]

Douglas is only responding on my behalf. I've told him I am currently on
vacation and in the middle of constructing a new home, which leaves very
little time for these NG's..

I responded to Joey's initial request for help, pointing to an existing
solution containing the required code. The OP has now replied that the code
is too complicated for him to understand. This is quite understandable a GDI
API solution is required.
The OP now needs to find someone to produce a complete custom solution. I'm
not willing to do that at this time but perhaps someone else in these NG's,
you for instance, would be willing to help out. On a side note, Access has
several redraw/repaint issues when you try to integrate a third party window
into the Access GUI.

To Joey:
If I remember correctly, several years ago, Pedro Gil once posted a solution
very similiar to what you are looking for. A search of the GoogleGroups NG
Archives should yield the relevant thread. But really Joey, there are
several fully functional Calculators, based entirely on standard Access
forms, that you could easily integrate into your project within a couple of
minutes.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

I don't think that Stephen would participate in these message boards if he's
TOO "busy building absolutely incredible utilities for others". Yes, he does
build incredible programs but he has always been available to help others and
answer our questions. As a matter of fact, I was on "thescripts.com" forum
and read several posts where he spent time answering questions about his
MonthCalendar application. Busy, but maybe not TOO busy to help others. Is
it true, Stephen?
By the way, do you know the answer to the question posed? If you do, good,
why not help another person along in their learning process. If not, don't
trash someone else for asking a question.

 

[Guest]

I was not aware of other "Calculator" apps made in Access that I could
integrate.....that sounds like one solution. Could you tell me where I might
find such an form. I don't want to spend the time to re-create this from
scratch. Thanks.

 

[Stephen Lebans]

Joey you need to learn how to search GoogleGroups:
http://groups.google.ca/groups?as_q=calendar+form&num=30&scoring=r&hl=en


Jeff Conrad has a great list of Access Calculators here:
http://home.bendbroadband.com/conradsystems/accessjunkie/calculator.html

Terry Kreft has one here:
http://www.mvps.org/access/downloads/calc.zip

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

yes, I do have a lot to learn. In the past, I've always come to this
newsgroup because the users here always seem to do their best to answer your
questions and help you if they can. For someone like me, that's one of the
best ways for me to learn. I thought that's the reason "experts" like you
hang around in these groups....to help the rest of us LEARN! Yes, you are a
very talented progrmmer and people here would have appreciated your
willingness to provide help and advice. I would have appreciated it also.
But your lack of patience and the way you talk down to me has made me change
my mind about you, the MVP's here, and this group. I won't be coming back
here. I hope you feel really proud of yourself for kicking someone around for
asking questions.

 

[Guest]

Real nice. Professional.
Pretty impressive the way you two handled that.
But really, Thanks for the help.
Hope I never need that kind of "help" :-(

 

[Terry Kreft]

Ah, right, not only are you privy to Stephens calendar you also get to
decide what is a reasonable level of workload for him.

Oh and you get to decide what Doug should be doing with his time as well,
you are a busy little beaver aren't you.

Instead of harassing those who are willing to help people (in their own time
using their years of expertise and strangely enough on their own terms) why
not do a bit yourself, or even better, why not look to see if, as in this
case, the OP is being unreasonable in their demands and support the people
who actually do help.

 

[Terry Kreft]

Doug is pointing out that the OP is being unreasonable (which he is).

If it bothers you that much why not try helping the OP yourself, but whoops
no that would involve doing something positive instead of having a dig at
someone who actually does help people in here.

Oh and looking at Dougs post what do I find, he actually does point the OP
in the right direction, unlike you.

 

[Terry Kreft]

Your gall is beyond belief. The people who reply to questions in here are
not here to spoon feed you.

Try getting a sense of perspective about the scope of what you are asking
people to do and understand that there are occasions where the help you
expect slips over the bounds of what is reasonable to expect in this sort of
forum.

If you can't treat the people you are asking for help with respect why on
earth should you expect them to help you or indeed offer you any respect.
In this case despite your arrogant attitude both Doug and Stephen offered
you more help and respect than you deserve.

 

[Guest]

Since when is it *unreasonable* to ask a questin in this group? Any question
deserves a fair reply -- not arrogant snotty ones like what was given here.
If you felt it was beyond what you were willing to help with, then you might
try saying so NICELY!

 

[Guest]

I'm sorry that you feel that the question I asked was unreasonable. I thought
I was simply asking Stephen to point out the relevent code in his
MonthCalendar program. I surely didn't think it was a huge expenditure of
time and energy. Obviously I was wrong. I humbly apologize.
Sean, I appreciate the support , but hopefully I will be forgiven and we can
all just get back to work now.
Again, I am sorry for asking a totally unreasonable question.
I will certainly think twice before posting again.

 

[Terry Kreft]

If you don't like the help that Stephen and Doug provide then why not spend
8 or 10 years in the NGs developing the expertise in helping others that
these two people have. Then you can provide a level of help which matches
your expectations.

Of course it's much more likely that by then you'll have moved on to
something else or possibly developed a sense of when some one is either
trying to do something which is beyond them or trying to get people to offer
the kind of "help" which is beyond that which can reasonably be expected in
a newsgroup.

 

[Terry Kreft]

It is unreasonable to ask an unreasonable question. Unreasonable questions
include, but are not restricted to, ones which would require an unreasonable
amount of effort on the part of the responder to respond

Any question deserves a fair reply? Don't be infantile.

The answers given by Stephen and Doug were not arrogant or "snotty", I think
you need to hang out in some of the really nasty NGs a bit to see just how
quiet and civilised this one is.

Doug tried to put the OP off by pointing out that Stephen was busy, Stephen
then chimed in with details of what he is actually embroiled in at the
moment, now that went way beyond the level of politeness the OP or anybody
should have expected. Personally my response would have been along the
lines of "there's a reason why I haven't responded and it's none of your
business what it is", but Stephen chose to reveal something of his personal
life in order to try and deflect criticsm.

I must say your last sentence is very interesting as you chose to neither
answer the OP nor answer nicely, instead you chose to carry out an
unwarranted attack on two of the most prolific and knowledgeable posters in
this NG. Well done hypocrisy.

 

[Terry Kreft]

Joey,
There are a lot of resources out there which you can try first before
posting.

One of the best resources is http://www.mvps.org/access which has a page at
http://www.mvps.org/access/netiquette.htm which has a section entitled
Searching for an answer to a problem? which is worth reading.