Link to Access functions reference ?

  • Thread starter Thread starter TonyB
  • Start date Start date
T

TonyB

Hi,
I have a simple question. Where is the definitive reference to the functions
available in Access 2000/2003 ? I'm always trying to remember the syntax for
functions like date,ccur . They aren't mentioned in the access help ?
Regards
Tony
 
Tony

Actually, some of the functions are mentioned in Access HELP, but many of
them now (more recent versions of Access) only show up in VBA HELP. To see
those, you need to open the VBA (modules) window and try HELP.
 
Hi Jeff,
I can't seem to get this to work very well. For instance if I open the VBA
window, and try to find help on the Date function it doesn't list the
function at all.
The reason this came up is that I'm trying to load an access database
example from a textbook, that references the date function, but it will not
compile due to syntax errors.
If (Date - DateOrdered) > 34 Then
The compiler complains that Date is not recognized as on project or library
so I'm trying to find out more about it.
Regards
Tony
 
Ah, that's a different issue.

It sounds like your copy of Access has lost a reference.

Open a code module. Click Tools|References and see if any are prefixed
"MISSING".

Note which one(s), uncheck it/them, and close/save.

Re-open the references and re-check them. Close/save.

Recompile (Debug|Compile).

Did it work?

Jeff Boyce
<Access MVP>
 
Back
Top