Two Sets or One Set

[clara]

Hi all,

Are there two sets of function or one set function in Access. In Excel there
are two sets: worksheet and VBE

Clara

 

[Allen Browne]

Depends on your perspective.

In essence, you treat it as one set. You use the same functions in all
contexts: in queries, in the Control Source of controls on forms/reports, in
macros, and VBA code.

In reality, the functions executed in queries are slightly different than in
VBA code, the way expressions are evaluated in controls is a little
different than the way they are evaluated in VBA. Also, the functions are
not really one set: there are different libraries that supply the functions:
Access, VBA, DAO, ADOX, and so on.

 

[Stefan Hoffmann]

hi Clara,

Are there two sets of function or one set function in Access. In Excel there
are two sets: worksheet and VBE

"Set" is not quite the word i would use. In Access and Excel are a more
then two default libraries offering functionality to you.
The VBE and the Worksheet namespaces/objects are just two of them.


mfG
--> stefan <--