Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating ecords into another table from Beginning & Ending Dates

Status
Not open for further replies.
May 5, 2002
79
US
I am fairly new to access but have coded a little VBA code so far. My need is beyound my skills at this point. I have a form with beginning and ending date fields linked to a query (A). I need to have a cmd button that would kick off code to insert records into another table (Table B) for each day starting with the beginning day and ending with the ending day and each day between. Also, how would I handle correcting the records in the Table B is the beginning or ending date changed or I need to cancel the whole project (these are project beginning and ending dates). Many thanks in advance from this newbie.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top