Automatic updating of table/Form data

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

Hello,
I have to create an application that automatically writes
the values from a Form and a table to a table. I have to
do this in such a way that this automatic writing of data
is done once in every 24 hours and the values that were
written before 30 days should be deleted.Any suggestions
with Macro commands I have to use or any other pointers
are welcome with a thanx!



Since, I am a bit new to Access, I am not able to complete
this and I am not able to find a solution. If such s topic
has already been covered, then, I have not landed on the
correct result.In any case, many thanx for a help!!

With Reg,
Samantha
 
Samantha,

In Access, data entered on a form is automatically written to the record
source table when the form is closed or the user moves to another record.

You can use a Delete Query to remove records more than 30 days old.
This assumes you have a field in the table that records the date when
the record was created, for example this can be done by setting the
Default Value of sucha field to Date(). If you want the process of
deletion to be automated, you can use an OpneQuery action in a macro to
run the Delete Query. Then you need to decide which event to assign the
macro to, for example it might be on the Open event of a form which is
always opened when the application starts up.
 
Back
Top