Networkdays Type Mismtach error

[macroapa]

Hi I am using the networkdays function from:

http://www.mvps.org/access/datetime/date0006.htm

The first function works fine, but the second (with holidays) fails
with 'type mismatch' at the line:

Set DB = CurrentDb

Any idea where I'm going wrong?

Thanks.

 

[BruceM]

It would help to see the actual code you are using, at least up to the line
where the code failed. Did you include the line:
Dim DB As DAO.Database
?

 

[Maurice]

And maybe set a library reference to DAO while you are at it... depending on
the access version ofcourse.