Macros and Dates

[Surfette]

Hi,

I want to have a macro on a form where it will populate dates for all the records based on a date.

Envision a Form that has a blank for the Teacher to fill in the current date. Once the Teacher fills in the current date (i.e. April 3, 2006) and pushes a command button, the macro will take all of the students associated with the form/class and auto populate dates April 3, 2006, April 4, 2006, April 5, 2006, April 6, 2006 and April 7, 2006 for all students.

Is this possible? If so, how do I go about doing so?

All ideas and suggestions are welcomed!

Thanks in advance.
Surfette

 

[FoFa]

Use an update query

 

[Surfette]

Hi FoFa,

I didn't try the update query but it seems like it changes all the existing records. Is there a way where I could create a macro and it creates new records and inputs the dates?

I'm trying to help this school create the attendance section so that a teacher can get to the "Attendance Form" and

(1) Input today's date in <TodaysDateField>
(2) Hit a button
(3) The database would copy all the students in that particular class > create a new record for each of those students > input the date that the teacher put in in step (1) for all students
(4) Then the teacher can check off whether each student is present, tardy or absent.

Thanks!

 

[FoFa]

Base an append query on a select query that:
1 - Only selects the students in that class

That way you can tweak your select query to only return those that you want before creating new records for them.