In this section, you will look at how you can configure the behavior of the Help system and the use of the Object Browser as an alternative method for locating help on objects.
Configuring the Help System
VBA has an excellent Help system. To use it, simply click a word that you do not understand, and then press F1. However, it's best to have the Help system set to work with Show Content Only From This Computer; otherwise, many of the help topics might not easily locate help for a particular keyword, function, or method. Figure shows this setting being changed at the bottom of the figure.
With the Help screen open, setting the Help system to Show Content Only From
Access comes with an extensive Help system, and by highlighting a keyword in code (for example CurrentDb) and pressing F1, you can display help on the statement or object, as shown in Figure.
Press F1 when you have the cursor on a VBA keyword to locate the keyword
Working with the Object Browser
As you move into more advanced programming, you will see that when you work with objects outside of the Office suite, getting help by pressing F1 will not always display the help information for the object. In this case, you can use the Object Browser either by using the toolbar or pressing the F2 key. Help is then also available on these external libraries through the object browser.
You can use the object browser to locate objects
The object browser can be used for code units designed in your application, external referenced programming units, and Office components including Access where we have searched for the text Currentdb.
When you have located an item in the object browser, press F1 to display the help file that describes the object.
MS Access Related Tutorials
|Oracle 8i Tutorial||VBA For Excel Tutorial|
|Management Information systems Tutorial||Microsoft Excel Tutorial|
|Microsoft Word Tutorial||Advanced Excel Charts Tutorial|
|Advanced Excel Functions Tutorial||Excel Dashboards Tutorial|
|Excel Data Analysis Tutorial||Excel pivot tables Tutorial|
|Excel Power View Tutorial|
MS Access Related Interview Questions
|Oracle 8i Interview Questions||VBA For Excel Interview Questions|
|Management Information systems Interview Questions||Microsoft Excel Interview Questions|
|Microsoft Word Interview Questions||Microsoft FrontPage Interview Questions|
|Excel Data Analysis Interview Questions||Excel pivot tables Interview Questions|
|Excel Power View Interview Questions||Access Control List Interview Questions|
Ms Access Tutorial
Using The Vba Editor And Debugging Code
Understanding The Vba Language Structure
Understanding The Vba Language Features
Applying The Access Object Model
Understanding The Data Access Object Model
Using Forms And Events
Using Form Controls And Events
Creating Reports And Events
Adding Functionality With Classes
Using Classes And Events
Using Classes And Forms
Linking Access Tables
Integrating Microsoft Office
Using Sql Server
Upsizing Access To Sql Server
Using Sql Azure
Using Ado And Adox
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.