developingprogrammer
asked on
breakline in afterupdate causes button click to NOT fire
hey guys,
here's a simple empty database.
the problem here is that - i've got a textbox with an afterupdate event and a commandbutton with a onclick event. both event codes have nothing in them except a Stop.
scenario 1:
if i edit the text in the textbox and then click on the commandbutton, by right 2 things should happen. 1 --> the afterupdate will fire off first. 2 --> the onclick will fire off.
HOWEVER after the afterupdate fires off and the code breaks at the Stop and i resume code execution, the onclick event isn't firing off anymore.
scenario 2:
same as scenario 1 except i remove the Stop from the afterupdate event. so there is only 1 stop in the onclick event.
the afterupdate event fires off and then the onclick event fires off.
Question:
why does going into break mode stop the onclick event from firing off?
here's the demo database as a proof of concept.
thanks guys!! = ))
Database1.zip
here's a simple empty database.
the problem here is that - i've got a textbox with an afterupdate event and a commandbutton with a onclick event. both event codes have nothing in them except a Stop.
scenario 1:
if i edit the text in the textbox and then click on the commandbutton, by right 2 things should happen. 1 --> the afterupdate will fire off first. 2 --> the onclick will fire off.
HOWEVER after the afterupdate fires off and the code breaks at the Stop and i resume code execution, the onclick event isn't firing off anymore.
scenario 2:
same as scenario 1 except i remove the Stop from the afterupdate event. so there is only 1 stop in the onclick event.
the afterupdate event fires off and then the onclick event fires off.
Question:
why does going into break mode stop the onclick event from firing off?
here's the demo database as a proof of concept.
thanks guys!! = ))
Database1.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi Christian and boag2000!
so sorry i just read through your responses. thanks so much for looking into this question and helping me out!! = ))
boag2000 i'm basically trying to be a purist and a pain in my own derriere by trying to understand everything that is happening, turning over every single stone one by one. so in this case i noticed an anomaly and want to understand why = ) the benefits of testing and understanding this setup would be - it helps me be a better tester and understand why when i'm in breakmode, i may not expect certain things to happen - cause previously like what Christian said, i really thought VBA is like a perfect ghost. but - we are not aloooooneee = )) so now when i'm debugging in breakmode, i know what to expect better!! = ))
thanks Christian for the enlightening again!! = )) i was suspecting something like this was happening but my knowledge is very parochial encompassing only VBA at the moment so stuff like windows OS things and hardware, i'm as good as Yoda with an iPhone haha = PP
i really think i need to go study how all those installers are made on windows - for example when i install the FMS software, how they make those windows. i think using VB.NET or VB 6.0 or something like that. i'm really excited to get to know more but i've got to take things one step at a time = ) Access, then database servers, then iPhone, then websites, CMS, desktop OSes. something like that. business IT alignment!! = ))
so sorry i just read through your responses. thanks so much for looking into this question and helping me out!! = ))
boag2000 i'm basically trying to be a purist and a pain in my own derriere by trying to understand everything that is happening, turning over every single stone one by one. so in this case i noticed an anomaly and want to understand why = ) the benefits of testing and understanding this setup would be - it helps me be a better tester and understand why when i'm in breakmode, i may not expect certain things to happen - cause previously like what Christian said, i really thought VBA is like a perfect ghost. but - we are not aloooooneee = )) so now when i'm debugging in breakmode, i know what to expect better!! = ))
thanks Christian for the enlightening again!! = )) i was suspecting something like this was happening but my knowledge is very parochial encompassing only VBA at the moment so stuff like windows OS things and hardware, i'm as good as Yoda with an iPhone haha = PP
i really think i need to go study how all those installers are made on windows - for example when i install the FMS software, how they make those windows. i think using VB.NET or VB 6.0 or something like that. i'm really excited to get to know more but i've got to take things one step at a time = ) Access, then database servers, then iPhone, then websites, CMS, desktop OSes. something like that. business IT alignment!! = ))
ASKER
hrmm boag2000 i use stop a lot in my code so that when i C&R i won't lose my breakpoints. but yup it's just temporary. i learnt it from Christian and the other experts who taught me this in this question = ) https://www.experts-exchange.com/questions/28182785/Using-end-and-stop-statements.html
(ignore my stupid posts, only the experts' ones count haha = PP = ))) )
(ignore my stupid posts, only the experts' ones count haha = PP = ))) )
ASKER
Christian i always think of the MJ concert in Munich haha, when he sang that song and hugged the girl = )) http://www.youtube.com/watch?v=pw76ii3Rs6o
i'm mastering hit Beat It song now = ) or rather when i'm in the bus or train. always got a song on my travels when i can't use my computer!! haha - it's easier to sing from low to high but the other way round, to unzip our vocal cords and transit the mix from more heady tone to a more pharyngeal and throaty resonance again WHILST keeping the larynx down, my goodness that's real hard!! but rewards too!! = ))
i'm mastering hit Beat It song now = ) or rather when i'm in the bus or train. always got a song on my travels when i can't use my computer!! haha - it's easier to sing from low to high but the other way round, to unzip our vocal cords and transit the mix from more heady tone to a more pharyngeal and throaty resonance again WHILST keeping the larynx down, my goodness that's real hard!! but rewards too!! = ))
Hi,
yes, there are Install project types for .NET, but better usable in .NET applications.
If you want to create a real good installer which is easy to configure with a professional look, you should use this (the best one I've used so far) and it's free:
http://www.jrsoftware.org/isinfo.php
See also the 3rd party software on the page with free GUIs to configure this compiler.
The youtube video is not visible in Germany due to GEMA rights...:-)
Singing is great, helps getting the head free.
May the force be with you...?...;-)
Cheers,
Christian
yes, there are Install project types for .NET, but better usable in .NET applications.
If you want to create a real good installer which is easy to configure with a professional look, you should use this (the best one I've used so far) and it's free:
http://www.jrsoftware.org/isinfo.php
See also the 3rd party software on the page with free GUIs to configure this compiler.
The youtube video is not visible in Germany due to GEMA rights...:-)
Singing is great, helps getting the head free.
May the force be with you...?...;-)
Cheers,
Christian
ASKER
let me get back to yall on this post ya? i'm so sorry!!
Christian and boag2000, i think the sith lord is winning over the bright side in this question - https://www.experts-exchange.com/questions/28235344/error-Could-not-update-currently-locked.html?anchorAnswerId=39479944#a39479944
my lack of skills are forcing me to lean toward the dark side VBA BUT i won't give up!!!! i need to call upon the great ones (if they can spare some force) to advise me on how to conquer the deathstar and bring SQL back to glory again!!
(in short, could yall help me look at https://www.experts-exchange.com/questions/28235344/error-Could-not-update-currently-locked.html?anchorAnswerId=39479944#a39479944 if yall have the time? --> i'm almost done with my project guys!!!! i can't wait to... not party --> but go through all the EE questions again and refactor my code and make it better!!!! = )) one of the first things i'm going to do is create custom controls with validation using custom events!!)