Add records

[Guest]

I have over 500 people in my database. I need to add Jan-Dec under each
person. Is there a way I can do this quickly or do I have to go through each
person.
I am able to do it one person at a time and add all 12 months. But can I
write a macro to automatically do this. I will have to do this each year.
It would be nice to just click a command button.
Thanks
Chey

 

[Douglas J. Steele]

You'll have to give a few more details. It sounds as though you're trying to
create "placeholder" entries, even though you have no data to put in them at
present. That's a pretty unusual thing to do with databases.

 

[Ron2005]

It is somewhat unusual but not necessarily uncommon. I had it with a
set number of pre-defined tasks for a project and the estimated start
date for each task established when the project start date was entered.

Possible solution:

(This assums that you have the effective year somewhere in that record)

As follows:
=============================
1) Create table with established tasks (Months and any other data that
can be established at create time.

2) Append query that has Emp table and Month table but no link between
the two.
Emp table to the left of Month table. This will cause it to go through
the month table for every employee in the emp table.
A) Append the records to your sub table for keeping this
information with the Emp key from emp table and the month data from the
month table and a year entry from somewhere, either as requested
parameter or from a form to kick this off, and any other information
from month table that you wanted.


You might end up making a special version of this for single employee
adds for whenever an employee is added.

Month table
append to sub table
Emp ID from new employee form or whereever
Year from Current date or effective date so you can add for 2006 in
January of 2007.
month id from month table.

And have above triggered from new employee add form or whatever.
=============================
Another option is to use append query using the prior year's detail
history and append everything but have all fields 0 or empty except for
empid, and year (put 2006 in it now) and month.
Ron

 

[Guest]

Right now when I add a new person I have a set value to add all 12 months.
Now since it is a new year I need to add all 12 months for 2006. I can go
through each person and do this but I want to do it with one click of a
button.

 

[Guest]

I am sorry But I don't understand some of this stuff. I made a new table
with 12 records Jan 06-Dec 06.
Now What? How do I do an append query?