how to copy records/Recordset.

[Roy riggsjø]

I have created a db of events. these events shall happen every year. so i need to copy the events from last year in to this year, and next year copy this year, using vba.

for instance say:
i have two records, bowling night and juggling night. hehe funny life.. anyway. each of these events have a field specifying which year they are in.
I want all these events the next year as well. then i would like to copy all the events from last year and create new ones, but now with this year in the year field.

so i wonder... if i could create a recordset from the main recordset using sql and where... specifying the year i want to copy.... and then add this recordset to the main recordset...

It is necessary that this is done in VBA.

is this possible? any other good ideas?

Many Thanks!!!
-Roy

 

[mearle]

INSERT INTO table1 SELECT * FROM table1 WHERE Year=xxxx