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.

Access Calendar Multiple Days Upload Images   Link  Teacher Barzan  8 years ago Thank you for help Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Calendar Multiple Days Upload Images   Link  Vinod Krishnaswamy  9 years ago Great turorial help me a lot thanks Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access Calendar Multiple Days Upload Images   Link  mohamed  9 years ago Great Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Show Older Comments...
View in Table Format