Object Browser
---
Hi Nick,
I know the book you are talking about -- mine still sits on a shelf
where I can use it. Aside from the books that shipped with the
developer edition of Access 97, the closest thing in Access I have found
is to use the Object Browser
press F2 in a code window to View the Object Browser
(or, from the menu --> View, Object Browser
change the library to "VBA" (for instance, instead of <all libraries>)
and look at the classes (categories) of functions -- click on a class
and then click on a function in the right pane. To get the help for that
function, press F1
The VBA library is the most basic library and a great place to start
exploring.
to lookup properties and methods for different objects like forms,
tabledefs, etc, change the library to Access
for recordsets, try the DAO library
explore the different libraries you have to pick from and see what is
available in each
when you are in the Object Browser window, the library that each
function/class is a member of is shown in the lower left corner of the
window
the Object Browser is a GREAT way to learn
when you have an object selected, press F1 to get help.
on DAO: the Microsoft 2.5/3.51 Compatibility Library has more built-in
help than DAO 3.6 -- it is what was standard with Access 97.
from Tools, References...
you can select a library and then use the Object Browser to see what it
has in it...
***
another great way to learn is to press F1 on keywords in a module sheet
-- or type the word in the debug window (CTRL-G) and press F1
ie: OpenForm, OpenReport, CASE, any built-in function such as DateDiff,
Format, etc
-- that gets you immediately to the help for that topic without having
to navigate
-- use the Windows taskbar to switch between the module and help windows
***
You can also press F1 in any property on a property sheet
I highly recommend you learn more about the events, what triggers them,
and the order they happen.
***
You can also press SHIFT-F1 while in the design view of a form or report
(for instance)
this turns your mouse into a pointer with a question mark -- click on
any tool or menu item to get information instead of selecting while in
that mode
***
keep in mind that any menu option with [...] after it will have a dialog
box with a CANCEL button
-- so explore!
***
and then, despite how simple it seems -- start reading help from the
beginning of the table of contents -- it really is quite interesting.
Learn about collections, objects, properties, methods, events ...
Object-oriented programming is a whole different way of thinking than
sequential programming
Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
