Looping thru a table problem

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.
 
S

Steve Schapel

Marguerite,

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

Guest

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
Looping Macros 10
can i loop thru a listbox generating a report for each list item? 7
Access Macro Repeat Expression using value of a field in table 0
Conditional Loop in Macro 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to loop through a table 7
Get and Set the data in a table using a macro? 1

Top