Duplicate record

[mrgunner]

Hey there,

I've a form with some fields. when i fill all fields i want to duplicate
that record x times. How?
I thougt that i can have a independent field (textbox) where i can write the number of times i wanna duplicate that record but i don't know o to do it.
Someone?
thanks

 

[DCrake]

What type of data are attempting to duplicate?
Does the table have a primary key or auto number?
What is the purpose of the exercise?

 

[mrgunner]

What type of data are attempting to duplicate?
Does the table have a primary key or auto number?
What is the purpose of the exercise?

Thanks for the fast reply.
The data to duplicate is text and numbers. The table has a primary key which has a counter(?). The purpose is that sometimes when I fill out the record it has to be for several days (dates), one record for each day.

 

[DCrake]

So the only thing thats different - apart from the primary key - is the date?

Are you talking consecutive days? working days? What about holidays?

I think you need to introduce another table that is the child of this table that holds the dates in it and the PK of the Parent record.

 

[mrgunner]

Yes, the only thing thats different is the date. Yes, consecutive day.

Is this possible if I make a table whith the dates (whole year?)?

 

[birsey]

Hi, using Access 2007 it is very easy to generate a "duplicate record" command-button on a form.

Just open the form in design view, hit the "design" tab, and use the "Button" command, place your button, and follow the wizard instructions (select "record operations", "duplicate record").