Looping thru a table problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've done this before...but for some reason am having a problem today. I
want to set a value in one field in every record in the table.

Set Value
New Record
Run Macro

I'm only looping 20 times and getting a message that a macro can only call
itself 20 times.
 
Marguerite,

It sounds like you should be using an Update Query, and an OpenQuery
action in the macro to run the update.
 
Thanks. That worked.

Steve Schapel said:
Marguerite,

It sounds like you should be using an Update Query, and an OpenQuery
action in the macro to run the update.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping through Macro 8
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Pivot table macro filter data between yesterday and today (date+time) 0
can i loop thru a listbox generating a report for each list item? 7
Looping Macros 10
Conditional Loop in Macro 1
Access Macro Repeat Expression using value of a field in table 0
Repeat macro until record count of query = 0 0

Back
Top