setting up reoccuring records

[Guest]

Alright, I've been given a new task. Each contract we have, has several
reports due each month. they are always named the same thing, but each month
they have to be logged in to the db. The only difference between a new on
and an old report is the date when it was due and any comments that are made
for it. Is there a way access can generate a new record every month so we
don't have to type in all the same data every month?

 

[Guest]

Reports are normally generated from data saved in tables.
If your data is saved in tables, all you need do is to produce the new due
date and the comments. These can be typed into a form when the report is
requested and the report can place them on the report.

-Dorian

 

[Al Campagna]

FreeHand,
If I understand correctly, you add new records, but 99% of the info is duplicate form
record to record.
You should be able to set the Default Value for those fields to the most common value.

But, why would someone develop a report that has the same info over and over again
except for Date and Comments? Sounds a bit odd...
If 99% of the fields are consistent values, save those values (one time) in a table,
and just update and store the Date and Comments. The constant data and the Date and
Comments could be brought together in any subsequent form, report, or query. Why keep
saving all the constant data each time a new report comes along?

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Guest]

I didn't realize that so few of the fields were basically static. I've
started to redo my tables to reflect that. I'm sure I'll encounter new
problems once that is complete.