Daily table update

[cavyman]

I'm sorry if this has been addressed before, but after quite a bit of
searching I've been unable to find anything directly related to my
problem.

I have a form that contains several fields: TargetDate,
CustomerPriority, and Difficulty. The VB code I've written for this
form calculates a ProposalPriority based on a formula using the values
from the above fields. That part of my form works wonderfully, however,
I need the ProposalPriority to be updated daily (based on the current
date and the TargetDate which I already have in my code), automatically
or otherwise, on ALL records in the table. As it is now, a record is
only updated when the user scrolls through the records using the form.
What would be the best way to run my ProposalPriority code on all
records in the table? Thanks!

 

[Amy Blankenship]

Don't include it in the table. Instead, provide a query that shows the
other information and calculates this information on the fly. You should
also hide your tables so that casual users won't be viewing data directly in
them anyway.

HTH;

Amy

 

[Larry Daugherty]

To get something to update daily and automatically, use the system
scheduling agent. You may need a timer in your first form to Quit the
application if the form has sat idle for XX minutes.

In your application put code in the load event of your first form to
run an update query to do what you want. Now your update will be run
every time your application is opened by a user or the system agent.

HTH

 

[dbahooker]

more importantly; screw MDB in the mouth

and use SQL Server-- with Access Data Projects-- and a simple Sql Job.

about 1000 times more powerful than any batch file you could write for
MDB automation.