By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,483 Members | 3,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,483 IT Pros & Developers. It's quick & easy.

Lebans Calendar Control Sometimes Locks Up Form

P: n/a
Sometime, if an error has occured or even if a user has answered NO to a
MsgBox Y/N question, the Lebans calendar control will prevent the form from
closing.

I know the Lebans calendar control is excellent--I have not once used the
Active X Calendar Control since discovering it--but this is an error that I
need to fix. I am supposing it's something in the form's UNLOAD procedure
which would have to be tweaked.

Tips?
LRH
Nov 12 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Need more specifics of this issue in order to debug.
WHen is the MsgBox appearing, beofre the Calendar is popped or after?
What version of Access and WIndows.
I need the exact steps you take so I can duplicate it here.

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Larry R Harrison Jr" <la*******@cox.net> wrote in message
news:5pbwb.6718$9O5.3197@fed1read06...
Sometime, if an error has occured or even if a user has answered NO to a MsgBox Y/N question, the Lebans calendar control will prevent the form from closing.

I know the Lebans calendar control is excellent--I have not once used the Active X Calendar Control since discovering it--but this is an error that I need to fix. I am supposing it's something in the form's UNLOAD procedure which would have to be tweaked.

Tips?
LRH


Nov 12 '05 #2

P: n/a
"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:n6*********************@ursa-nb00s0.nbnet.nb.ca...
Need more specifics of this issue in order to debug.
WHen is the MsgBox appearing, beofre the Calendar is popped or after?
What version of Access and WIndows.
I need the exact steps you take so I can duplicate it here.

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks


It is Access 97. And I found out what does it, the END statement.

Code which executes an END statement does this, but if I assign 99 to the
END SUB so it says 99 End Sub, and then rather than issuing an END command I
issue a GoTo 99 command, that solves it.
Nov 12 '05 #3

P: n/a
I'm sure in the DOCS/Comments for my code I state emphatically that you
MUST NOT issue an END statement. YOu simply cannot do this for any
solution that subclasses using inline code...PERIOD! TO do otherwise is
blatantly wrong, and nothing personal, but very stupid. Why would you
ever need to issue an END statement within your own code? How can you
expect to cleanup after yourself and allow Access to terminate
gracefully/properly if you abort in this fashion?

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Larry R Harrison Jr" <la*******@cox.net> wrote in message
news:DScwb.6895$9O5.4760@fed1read06...
"Stephen Lebans" <Fo****************************************@linval id.com> wrote in message news:n6*********************@ursa-nb00s0.nbnet.nb.ca...
Need more specifics of this issue in order to debug.
WHen is the MsgBox appearing, beofre the Calendar is popped or after? What version of Access and WIndows.
I need the exact steps you take so I can duplicate it here.

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks


It is Access 97. And I found out what does it, the END statement.

Code which executes an END statement does this, but if I assign 99 to

the END SUB so it says 99 End Sub, and then rather than issuing an END command I issue a GoTo 99 command, that solves it.


Nov 12 '05 #4

P: n/a

"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:_I*********************@ursa-nb00s0.nbnet.nb.ca...
I'm sure in the DOCS/Comments for my code I state emphatically that you
MUST NOT issue an END statement. YOu simply cannot do this for any
solution that subclasses using inline code...PERIOD! TO do otherwise is
blatantly wrong, and nothing personal, but very stupid. Why would you
ever need to issue an END statement within your own code? How can you
expect to cleanup after yourself and allow Access to terminate
gracefully/properly if you abort in this fashion?

I'm sure you did. The reason the code would need to be ended is because
there is a point for the user is prompted Y/N if they wish to perform the
operation, if they answer no then obviously the code must be exited.

Again rather than using END I assigned a number line (label I guess) to the
End Sub portion of the code and I use a GoTo statement to redirect the
execution to that line. That worked for me.

Would you handle it some other way?
Nov 12 '05 #5

P: n/a
On Mon, 24 Nov 2003 06:46:45 -0700, "Larry R Harrison Jr"
<la*******@cox.net> wrote:

