Alex sent this in to me a few MONTHS ago, and I'm finally getting around to put it online. Lots of people have asked how you could take the database we built in the Calendar Seminar and add events that span multiple days. This way if you're going on a trip from the 5th to the 11th, you don't have to type in 7 separate entries.
Well, Alex used a little technique with something called a RECORDSET to loop through 7 days (or however many you want) to add entries to the calendar for each day. It's not the BEST solution, but it works just fine for this database. Thanks to Alex for sending this in to me to share with everyone here.
TIP: Access Calendar Addendum: Multi-Day Events
Enjoy.