Adding multiple records at one time.

[Gourmet10]

I am trying to create a way to ask the user to [Key Name]
and then have it ask how many times this name should be
added to the database [Key number of records needed]. I
have tried everything and nothing seems to work, not even
a loop.

Thanks folks.

 

[Adrian Jansen]

There should be ( almost ) no reason to enter the same data multiple times
in a database. Read up on normalisation.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Gourmet10]

Thanks for replying Adrian

This is the scenario. We are using a software program that allows DOS programs to run on XP. In order to keep up with how many have been used, we must key the name of the requestor (tech loading software), how many usage license(s) are needed, I have an autonumber field and a Date() to supply the information for the date and numbering of requests

If I give "Tony" 10, I need to have a parameter value or VBA code that first asks [Given to Name], then followed by [How many given] (which would be a number ).

So if the name is Tony, he needs 10, I need to add 10 records using the "Given To" field, there are other fields in the database that will have data entered later (location, user name, etc.). Trying to create a sort of placeholder for new records

Hope I clarified that better.

 

[Adrian Jansen]

So you have a table with the Names, and a maximum number to be issued. Then
on the form where you do the actual allocations - and fill in the other
data, just put a bit of code in the After Update event of one of the fields
to check that the current number of records - available from the
form.recordsetclone.recordcount - is less than or equal the max number you
can lookup from that table. Then you dont need to create empty records at
all, just warn when the allocation is full.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

Thanks for replying Adrian.

This is the scenario. We are using a software program that allows DOS

programs to run on XP. In order to keep up with how many have been used, we
must key the name of the requestor (tech loading software), how many usage
license(s) are needed, I have an autonumber field and a Date() to supply the
information for the date and numbering of requests.

If I give "Tony" 10, I need to have a parameter value or VBA code that

first asks [Given to Name], then followed by [How many given] (which would
be a number ).

So if the name is Tony, he needs 10, I need to add 10 records using the

"Given To" field, there are other fields in the database that will have data
entered later (location, user name, etc.). Trying to create a sort of
placeholder for new records.