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.

 

[Kodo]

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

 

[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?

 

[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!