Record up-date

D

dbl

Hi I have to run a weekly report of all the estimates not received, when I
have finished with the report I have to go into each record and up-date the
comments4 field stating "Chased estimate 03/01/05". I also have 2 other
reports which have to be up-dated in the same way.

Is it possible to automate this process some how?

Any help would be very much appreciated.

Bob
 
R

rowiga

Is the syntax for you comment field entry always the same? ie...Chased
estimate (some date). What determines the date entered into your comment
field?
 
R

rowiga

Yeah...that's very doable. Use the query that you use as criteria to generate
the report as a sub-query for an Update query to update your comment field.
In the update query design you want to select the query that drives the
report and the table that you want to update. Link the query/table. In the
"Update To" row for the Comment field enter:

"Chased Estimate " & Date()

I would try this on a test copy of my database to make sure that your record
selections are correct before applying to the real database.
 
R

rowiga

Sorry...gave you half an answer. The previous post is the how-to for gettin'
it done but not how to start it. I don't know how you call up your report but
you could add code to open the update query from the same code or you could
use the OnClose event for the report to open the update query. If you have
warnings off the update should happen invisibly.
 
D

dbl

Hi Rowiga how do I word the code in the close report event procedure to open
the qry and up-date the field Comments4?

Also I did not mention that the Comments4 field is a memo field which may
already have data in it, I have used the following code before to update
this field. Me.Comments4 = Comments4 & "FILE CLOSED" & Now() this puts the
update in the right place without clearing any date in the field, will I
have to use this code in the qry "Update to" field?

Thanks for your help.

Bob
 
Top