Form Entry (Enter a quanity of record)

[spartanx117]

I have employees who enter into a database what types of activities they have been working on. Some activities can be done hundreds of times a day, and instead of having them enter the activity 100 times, is there a way I can add something to a form for the user to input a number(quanity) that will then add that number of records into the DB? Each record is defined wtih a auto number key, and the person's initials, current data and the activity.




If I read 100 Emails, I would enter this 100 times, with the issueID inreasing each time I entered.

IssueID 101
JBC
Read Email
10/3/2013

I would like to add a quantity selection so it will enter the inputting record x number of times when they click add record. Is this possible?


Access 97 (This company doesn't keep up with times ^-^ ), currently using 1 table with ID field, initial field, date field, work completed field.

Thanks!

I also tried searching for someone else with a similar post, but was unsuccesful. If this has been answered, can you provide a link!

[June7]

Use VBA procedure. Here is rough example.

Dim i As Integer
For i = 1 to Me.tbxLimit
CurrentDb.Execute "INSERT INTO tablename(field1, field2, field3) VALUES('textvalue', #datevalue#, numbervalue)"
Next

For dynamic values, reference controls on form and concatenate.
CurrentDb.Execute "INSERT INTO tablename(Initials, DateEnter, Activity) VALUES('" & Me.tbxInitials & "', #" & Me.tbxDate & "#, '" & Me.Activity & "')"

[spartanx117]

So I would have a field that would have this vba code assigned to it. It would take the numerical value the employee would insert, and put for I. So then for each I(lets say they put 100 in), it would Insert that many records?

If that code isn't correct, I'm sure I can look around and fix it. I was looking around for a loop function, but it wasn't very clear on the ones I found.

And thank you for a reply!

[June7]

Not a field, a button would have this code in its Click event VBA procedure.

The real trick is making sure they don't accidentally click the button more than once and end up with too many records created.

The For Next is a looping construct.