|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
|
Always Use Event Procedures By Richard Rost 
6 years ago
Default to Code Builder - Always Use Event Procedures In this Microsoft Access QuickTip video, I'll show you how to make Access always use "Event Procedures" and jump right to the VBA Visual Basic editor window whenever you select a "Build Event." LinksAccess Developer Level 1: https://599cd.com/ACD1
IntroIn this video, we'll talk about how to set Microsoft Access to always use Event Procedures when adding code to form or report controls, so you can skip the window that asks which builder you want to use. I'll show you how to find and change this setting in Access Options and explain how it affects your database development.TranscriptWelcome to another TechHelp Quick Tip video brought to you by AccessLearningZone.com. I am your instructor Richard Rost. Today's Quick Tip is a question I get asked at least once a week. People always want to know how do I set it so that my Access database always uses the code builder instead of popping up that window that asks you which builder you want.Here is my blank customer database. If I go in here and drop a button, I want to put some code in this button. I can right-click on it and go to Build Event and it jumps right into the VB editor. That is because I have it set to always use Event Procedures. Let me show you how to get there. Close that. Go to File, Options, the Access Options appear. Go to Object Designers. The setting that you look for is right here. It is called Always Use Event Procedures. If I turn that off, I am now back to the default setting where Access will ask me what kind of builder I want. Let me hit OK. I have to close the database and restart it. Let me close the database, save changes, sure. Reopen it again. Now if I go back into Design View, if I right-click on this now and go to Build Event, Access asks me which builder I want. I do not really work with macros, I almost never use the Expression Builder, so I like it to default to Code Builder, which brings me to this. But I do not want to have to pick that option every time I work with Access. So again, I am going to go back into File, Options, Object Designers, and turn on Always Use Event Procedures. And now, right-click, Build Event, and it goes right into the VBA editor. I cover this topic and lots more in my Access Developer Level 1 class. I will put a link in the description down below the video. This has been your Quick Tip for today. Again, my name is Richard Rost, and thanks for watching. Thanks for watching. QuizQ1. What is the main topic discussed in this Quick Tip video?A. How to always open the code builder by default in Microsoft Access B. How to design reports in Access C. How to connect Access to Excel D. How to import data into Access Q2. Where do you find the option to set Access to always use Event Procedures? A. In the Home tab B. In File, Options, then Object Designers C. In the table settings D. In the External Data tab Q3. What setting needs to be enabled to always jump into the VBA editor when building events? A. Enable Macros option B. Always Use Event Procedures C. Use Expression Builder by Default D. AutoCorrect Enabled Q4. What happens if "Always Use Event Procedures" is turned off? A. Access skips adding events to controls B. Access always uses macros C. Access asks which builder you want to use each time D. Access automatically opens the report builder Q5. After changing the "Always Use Event Procedures" setting, what must you do for it to take effect? A. Restart Microsoft Access B. Change your database password C. Import a module D. Run a compact and repair Q6. What is NOT one of the builder options in the Build Event dialog? A. Code Builder B. Expression Builder C. Macro Builder D. SQL Builder Answers: 1-A; 2-B; 3-B; 4-C; 5-A; 6-D DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryIn today's Quick Queries video from Access Learning Zone, I am going to answer a common question I receive frequently: how can you set your Microsoft Access database to always use the code builder when working with events, instead of being prompted to choose between different builders every time?Starting with a blank customer database as an example, say you want to add a button to a form and enter some code for its event. Normally, if you right-click on the button and select Build Event, by default Access might ask you which builder you want to use – Code Builder, Macro Builder, or Expression Builder. However, I prefer it to go directly into the VB editor for Event Procedures, as this saves a lot of time and hassle, especially since I rarely use the other builders. To set this up, open Access and head to the File menu, then select Options to bring up the Access Options dialog. Navigate to the Object Designers section. Here, you will find an option labeled Always Use Event Procedures. When this option is enabled, Access will always default to the code builder whenever you are working with events, bypassing the prompt completely. If this setting is turned off, Access reverts to its default behavior and asks you which builder you want to use each time. After changing this setting, you may need to close and reopen your database for the change to take effect. Once you restart, any time you select Build Event on a control, Access will go straight to the VBA editor. Personally, since I spend most of my time working with VBA and rarely use macros or the Expression Builder, I find it much more efficient to have this setting always enabled. I explain this tip, along with many other useful techniques, in my Access Developer Level 1 course. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListSetting Access to always use the code builderNavigating to Access Options Locating Object Designers settings Enabling Always Use Event Procedures Demonstrating builder selection behavior Restarting Access to apply options |
||||||||||||||||
|
| |||
| Keywords: TechHelp Access code builder event procedures object designers PermaLink Always Use Event Procedures in Microsoft Access |
