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.

 

[Pat Hartman]

Creating 10 empty records at one time does not make your process easier than if you created 10 single records one at a time. You still have to type in all the data. If this is awkward with your form, you might want to redesign the form.

There are reasons for doing what you ask but this isn't one of them based on your description.

I have an inventory app that creates multiple inventory items because the client wants them logged separately. For example, we receive 10 cases of white towels so I create 1 inventory item (with a corresponding label) for each case. This makes it easier for his warehouse to send them out again. He tells them to send case #4 and that way even though there are a hundred cases of white towels, the warehouse people know exactly which case to send to which client. It keeps inventory from getting old. If I were receiving 10 identically configured PCs, I might use the same technique and then go record by record and add in the serial numbers manually but I would probably use the technique recommended by Doc. However, if the serial numbers were sequential and so I could generate the correct serial number for each PC as part of the append, then I would certainly use an append query rather than making the user touch ten records manually.

 

[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.