Automatic entry of mondays date every week in table

M

Middlemix

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
 
R

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
Click to expand...
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
M

Middlemix

Thanks for that

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

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?
Click to expand...
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.
 
M

Middlemix

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
 
R

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
 
Top