How can a function/procedure start automaticaly on a certain date

[Guest]

I need to make an application that has a function or a procedure which starts
automatically on a certain date. I want the function to calculate the credit
on that date.

 

[TC]

Well, I want to win the lottery - but that's not gonna' happen either!


Seriously, how could anyone answer your question based on those two
sentences?

- Do you have to do this in Access?

- Will the PC be turned on 24 hours a day?

- If not, what do you see happening if the PC is not turned on at the
time in question?

- Where does the information come from, to calculate the credit? Does
it come from the database, a website, user data entry, or what?

If you take the effort to answer those questions, maybe someone can
give you suggestions!

HTH,
TC

 

[Arvin Meyer [MVP]]

Access can only run code from forms or modules, so it needs to be turned on,
or a scheduler program needs to turn it on. If it is a simple calculation,
you don't even need Access, you can do it with a batch file that prints to
a file. Also, unless the data is random and is entered at irregular
intervals, you can calculate any value for any date and don't need to wait
until that date.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access