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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

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
Click to expand...

--
Bob Heifler
My Access Program, Owner
www.myaccessprogram.com
info (At) MyAccessProgram (Dot) com

Message posted via AccessMonster.com
 
Back
Top