northwind

[bronc]

Is there a description of the operation of the new Northwind sample d/base - in particular the VBA? I notice that there is not much commenting in the code. To save some time I've tried Googling without success as yet. Thanks

 

[hermanlaksko]

In the incl. help file you will find lots of comments to the code used in northwind.

Also on M$ web you will be sure to find information regarding the northwind base and the code within.


Herman
Say no to macros

 

[bronc]

well thanks hermanlaksko. The Northwind code is quite instructive - maybe I'm being a bit lazy but I would have liked to see a line by line breakdown - in particular it was a bit of a revelation to see DLoopUp being used to return data from a query. Saves using DAO etc I guess.

 

[MajP]

in particular it was a bit of a revelation to see DLoopUp being used to return data from a query

Really? The domain aggregate functions:
DAvg
DCount
DLookup
DFirst
DLast
DMin
DMax
DStDev
DStDevP
DSum
DVar
DVarP

have been around since at least A95, and are some of the most powerful and useful functions in Access. You just have to be careful of overuse. They are not very optimized, but extremely flexible. In certain cases it is better to use ADO or DAO.

Many of the common Access books use Northwind as the sample and talk through the code.

http://www.blueclaw-db.com/domain_aggregate_function/