Subject: Use of Folder in Expression Builder

[Regi]

Hi,

When I open Expression Builder in a query and then open the Functions folder
an addittional folder appears with the name of my database in it. In the
Northwinds Sample Database I saw that this folder can hold expressions. I
just can't fiqure out how to use it. I was wondering if I could put
frequently used functions like Sum and Left in there so I don't have to
scroll throught the whole funtions list.

Thanks

 

[sonia]

in italiano non capisco

 

[John Spencer]

No, this folder lists the functions that have been created in VBA modules.

In theory, you could write a "wrapper" function to call the standard built-in
VBA functions, but that would probably be a lot more trouble than the benefit
received.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Regi]

Thanks John.

No, this folder lists the functions that have been created in VBA modules.

In theory, you could write a "wrapper" function to call the standard built-in
VBA functions, but that would probably be a lot more trouble than the benefit
received.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County