Re: Update query to clean "N/A"s in exporteddata

Hi Frank,

here are some valuable tips on learning more using Help

***
to find out more about references...
***

press F2 in a code window to View the 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

change to the DAO library for DAO recordsets

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 other DAO libraries I have used -- it is what was standard with Access 97. IF you have it, this is a great library to look up help with in the Object Browser as the later DAO libraries don't always have help on everything.

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 ***

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
-- just use the Windows taskbar to switch between the module and help windows

***
You can also press F1 in any property on a property ***
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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ GRAPH help

from the design view of any module, link to the Graph Library

from the menu --> Tools, References
check Microsoft Graph #.# Object Library

from the menu --> View, Object Browser
OR
F2

On the left, you will probably see a Project window and a Properties window below it

On the right, you will see the main Object Browser window

change <All Libraries> in the Project/Library combobox in the upper left of the Object Browser window
to
Graph

explore each object in Classes
as you select a Class on the left, its members will appear in the pane on the right

when you see something you want help on, press the F1 key and switch to the Help window


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*

Frank wrote:
Crystal, It works beautifully -- I literally plopped it in and it worked (made me do a double take) -- I have a lot to learn about DAO objects. Thanks a million. Quick question: If Left(tdf.Name, 4) <> "Msys" Then -- on this line I imagine you're asking to overlook system generated tables -- is it recommended to always overlook these files. and If fld.Type = 10 Then -- I saw there were all types of constants you can set the field type to; 10 wasn't defined, I imagine it's for text?
Thanks again!
Frank
.

Quantcast