I am preparing an attendance register for a small school
I have two table:
1. Students with fields (ID, [Student Name], [Class],,,, and many other fields
2. [Std Attendance] with fields ( ID, [Attendance Date], Std ID, [Std Name], [Std Class], [Present](yes/No)
I want to generate attendance for a date for all students by VBA Coding through a command button
For this purpose:
1. By using VBA code in command button (Selecting Table [Students] in command button]
DoCmd.GoToRecord , , acFirst
Do While Not Me.NewRecord " In Table [Students]
2. Append new records in Table [Std Attendance] for each students for each record in Table [Students]
3. On append Each new record in table [Std Attendance] want to auto copy following fields data from [Students] Table:
a) [Attendance Date] from System date by command date()
b) [Std ID] from [Students].[ID]
c) [Std Name] from [Students].[Student Name]
d) [Std Class] from [Students].[Class]
Please guide how can i take my required results.
Your help will be highly appreciated and may be helpful to others too.
Regards
Haseeb ul Hasan