Error occurs at the call getCalendarData from the sample of Year Calendar Report. Wanted to display each empID record when report is shown but can only show 1 record for all diff. empID thus modified the code as below to
Public Sub loadReportYearCalendar(theReport As Report)
Dim i As Integer...
How to invoke the call function in code? Pls provide the code?
Function getCalendarData(employeeID As Long) As Boolean
Dim rs As DAO.Recordset
Dim strDate As String
Dim strCode As String
Dim strSQL As String
Dim i As Integer
'//Set rs = CurrentDb.OpenRecordset("t_employeeAttendance"...
Error argument not optional occurs at Call getCalendarData
How to make your code work? Function getCalendarData(employeeID As Long) As Boolean
Dim rs As DAO.Recordset
Dim strDate As String
Dim strCode As String
Dim strSQL As String
Dim i As Integer
'// setup sql to retrieve one employee's...
Hi Dom DXecutioner
How to generate report for multiple empID and the data corresponding to it also changes it? For your sample, only allow 1 empID to reflect the data for that report. Pls provide the code.....tnks:rolleyes: