Looping an append query

  • Thread starter Thread starter MalcR via AccessMonster.com
  • Start date Start date
M

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
 
Perhaps a For Loop.

Dim J as int

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

Hope that helps!
 
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
Click to expand...
[quoted text clipped - 9 lines]
Message posted via AccessMonster.com
Click to expand...
Click to expand...
 
Back
Top