Query - add records automatically..

  • Thread starter Thread starter ramrod
  • Start date Start date
R

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
 
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



ramrod said:
HI
Click to expand...
I am creating a DB in Access 2003.
Click to expand...
Tables: Client - Careworker - Placement
Click to expand...
Query: Placement query
Click to expand...
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!
Click to expand...
The careworker visit the clients the same day in each week for the
same no of hours.
Click to expand...
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)
Click to expand...
(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).
Click to expand...
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
Click to expand...
Any help would be great .... Thank you ..
Click to expand...
Ramrod- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thank you .. I will check it out !
Ramrod
 
Back
Top