good reference for functions??

[mitchem1]

Does anyone know of a good reference that lists and describes all of the available functions (len, right, left, val, etc.). I'm not fond of wandering through Access 2002 Help.

 

[The_Doc_Man]

Given the number of versions that are out there, the best reference is the help files, which I know you didn't want to hear. Besides, you are limiting yourself. Most of the books I have seen don't list all of the functions equally. They focus on the "neat" ones or the "common" ones and give short shrift to the remainder. Your best bet for completeness in any version of Access is the Help Files.

 

[Pat Hartman]

I agree with Doc. Once you know the name of the function you want to use, help is the best source for syntax and samples. However, help is absolutely hopeless if you don't know the name of the function you want. You would need to be very lucky to happen on an appropriate help entry.

This is a reasonable book that lists all the functions. You can view parts of it online. Amazon has used copies available for very little money. I couldn't find a newer version:
VB & VBA in a nutshell

 

[Kodo]

MSDN library anyone?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtorifunctions.asp

 

[Pat Hartman]

Close but no cigar. This is a great reference but it is to VB Script functions, not VBA functions. I looked but couldn't find a comparable reference for VB or VBA.

 

[Kodo]

Close but no cigar. This is a great reference but it is to VB Script functions, not VBA functions. I looked but couldn't find a comparable reference for VB or VBA.

Thus far a great majority of those functions (coming from ASP myself) has worked flawlessly for me in VBA. Some I've never had a use for so I haven't tested them all.. but I'll puff on a cigar because I know the most common (non-script related) one's work.

this should help

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/VBRef98/html/vbmscLROverview.asp

when the page loads, look left, click "language reference" then functions..

 

[Rich]

Don't newer versions of the product include a Functions Reference list?

 

[Pat Hartman]

Another great reference kodo. Thanks. I'm not sure why I couldn't find that. I did search for functions. Anyway VB, VBA, and VB Script all share the same roots. That's why most of the VB Script functions work in VBA. Same for the VB functions. But there are still missing functions such as the aggregate functions and the Domain functions.

Don't newer versions of the product include a Functions Reference list?

- Actually, older versions of the product include excellent Functions references. You can get functions by type as well as alphabetically. So if you know you want a date function but you don't know what its name might be, you can just look through the small list of date functions. I have never found anything similar in A2K or AXP and I have looked.

I posted a function list that I have been building for some time. The list is in a spreadsheet so you can sort it by name or function category.

http://www.access-programmers.co.uk/forums/showthread.php?p=272354#post272354

 

[Kodo]

Pat,
That reference was buried in there like a tick... since .NET came out, they are making it more difficult to find older references.. that's for sure. Took me a few minutes of digging through the VB home page to find the documentation on it all. Damn MS..lol

Hope it helps!