Automatic Updates?

[Guest]

Can an Access query be created to update a database table on a certain month
in a year without having to remember to run the query?

Thanks

 

[Tom Ellison]

Dear Jacob:

This could be done setting up a database which performs your task whenever
it is opened, then closes.

Use the scheduler to run this at the appropriate periods.

Tom Ellison

 

[Guest]

Instead of doing a task on a certain date which i do need, can it also update
employee's vacation time based on their hire date? I guess this would require
IF statements or something since everyone doesn't get the same amount of
vacation since it is based on the number of year served.

 

[Tom Ellison]

Dear Jacob:

I cannot study your database design to see what you have on which to base
such a function. You have given almost no information.

Tom Ellison

 

[Guest]

Thanks for your reply. I'm not asking about specific information. I simply
asking about possibilities.

You have a table it has all employee information including hire date. The
"query" checks the hire date of the employees that were hired in the same
month as the current date. If that date is more than 6 years, then it adds so
many hours of vacation time to the table that tracks vacation time.

Then the other question is how to prevent it from firing again once it has
been fired once for that month. (basically i don't want the query to add 80
hours everytime the table i opened for the same people.) I don't need to know
the specifics just whether or not this can be done. However, some key
components may be good to know for later.

I don't need details at the moment. I'm simply trying to make sure that this
can be done and what i need to look up. After i get more info then i can read
up and ask more questions on the specifics as i need help.

Thanks so much!

 

[Tom Ellison]

Dear Jacob:

The availablility of vacation time should be a process that looks at
vacation time earned and vacation time used. This should be derived, not
stored. Do not store derivable information under ordinary circumstances.

Tom Ellison