marco needed to add a certain number of records

[askjacq]

I have a table where they enter the number of items created. I need to create a macro (NOT vba - don't know how to use it, so please don't post answers requiring vba) that adds that number of records to a different table.



So ... they enter
Product - Potatoes
Date Entered - 2/1/2013
Product Number - 32

They push a button and the macro adds that number of records into a d different table. Each records has the product, date entered, and an auto-generated number.

And to make things more fun, they want all the auto-generated numbers to be even. Is that possible?

Thank you!!

[askjacq]

I got more info about the auto-generated number. I don't want to use autonumber because if they add/delete records, they won't be a sequential series. So I want to generate the number based on the number of records in the table and add 1 - so if there are 1001 records, the 32 records will be number 1002, 1003 ... 1033.

Doable?

Oh! And they nixed the all-even idea!

[Missinglinq]

Your post has gone, unanswered, for over 24 hours, now. I suspect the problem is that very, very, very few of the experts here use Macros, with the possible exception of a specialized one call AutoExec that fires when an Access Database first opens. Macros are simply too inflexible, too difficult to debug/trouble-shoot, and make understanding what is being done difficult. If you're serious about learning how to develop Access Databases, you're really going to have to bite the bullet and learn VBA.

The AutoIncrementing of ID-like numbers, which is what you're talking about, is pretty straightforward, but once again, is best done using VBA.

Also, exactly how would you expect, with an AutoIncremented-number, to avoid the problem of missing numbers? If Record #15 of a series of, say, 30 Records, is deleted, that space between Records #14 and #16 is still going to be missing, regardless of how the number was generated. Using the standard DMax+1 would only help with this is the last Record entered were the one being deleted.

Linq ;0)>