Looping an append query

[MalcR via AccessMonster.com]

I have an address table Tbl_Address into which I need to append copies of
particular addresses selected by a user. I intended to make a temporary table
to hold the address detail chosen along with a field “NoofCopiesâ€. Can anyone
please suggest a sequence of events needed to enable an append query to run
the same number of times as the number of copies required.

Thanks

Malc

 

[jleckrone]

Perhaps a For Loop.

Dim J as int

For J = 1 to Me.NoofCopies
Do whatever
Next J

Hope that helps!

 

[MalcR via AccessMonster.com]

Hi,

Thanks for your reply, but I have no knowledge of VBA. Can I put this code
within a macro?

Malc

Perhaps a For Loop.

Dim J as int

For J = 1 to Me.NoofCopies
Do whatever
Next J

Hope that helps!

I have an address table Tbl_Address into which I need to append copies of
particular addresses selected by a user. I intended to make a temporary table

[quoted text clipped - 9 lines]