Larry,
You are among programmers. You have to be VERY precise with your
language. The "END" instruction is very different from the "END SUB"
instruction. When you make slips-of-the-pen like this, you may get a
reaction of "Sigh" and "Plonk".

I would suggest you post the relevant block of code, stripped down to
its essentials.

-Tom.


"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:_I*********************@ursa-nb00s0.nbnet.nb.ca...
I'm sure in the DOCS/Comments for my code I state emphatically that you
MUST NOT issue an END statement. YOu simply cannot do this for any
solution that subclasses using inline code...PERIOD! TO do otherwise is
blatantly wrong, and nothing personal, but very stupid. Why would you
ever need to issue an END statement within your own code? How can you
expect to cleanup after yourself and allow Access to terminate
gracefully/properly if you abort in this fashion?

I'm sure you did. The reason the code would need to be ended is because
there is a point for the user is prompted Y/N if they wish to perform the
operation, if they answer no then obviously the code must be exited.

Again rather than using END I assigned a number line (label I guess) to the
End Sub portion of the code and I use a GoTo statement to redirect the
execution to that line. That worked for me.

Would you handle it some other way?


Nov 12 '05 #6

P: n/a
Well said Tom.
Post the relevant code Larry. Perhaps we simply have a misundertanding
on the use of the End vs End Sub/Function Statements and their is an
actual bug I can resolve.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:ia********************************@4ax.com...
On Mon, 24 Nov 2003 06:46:45 -0700, "Larry R Harrison Jr"
<la*******@cox.net> wrote:

Larry,
You are among programmers. You have to be VERY precise with your
language. The "END" instruction is very different from the "END SUB"
instruction. When you make slips-of-the-pen like this, you may get a
reaction of "Sigh" and "Plonk".

I would suggest you post the relevant block of code, stripped down to
its essentials.

-Tom.


"Stephen Lebans" <Fo****************************************@linval id.com>
wrote in message news:_I*********************@ursa-nb00s0.nbnet.nb.ca...
I'm sure in the DOCS/Comments for my code I state emphatically that you MUST NOT issue an END statement. YOu simply cannot do this for any
solution that subclasses using inline code...PERIOD! TO do otherwise is blatantly wrong, and nothing personal, but very stupid. Why would you ever need to issue an END statement within your own code? How can you expect to cleanup after yourself and allow Access to terminate
gracefully/properly if you abort in this fashion?

I'm sure you did. The reason the code would need to be ended is

becausethere is a point for the user is prompted Y/N if they wish to perform theoperation, if they answer no then obviously the code must be exited.

Again rather than using END I assigned a number line (label I guess) to theEnd Sub portion of the code and I use a GoTo statement to redirect theexecution to that line. That worked for me.

Would you handle it some other way?


Nov 12 '05 #7

P: n/a
On Mon, 24 Nov 2003 17:25:23 GMT, "Stephen Lebans"
<Fo****************************************@linval id.com> wrote:
Well said Tom.
Post the relevant code Larry. Perhaps we simply have a misundertanding
on the use of the End vs End Sub/Function Statements and their is an
actual bug I can resolve.


In almost all cases, I always use "Exit Sub" if the user's answer to a
continue prompt is "no". It works just fine.
Nov 12 '05 #8

P: n/a
Tom van Stiphout <to*****@no.spam.cox.net> wrote in message news:<ia********************************@4ax.com>. ..
On Mon, 24 Nov 2003 06:46:45 -0700, "Larry R Harrison Jr"
<la*******@cox.net> wrote:

Larry,
You are among programmers. You have to be VERY precise with your
language. The "END" instruction is very different from the "END SUB"
instruction. When you make slips-of-the-pen like this, you may get a
reaction of "Sigh" and "Plonk".

I would suggest you post the relevant block of code, stripped down to
its essentials.

-Tom.


Again the code prompts the user using a MsgBox statement and if they
answer No then the code needs to terminate. I was terminating using an
{End} statement but this screws up the calendar control. I therefore
issued a {GoTo 99} statement, with the End Sub statement being renamed
{99 End Sub}.

Would you do it some other way?

LRH
Nov 12 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.