Duplicate Specified number of Records

[Kempes]

Acc 2003

Hi,

Does anyone know if this is possible. I've looked but can't find anything like it posted within the forums unless I'm searching for the wrong keywords.

If I have a list of records on a continuous form, I want to drop a combo box at the end of the each record with a list of numbers in ranging from 1 - 100.
When a value is chosen, the selected record is then duplicated by that number.

For example, Select a record, choose 20 from the combo box = 20 new entries of the record.

Also, as a side issue, is there a way of omitting or clearing certain fields from the process.
For example, Serail Numbers are unique, so I want the user to have to manually key these in once the duplication process completes.

Hope I have explained this in enough detail.

Thanks
Kempes

 

[Ethereal]

I'm not sure about how to duplicate, but if the serial numbers are unique shouldn't they just be an auto number ?

 

[Kempes]

Thanks for the replies.

My Database is split into various tables which has lots of 1 - many Relationships.
The reason why I need to add duplicates is purely for time saving purposes.
The db is to record hardware amongst other things as they are received from our suppliers. If we receive 10 PCs for example, we would have to record each entry. In the backend, the table that will hold this data is mostly links to other tables so will only hold the value of a primary key of other tables.
So rather than the end user having to select the Manufacturer, Model, Type, Status, etc, as they will be the same for each of the 10 records, they will automatically populate then just require the remaining fields to be keyed or selected from a combo.

Hope this paints the picture a little better as to what I want to achieve.

 

[john471]

Since some of the data for each record would need to be unique (e.g. Serial Number, as you say), would it not be safer to have users choose the required options (type/model/make etc and Serial Number) for the first unit, and provide a button on the form to carry the "continuing" details through to a single new record, where the user would then enter the unique data for that item, and click your magic button again etc etc etc.??? That way would also save you from having to build a seperate interface for them to locate and (manually) update each "new" record. I believe the Command Button wizard in AC2003 has an option for Duplicate Record, that should get you started. (hint: you will then need to add code to "clear out" the unique fields)

HTH Regards

John