Access 2003 macro

N

NoTechDude

I have a macro that takes data from several queries to create a table. When a
query has no data to display it stops the macro. Is there a way to skip the
query that has no data and continue to the next one? Should I use VBA code
instead of a macro and queries for this?
 
C

Chris O'C via AccessMonster.com

Macros can only follow step-wise instructions. They can't make decisions
based on criteria, or repeat steps in loops, or handle errors. Use VBA code
with the queries.

Chris
Microsoft MVP
 
N

NoTechDude

I was using select queries at first with basic "select all records' and
"paste" functions. I have changed the queries to "append" queries and it has
solved my problem. Probably not the cleanest way to go, but my coding skills
aren't quite good enough to tackle without someone holding my hand. Thanks
for the reply.
 
C

Chris O'C via AccessMonster.com

Don't bother with the "select all" and "paste" jobs. An append query to get
the data into the table is the right way to go. Runs much, much faster, too.
Your coding skills are heading in the right direction. :)

Chris
Microsoft MVP
 
Top