News:

GinGly.com - Used by 85,000 Members - SMS Backed up 7,35,000 - Contacts Stored  28,850 !!

Main Menu

Test Procedure for dhCountWorkdays

Started by sukishan, Sep 04, 2009, 04:51 PM

Previous topic - Next topic

sukishan

Test Procedure for dhCountWorkdays

Sub TestCountWorkdays()
    Dim rst As DAO.Recordset
    Dim db As DAO.Database
    Set db = DAO.DBEngine.OpenDatabase("Holidays.MDB")
    Set rst = db.OpenRecordset("tblHolidays", _
     DAO.dbOpenDynaset)
    Debug.Print dhCountWorkdays(#12/27/96#, #1/2/97#, _
     rst, "Date")
    Debug.Print dhCountWorkdays(#12/27/96#, #1/2/97#)
End Sub
A good beginning makes a good ending