Automatically inserting entries based on a calendar date

[nirmeet]

I work for an internal consulting department and our analysts are
required to track their work. We use microsoft access application to
enter the information and generate reports. A portion of the work we
do is done periodically, eg. weekly reports. What can i do
automatically generate records instead of having to enter the
information on a weekly basis?

 

[Guest]

What kind of information has to be periodically entered before generating
reports?

Reports can be automatically run by using the widows task scheduler in
combination with a script calling the report.

You would have to create a script file and then schedule it to run.

 

[nirmeet]

I am sorry for the confusion on the question, but the analysts prepare
weekly entries and log in the information. So instead of logging this
information in every week, can they setup a scheduler of some sort
that automatically logs in the information but just changes the dates
on the table.

Thanks,
Nirmeet

 

[Guest]

Possibly, but much more information would be needed to offer a solution here

 

[nirmeet]

Possibly, but much more information would be needed to offer a solution here
--

Example:

Table: Engagement Tracker

Fields to fill up: External customer, customer contact, date of
request, date of submission, report name, estimated hours, actual
hours, status.

A certain analyst prepares the same sales report every week and
submits it to the customer.

When he logs in the information to the project tracking tool, he
enters the above information in the table.

All the information except the date of request and submission will
change in the new entry. Is there a way here to get this done
automatically after accepting certain parameters (such as frequency of
report, etc) as input?

I have above avg skills as an access user and can code this in if you
can provide some starting guidance, or if you have a prior information
regarding an existing function within access.

Now