Two Sets or One Set

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

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

Clara
 
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.
 
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.
Click to expand...

Various classifications may be justified but I attach particular
importance to the expressions/functions available natively to Jet.
Broadly speaking these are the VBA5 scalar expressions (as distinct
from functions that are methods) and they do not require the Access
user interface to be running. The best approach IMO is to avoid using
Access-only expressions in SQL for stored database objects especially
if you anticipate using the data outside of Access; for example, if
you try to use a VIEW (stored Query) within Excel whose SQL
definition includes Replace (VBA6 expression) or NZ (Access object
library expression), a UDF, etc you will receive an 'unknown
expression' error.

Jamie.

--
 
hi Clara,
Are there two sets of function or one set function in Access. In Excel there
are two sets: worksheet and VBE
Click to expand...
"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 <--
 
Back
Top