create multi records in same time

[SalmanZeiad]

how to create number of records by enter for example 5 in text box then click button

 

[theDBguy]

This is usually not recommended. Can you tell us why you want to do this? Thanks.

 

[SalmanZeiad]

when i enter item and it`s =10 ,,enter one one>>i want make 10 record same time to easy enter details each one

 

[theDBguy]

when i enter item and it`s =10 ,,enter one one>>i want make 10 record same time to easy enter details each one

Hi. Does that mean you're trying to create 10 duplicate records?

 

[SalmanZeiad]

for example i want to enter in store item Hard drive =10 pices, id,model,sn

 

[SalmanZeiad]

Hi. Does that mean you're trying to create 10 duplicate records?

yes but each one have id

 

[theDBguy]

yes but each one have id

Hi. Since we can't see your database and we're not familiar with it, that doesn't really explain yet, why you're trying to do it. In any case, to add new records, you can either use an APPEND query or VBA (to add one record at a time). Hope that helps...

 

[The_Doc_Man]

You might want to consider this:

Rather than enter 10 new records (which you think you want to do but really - trust me, you don't), consider building a form to create one record at a time - but you add two other things:

1. Code to remember all of the contents of the text boxes and other controls on the form when you save the record
2. A button and code that says "create new record" followed by copying the saved contents of the last record you just entered. This would allow you to replicate records as many times as you click the "Replicate" button, and anything you don't change before you save the new record becomes "default" values for the next record.

 

[zeroaccess]

This can be helpful if you want to populate your subform with "presets" to help data entry users work more efficiently, but it can also be a negative if a user does not want some of them and needs to delete them. It could also lead to database bloat.