Automatic entry of mondays date every week in table

[Guest]

Hi, please be gentle as this is my first post.

I have DATES-TABLE with fields FROM DATE and TO DATE, every Monday the user
goes in and puts The Mondays date in the from field and Sundays date in the
TO DATE field. Is there a simple solution in that every monday morning those
2 dates are automaticaly updated?

Thanks

 

[RuralGuy]

If it helps here's code to create the Monday and Sunday date for the week with
the current Date()

Me.txtSundayDate = Date() + (7 - DatePart("w", Date(), 2, 1))
Me.txtMondayDate = DateAdd("d", -6, Me.txtSundayDate)

Hi, please be gentle as this is my first post.

I have DATES-TABLE with fields FROM DATE and TO DATE, every Monday the user
goes in and puts The Mondays date in the from field and Sundays date in the
TO DATE field. Is there a simple solution in that every monday morning those
2 dates are automaticaly updated?

Thanks

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

Thanks for that

Where would I insert this code As this information needs to go into a table?

 

[RuralGuy]

How about as the default value for your TextBoxes?

Thanks for that

Where would I insert this code As this information needs to go into a table?

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Guest]

Ruralguy

What I mean is that I want a new record creating in a table every Monday. I
I do it that way it creates the current date. The database I use records work
on a Monday so I would need that date in place.

Does this make sense?

Thanks

Ian

 

[Rebeccca Turner]

im sorry but im not the one you need to talk to im the one who gives good
advise bout boy firend gurlfriend friends and family problems thanks

lola and angel!!! w/b plz = write back
please