Query - add records automatically..

[ramrod]

HI

I am creating a DB in Access 2003.


Tables: Client - Careworker - Placement


Query: Placement query


The Placement query is linking the 3 tables and keeps records of
where the careworkers are and the no of hours they are with clients!


The careworker visit the clients the same day in each week for the
same no of hours.


Requirement: to automatically have the placement query records updated
for 14 days in advance( ie of today's date)... so data does not have
to keep being retyped ! ( I will then also use this info to view in
a form when a 'carer' is working the folowing week, again with have to
retype everything)


(I have a yes/no box in Tables/palcement. called[Cover]... which I
would like to use as a clause not to update the above..(ie in advance
fill records if set to 'yes' the record is not automatically
created!)
in the placement query).

This action should replicate the record for one week today (if
possible update twice, at the 7 and 14 day point. days in advance)
and put the new date of the work to be carried out in the correct
'workdate' field


Any help would be great .... Thank you ..


Ramrod

 

[Duane Hookom]

There is a Recurring sample database at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane which
demonstrates how to create scheduled records. This might get you started.

 

[ramrod]

There is a Recurring sample database athttp://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duanewhich
demonstrates how to create scheduled records. This might get you started.

--
Duane Hookom
Microsoft Access MVP

HI

I am creating a DB in Access 2003.

Tables: Client - Careworker - Placement

Query: Placement query

The Placement query is linking the 3 tables and keeps records of
where the careworkers are and the no of hours they are with clients!

The careworker visit the clients the same day in each week for the
same no of hours.

Requirement: to automatically have the placement query records updated
for 14 days in advance( ie of today's date)... so data does not have
to keep being retyped ! ( I will then also use this info to view in
a form when a 'carer' is working the folowing week, again with have to
retype everything)

(I have a yes/no box in Tables/palcement. called[Cover]... which I
would like to use as a clause not to update the above..(ie in advance
fill records if set to 'yes' the record is not automatically
created!)
in the placement query).

This action should replicate the record for one week today (if
possible update twice, at the 7 and 14 day point. days in advance)
and put the new date of the work to be carried out in the correct
'workdate' field

Any help would be great .... Thank you ..

Ramrod- Hide quoted text -

- Show quoted text -

Thank you .. I will check it out !
Ramrod