I am using Access 2003, and have an ongoing problem of every once in a while
losing an event procedure
for a form or control. The procedure's still in the code module, but the
form or control's property sheet does not show "[Event Procedure]". I have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least, how to
tell if there are any of these "detached" event procedures? It's extremely
disconcerting to not have a procedure run that you assume is in place simply
because "[Event Procedure]" is missing from the property sheet. Is there a
way to tell if there are any of these in the db?
Thanks!
Neil
16  3583 
Neil wrote:
I am using Access 2003, and have an ongoing problem of every once in
a while losing an event procedure
for a form or control. The procedure's still in the code module, but
the form or control's property sheet does not show "[Event
Procedure]". I have to manually put it back, and then everything's
fine.
Does anyone know what causes this phenomenon, or, at the very least,
how to tell if there are any of these "detached" event procedures?
It's extremely disconcerting to not have a procedure run that you
assume is in place simply because "[Event Procedure]" is missing from
the property sheet. Is there a way to tell if there are any of these
in the db?
Thanks!
Neil
If you rename the control or cut and paste the control you lose that setting. I
have never encountered anything else that caused it.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Rick's given you the "when". For how to correct the problem, take a look at
my March, 2004 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at http://www.accessmvp.com/DJSteele/SmartAccess.html
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no private e-mails, please)
"Neil" <no****@nospam. netwrote in message
news:u2******** ******@newssvr2 2.news.prodigy. net...
>I am using Access 2003, and have an ongoing problem of every once in a
while losing an event procedure
for a form or control. The procedure's still in the code module, but the
form or control's property sheet does not show "[Event Procedure]". I have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least, how
to
tell if there are any of these "detached" event procedures? It's extremely
disconcerting to not have a procedure run that you assume is in place
simply
because "[Event Procedure]" is missing from the property sheet. Is there a
way to tell if there are any of these in the db?
Thanks!
Neil
in the on open event,
put something like:
Me.OnTimer = "[Event Procedure]"
this is possible if the on open does not loose it's "[Event
Procedure]". if you want to check that, then you must write a code and
put it in the startup of your database to check and see if all desired
forms have the "[Event Procedure]" in their on open event.
On Apr 15, 10:09 pm, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .comwrote:
Rick's given you the "when". For how to correct the problem, take a look at
my March, 2004 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free athttp://www.accessmvp.c om/DJSteele/SmartAccess.htm l
--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)
"Neil" <nos...@nospam. netwrote in message
news:u2******** ******@newssvr2 2.news.prodigy. net...
I am using Access 2003, and have an ongoing problem of every once in a
while losing an event procedure
for a form or control. The procedure's still in the code module, but the
form or control's property sheet does not show "[Event Procedure]". I have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least, how
to
tell if there are any of these "detached" event procedures? It's extremely
disconcerting to not have a procedure run that you assume is in place
simply
because "[Event Procedure]" is missing from the property sheet. Is there a
way to tell if there are any of these in the db?
Thanks!
Neil
Did you bother checking the reference I gave? It automates the process
you're describing.
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no private e-mails, please)
"Naeem Azizian" <na**********@g mail.comwrote in message
news:11******** **************@ p77g2000hsh.goo glegroups.com.. .
in the on open event,
put something like:
Me.OnTimer = "[Event Procedure]"
this is possible if the on open does not loose it's "[Event
Procedure]". if you want to check that, then you must write a code and
put it in the startup of your database to check and see if all desired
forms have the "[Event Procedure]" in their on open event.
On Apr 15, 10:09 pm, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .comwrote:
>Rick's given you the "when". For how to correct the problem, take a look
at
my March, 2004 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free
athttp://www.accessmvp.c om/DJSteele/SmartAccess.htm l
--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)
"Neil" <nos...@nospam. netwrote in message
news:u2******* *******@newssvr 22.news.prodigy .net...
>I am using Access 2003, and have an ongoing problem of every once in a
while losing an event procedure
for a form or control. The procedure's still in the code module, but
the
form or control's property sheet does not show "[Event Procedure]". I
have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least,
how
to
tell if there are any of these "detached" event procedures? It's
extremely
disconcerting to not have a procedure run that you assume is in place
simply
because "[Event Procedure]" is missing from the property sheet. Is
there a
way to tell if there are any of these in the db?
Thanks!
Neil
The problem with that is that I'd then have to put that code in the on open
event for each form for every form, control, and section event procedure.
That could get in the hundreds, and managing that would be a pain. Thanks,
though.
"Naeem Azizian" <na**********@g mail.comwrote in message
news:11******** **************@ p77g2000hsh.goo glegroups.com.. .
in the on open event,
put something like:
Me.OnTimer = "[Event Procedure]"
this is possible if the on open does not loose it's "[Event
Procedure]". if you want to check that, then you must write a code and
put it in the startup of your database to check and see if all desired
forms have the "[Event Procedure]" in their on open event.
On Apr 15, 10:09 pm, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .comwrote:
>Rick's given you the "when". For how to correct the problem, take a look
at
my March, 2004 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free
athttp://www.accessmvp.c om/DJSteele/SmartAccess.htm l
--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)
"Neil" <nos...@nospam. netwrote in message
news:u2******* *******@newssvr 22.news.prodigy .net...
>I am using Access 2003, and have an ongoing problem of every once in a
while losing an event procedure
for a form or control. The procedure's still in the code module, but
the
form or control's property sheet does not show "[Event Procedure]". I
have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least,
how
to
tell if there are any of these "detached" event procedures? It's
extremely
disconcerting to not have a procedure run that you assume is in place
simply
because "[Event Procedure]" is missing from the property sheet. Is
there a
way to tell if there are any of these in the db?
Thanks!
Neil
Great! Thanks! Looks like that will work great.
You know, it would be a lot simpler if Access had an option: Always Use
Existing Event Procedure, such that, if selected, Access will always use the
event procedure if one exists in the code module. For those of use who only
use event procedures, and who experience this problem, it sure would make
things easier! It would also allow us to create the procedure directly in
the module, instead of through the property sheet (I know, we can do that
now, and sometimes the property sheet gets set, but sometimes it doesn't).
It's such a future, ridiculous thing to have to select "Event Procedure" in
the property sheet if you never use macros. At least give us that option,
Microsoft!
(OK, I'm done griping. Thanks again!)
"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .comwrote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..
Rick's given you the "when". For how to correct the problem, take a look
at my March, 2004 "Access Answers" column in Pinnacle Publication's "Smart
Access". You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"Neil" <no****@nospam. netwrote in message
news:u2******** ******@newssvr2 2.news.prodigy. net...
>>I am using Access 2003, and have an ongoing problem of every once in a
while losing an event procedure
for a form or control. The procedure's still in the code module, but the
form or control's property sheet does not show "[Event Procedure]". I
have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least, how
to
tell if there are any of these "detached" event procedures? It's
extremely
disconcertin g to not have a procedure run that you assume is in place
simply
because "[Event Procedure]" is missing from the property sheet. Is there
a
way to tell if there are any of these in the db?
Thanks!
Neil
You might be right. I *seem* to recall it happening randomly, without
cutting and pasting the control. But you might be right. I'll have to keep a
closer eye on it.
Thanks!
"Rick Brandt" <ri*********@ho tmail.comwrote in message
news:Lm******** *******@newssvr 19.news.prodigy .net...
Neil wrote:
>I am using Access 2003, and have an ongoing problem of every once in
a while losing an event procedure
for a form or control. The procedure's still in the code module, but
the form or control's property sheet does not show "[Event
Procedure]". I have to manually put it back, and then everything's
fine.
Does anyone know what causes this phenomenon, or, at the very least,
how to tell if there are any of these "detached" event procedures?
It's extremely disconcerting to not have a procedure run that you
assume is in place simply because "[Event Procedure]" is missing from
the property sheet. Is there a way to tell if there are any of these
in the db?
Thanks!
Neil
If you rename the control or cut and paste the control you lose that
setting. I have never encountered anything else that caused it.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
"Neil" <no****@nospam. netwrote:
>You know, it would be a lot simpler if Access had an option: Always Use
Existing Event Procedure, such that, if selected, Access will always use the
event procedure if one exists in the code module. For those of use who only
use event procedures, and who experience this problem, it sure would make
things easier! It would also allow us to create the procedure directly in
the module, instead of through the property sheet (I know, we can do that
now, and sometimes the property sheet gets set, but sometimes it doesn't).
It's such a future, ridiculous thing to have to select "Event Procedure" in
the property sheet if you never use macros. At least give us that option,
Microsoft!
I can never remember where this option is so I had to do some Groups Google
searching. So thanks to a posting by Albert Kallal here's part of your gripe
solved.
tools->options->forms/reports tab
[x] - Always use Event procedures.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Yes, that's a helpful option for not having to select Event Procedure in the
property sheet when you double-click on a control. And perhaps that would
resolve the issue of not being able to create the procedure directly in the
code module. So that would be great. But, as you say, it's only part of the
gripe. I want an option where I don't even have to deal with the property
sheet -- where Access always uses the event procedure if one exists in the
code module, and just manages the property sheet itself (or makes the Event
tab invisible if the option is checked). Damn it, I DEMAND it, Microsoft!
Give me that feature or I'll take my business elsewhere! (OK, now I've got
them scared.....)
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:sp******** *************** *********@4ax.c om...
"Neil" <no****@nospam. netwrote:
>>You know, it would be a lot simpler if Access had an option: Always Use
Existing Event Procedure, such that, if selected, Access will always use
the
event procedure if one exists in the code module. For those of use who
only
use event procedures, and who experience this problem, it sure would make
things easier! It would also allow us to create the procedure directly in
the module, instead of through the property sheet (I know, we can do that
now, and sometimes the property sheet gets set, but sometimes it doesn't).
It's such a future, ridiculous thing to have to select "Event Procedure"
in
the property sheet if you never use macros. At least give us that option,
Microsoft!
I can never remember where this option is so I had to do some Groups
Google
searching. So thanks to a posting by Albert Kallal here's part of your
gripe
solved.
tools->options->forms/reports tab
[x] - Always use Event procedures.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Dee |
last post by:
I have 11 numeric fields on a form which are all inter related.
When any field changes after update, all need recalculation.
Each field has an after update event procedure. Each of which runs the
same code in different Private Subs.
Is there a way to point each private sub to just one subroutine, or do
I need all of this duplicate code?
|
by: Jared |
last post by:
Radio Button or Check Box and Event Procedures
I need to insert either radio buttons or check boxes onto my form. I'm
not sure which to use, or if there are other options. I am using the
buttons to: if one is clicked, its corresponding information will
become available on another document, if it's not clicked no
information will be provided. If multiple buttons are clicked their
information will available on the same document.
I'm not...
|
by: R Millman |
last post by:
under ASP.NET, single stepping in debug mode appears not
to stop within event procedures. i.e. 1) Create web page
with submit button and event procedure for the click
event in the code behind page, 2) Breakpoint in the
Page_Load, 3) debug the web page and click the submit
button, 4) "step into" under debug several times, 5) The
debugger does not stop at any of the statements in the
click event handler. A breakpoint is needed in each...
|
by: Fred |
last post by:
I'm combining the functionality of two existing aspx pages into one new
page.
One of the existing pages has a server-side Page_Load event procedure.
The other has <body onload="Init();"> (and Init() is of course a client-side
function).
Just wondering if it would be a mistake to try to have both of these
procedures (Page_Load and <body onload...>) in the new aspx page. Is there
anything wrong with doing it? Is it perfectly safe?
|
by: Kuldeep |
last post by:
Hi All,
Could anybody give me some ideas on the advantages and disadvantages when it
comes to having Event Procedures and Methods in .aspx page rather than
having them in .aspx.cs/.aspx.vb
Regards,
Kuldeep
| | |
by: Denis |
last post by:
Hi,
Looking at the template "Order Entry" in Ms Access, how do you get
the following to work?
In the customer form there is a sub-form giving a summary of orders by
customers. After entering an order for a custom it displays here.
When you double click on an order id it opens another form and lists
the correct record by order id
|
by: Neil |
last post by:
I have an ongoing problem of every once in a while losing an event procedure
for a form or control. The procedure's still in the code module, but the
form or control's property sheet does not show "". I have
to manually put it back, and then everything's fine.
Does anyone know what causes this phenomenon, or, at the very least, how to
tell if there are any of these "detached" event procedures? It's extremely
disconcerting to not have a...
|
by: Jim Roddy |
last post by:
I am converting from Office 97 to Office 2007.
Operating system XP pro.
All but one of my databases have converted w/o problems.
In the one that did not, none of the event procedures for buttons on my forms will work. All the macros work fine.
I cannot figure out why.
|
by: bhrosey via AccessMonster.com |
last post by:
Is there somewhere I can go to find out exactly what all the "event" names do?
For example, when exactly does the "on dirty" event happen or "on focus", etc.
.. Is ther a list out there somewhere?
Thanks
Bill
--
John 3:16 "For God so loved the world that He gave His only begotten Son, so
|
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: 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: 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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: 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...
| |
