Thanks again Steve for your great videos. This subject really deserves a real, real world example that would make sense in an application. I am really having a hard time trying to figure out where I could use this in any of my applications.
Thank you!!! Finally, a thorough enough explanation of how WithEvents works. I can't even find a book that explains things so well. You've helped me greatly.
Thank you Steve for all the videos you have posted. Not only do you explain well, but you also share your working example for people to play around with. I have been recommending your channel to people who are interested in learning vba.
There are several things that are amazing in this video: 1. The Form_frmForm is an object of class Form, but at the same time it's a class itself. 2. Form_frmForm is an object of class Form_frmForm. 3. When using built-in event like txtMessage_change and Form_onload, no need to dim and set, Access uses the generic Form and txtMessage as both class and instance. 4. Raise an event in the subroutine of a subscriber of another event.
Ohh Steve Thank You So Much ,I am Able to Create "Type As You Search" Like Google Search Facility in My Forms Where i Combined Custom Events And Search using Keywords Videos of Yours Thanks From India.
Hi Steve, I been following this lecture and I'd implemented it successfully. When I just tried to declare the the event in a class module which is not the same as where it is being raised , I get a not found event error. The reason for me trying to this is, my wish to create a "Global" event handler as follows: I have a project with tenth of forms in each of those forms there are several Text-box controls recognizable by their background color property. I want to set those controls with a common event of calling a specific Function on a click their click event. Now instead of walking through all the code, trough all forms and their respective relevant controls, I want to be able to set using a common event to subscribe those recognizable controls with a common procedure call as the click event occurs. As you can notice, if I failed with the simple task of "just exporting" the event declaration to another class, you can assume how much I am not commanding the Custom Events concept. So if you can please provide a detailed explanation on 'How to', that could be great. I apologize in advance if my English isn't as good as expected. This is due the fact of me not being a native English speaker . Thank You again Ruvain
Oh wow ! That's an awesome functionality :O The sky is the limit now. I tried this to refresh a main form after a yes/no in a subform, that is not linked to it, changed. It did not worked however.... Any idea how to do this ? Maybe I'm missing a little something.
I love this video, i had idea though, so with the frmOtherForm, couldnt you use this like say you have some ppt slides you wanted updated. this is where you put the info for those slides and then all you have to do prt screen and crop out the part of the form you want to paste onto a slide as a jpeg. what do think?
You could do that, but it wouldn't be something I'd try to do programmatically. If you're looking to build slides from out of Access you'll need to learn more about the PowerPoint classes that you can bring into the VBA code.
I fail to see the usefulness of creating my own custom event. In my database, if 2 things are true, then the double-click event performs function1, but if 3 things are true, the double-click event performs a different function2. I lack the imagination to understand how this is useful. Please explain. I am a new subscriber.
Same functionality to give text from one text box to another with just one line of code: Forms!Form2!Text0.Text = Forms!Form1!Text0.Text No need to raise event. Event on change will do the same.
Thanks again Steve for your great videos. This subject really deserves a real, real world example that would make sense in an application. I am really having a hard time trying to figure out where I could use this in any of my applications.
Thank you!!! Finally, a thorough enough explanation of how WithEvents works. I can't even find a book that explains things so well. You've helped me greatly.
Thank you Steve for all the videos you have posted. Not only do you explain well, but you also share your working example for people to play around with. I have been recommending your channel to people who are interested in learning vba.
There are several things that are amazing in this video:
1. The Form_frmForm is an object of class Form, but at the same time it's a class itself.
2. Form_frmForm is an object of class Form_frmForm.
3. When using built-in event like txtMessage_change and Form_onload, no need to dim and set, Access uses the generic Form and txtMessage as both class and instance.
4. Raise an event in the subroutine of a subscriber of another event.
I laughed when you said "now I'm gonna get rid of those irritating record selectors and stuff!" That's exactly how I feel about them!
Ohh Steve Thank You So Much ,I am Able to Create "Type As You Search" Like Google Search Facility in My Forms Where i Combined Custom Events And Search using Keywords Videos of Yours
Thanks From India.
Thank You! Very helpful, an awesome explanation!
Very nice!
I was hoping you'd include events with a Cancel As Boolean argument
Hi Steve, I been following this lecture and I'd implemented it successfully. When I just tried to declare the the event in a class module which is not the same as where it is being raised , I get a not found event error.
The reason for me trying to this is, my wish to create a "Global" event handler as follows:
I have a project with tenth of forms in each of those forms there are several Text-box controls recognizable by their background color property. I want to set those controls with a common event of calling a specific Function on a click their click event.
Now instead of walking through all the code, trough all forms and their respective relevant controls, I want to be able to set using a common event to subscribe those recognizable controls with a common procedure call as the click event occurs.
As you can notice, if I failed with the simple task of "just exporting" the event declaration to another class, you can assume how much I am not commanding the Custom Events concept. So if you can please provide a detailed explanation on 'How to', that could be great. I apologize in advance if my English isn't as good as expected. This is due the fact of me not being a native English speaker .
Thank You again
Ruvain
+ruvain1 have you looked over the work files?
also maybe on the form you have the data you need for the slides but have a text box next to the data is where your typing the message.
Oh wow ! That's an awesome functionality :O The sky is the limit now.
I tried this to refresh a main form after a yes/no in a subform, that is not linked to it, changed. It did not worked however.... Any idea how to do this ? Maybe I'm missing a little something.
Hi. Do you know how to setup a calendar alarm into Access? We want to check on expiration dates before they expired
I love this video, i had idea though, so with the frmOtherForm, couldnt you use this like say you have some ppt slides you wanted updated. this is where you put the info for those slides and then all you have to do prt screen and crop out the part of the form you want to paste onto a slide as a jpeg. what do think?
You could do that, but it wouldn't be something I'd try to do programmatically. If you're looking to build slides from out of Access you'll need to learn more about the PowerPoint classes that you can bring into the VBA code.
I fail to see the usefulness of creating my own custom event. In my database, if 2 things are true, then the double-click event performs function1, but if 3 things are true, the double-click event performs a different function2. I lack the imagination to understand how this is useful. Please explain. I am a new subscriber.
Same functionality to give text from one text box to another with just one line of code:
Forms!Form2!Text0.Text = Forms!Form1!Text0.Text
No need to raise event. Event on change will do the same.
ok thank you ill have to hit the books a little harder