reference guide to system functions

  • Thread starter Thread starter sasan3
  • Start date Start date
S

sasan3

Where can I find an online reference to all access functions (i.e.
OpenRecordset(), dlookup() etc.), their parameter list, usage, etc.?

Thanks.

S
 
Access Help is not useful for this. You will find good detail on it in the
VB Editor Help.
 
You don't mention what version of ms-access.

In a2003, if you hit ctrl-g to get to the code editor, you can then go
help->Microsoft Visual basic help

You will get a pane on the right side. There is great sql ref in that pane,
and also a great "tree" like reference for VB
(the first option: Microsoft Visual Basic Reference).

It got all of the functions listed out, and objects, and methods. It is a
VERY NICE layout.

In addition to the above, while in the code editor, you can also hit f2 for
the object explorer, and again this is a terrific way to browse functions.
(for a2002, and a2000, this works well, as the help is not so good, but the
a2003 help is quite nice).

when you hit F2, hen select "VBA" for the first combo box. At that point,
you get another tree that lets you "browse" the functions of VBA.

Both of the above are very good and useful ways to view/see the
functions/objects/methods for VBA.

And, last by not least, there is a MSDN library, and it also lists out the
functionally. The best is a download for
the ms-access VBA ref.

You can find it here:

http://msdn.microsoft.com/office/downloads/vba/default.aspx
 
Back
Top