Create a repeating entry in Access

[Guest]

Is it possible to create a repeating record in Access, i.e., every 7 days? I
have a standing reservation that has to be entered into an Access database.
Thank you.

 

[John Vinson]

Is it possible to create a repeating record in Access, i.e., every 7 days? I
have a standing reservation that has to be entered into an Access database.
Thank you.

An Append query could do this pretty easily. What's your table
structure? How many days out do you want this - a month, ten
centuries?


John W. Vinson[MVP]

 

[Guest]

For this to work the database must be running and a form must be open. The
form can be invisible though.

On the timer event create something like below (caution air code and won't
work):

If WeekDay(Date()) = 6 then
docmd.runsql ......
Endif

The 6 above is for Fridays. Sunday is 1.

Set the timer interval to run only once a day which is a rather large number
as it's in milliseconds.

1000 * 60 * 60 * 24 = 8640000