Two Sets or One Set

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

clara - 09 Mar 2007 15:48 GMT

Hi all,

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

Clara

Signature

thank you so much for your help

Reply to this Message

Allen Browne - 09 Mar 2007 16:13 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi all,
>
[quoted text clipped - 3 lines]
>
> Clara

Reply to this Message

onedaywhen - 12 Mar 2007 15:20 GMT

> > Are there two sets of function or one set function in Access.
>
[quoted text clipped - 7 lines]
> VBA code, the way expressions are evaluated in controls is a little
> different than the way they are evaluated in VBA.

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.

--

Reply to this Message

Stefan Hoffmann - 12 Mar 2007 15:39 GMT

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

Reply to this Message