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
8  2018 
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@fed1r ead06... 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
"Stephen Lebans" <Fo************ *************** *************@l invalid.com>
wrote in message news:n6******** *************@u rsa-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.
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@fed1r ead06... "Stephen Lebans"
<Fo************ *************** *************@l invalid.com> wrote in message
news:n6******** *************@u rsa-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.
"Stephen Lebans" <Fo************ *************** *************@l invalid.com>
wrote in message news:_I******** *************@u rsa-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?
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************ *************** *************@l invalid.com>
wrote in message news:_I******** *************@u rsa-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?
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.spa m.cox.net> wrote in message
news:ia******** *************** *********@4ax.c om... 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************ *************** *************@l invalid.com>wrote in message
news:_I******** *************@u rsa-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?
On Mon, 24 Nov 2003 17:25:23 GMT, "Stephen Lebans"
<Fo************ *************** *************@l invalid.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.
Tom van Stiphout <to*****@no.spa m.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bruce Rusk |
last post by:
I'm using Stephen Lebans' RTF2 control in a report, and have discovered what
may be a slight bug in it.
I have a lot of non-Western language (Chinese) text in my RTF field, and
such records get sized strangely using the .RTFHeight property of the
control. Specifically, lines of text get cut off the bottom of the control
when I use the code provided in the sample report on the lebans.com site. It
seems that when there is Chinese text,...
|
by: Tim Graichen |
last post by:
Hello,
I am making use of the Active X calendar control (mscal.Calendar.7) in
several places in my main form, with the following code
Below is an example of the code I'm using for the controls.
Private Sub DateSold_MouseDown(Button As Integer, Shift As Integer, X As
Single, Y As Single)
SoldCal.Visible = True
|
by: Larry R Harrison Jr |
last post by:
I use the Lebans calendar control and love it; the only thing is that it
commonly starts out at the year 1899 rather than the current year. Is there
a way to specifically tell it to start at the current date instead?
Note: it does this fine if I'm using it in the context of a form's text box,
but I'm trying to use it on a module which is called, whereby the date
chosen is the date plugged into a variable. Everytime after I reset the...
|
by: Robert |
last post by:
Hello.
I have been trying out the Lebans ToolTip Classes at
http://www.lebans.com/tooltip.htm, to display "balloon" style help tips in a
form. The classes I am using are located at
http://www.lebans.com/DownloadFiles/A2kTooltip.zip
So far the classes work perfectly, except that now I need to extend it to
support other controls besides the ones given in the example form. I have
gotten it to work with some controls, but not others. I...
|
by: Mason |
last post by:
I have a quick, probably easy, question about Lebans' calendar
program.
I have a form that allows a user to click on different technicians.
When this happens, Lebans' calendar comes up with various dates set to
bold based on the technician selected. However, when I close the
calendar and select a different technician, the bold dates carry over
from the previous technician selected.
I can't find a way to clear the bold days after the...
| | |
by: Michael Gramelspacher |
last post by:
I am using Lebans's calendar with Access 97 running on
Windows 95, and Access 2000 on a different machine also
running Windows 95. I had been using an earlier version of
the calendar without problem. Now I switched to version
2.01. The only problem is that is will not honor the
setting to open where last dragged. Same with both
databases. Since the sample files behave properly, the code
compiles and there are no reference problems, I...
|
by: Andrew Chanter |
last post by:
I recently installed Stephan Lebans calendar control into an application.
Only problem is that it always launches at the extreme right of the screen
with most of the dialog off screen. I am activating it with a command
button next to the field I want to update. Dont know if this is the issue.
Any clues??
|
by: DFS |
last post by:
If you're listening, I want the middle of the calendar (showing 1 month) to
open below the cursor position. It currently opens just to the right and
below the cursor position.
I hunted through the code, but can't determine what to alter.
Very nice piece of work, by the way.
Thanks
|
by: CuriousOne1 |
last post by:
Hi all,
I don't know if anyone has come accross this before. I've been using Steve Lebans Calendar control (available here: www.lebans.com/monthcalendar.htm ) for several database application I've built.
I only noticed recently, that after I've selected a date range, by highlighting the desired date, e.g. from 1 August 2007 to 7 August 2007, if I then use the navigation buttons to scroll from month to month, the same number of days is...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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...
|
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,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
