Calendar input over multiple days to create a separate row for ind

F

fishy

I have a simple holiday tracker with a calendar control that writes one line
for each day off. I really want to be able to entre a date range and for some
coding to then write all of the weekdays (M-F) between these dates to the
table as 1 row per day.

The calendar bit I have worked out, its the bit after update I have not got
a clue where to start.

Any help would be appreciated
 
H

heifler via AccessMonster.com

Dear Fishy,
You need to learn how to open a recordset for the table you want to add
records to. Then you need to loop from the first date through the last and
use open recordset to add each record. Search key word, open recordset and
loop in VBA.

Or get someone to write the code for you.
See my signature
Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top