Query Results showing in Macro

  • Thread starter Thread starter Bill Johnson
  • Start date Start date
B

Bill Johnson

This has never happend to me before, I'm using Access
2002.

I have a Macro that calls an Update Query and a Delete
Query, the query results are popping up on the screen.
This has always happened in the background before. Is
there a new setting?


Thanks for your help!
 
What do you mean, "query results"? Are you seeing a datasheet view of the
query? Or message boxes stating that "x number of records are being
affected"?
 
What I'm getting is a datasheet view of one of the queries
that shows records about to be added to a table, and
another datasheet view of a delete query showing the
records about to be deleted from the same table.
 
Not normal behavior. Are you sure that you're not calling a SELECT version
of the query first and then the action query?
Post the macro actions that you're using.
 
You nailed it.

Buried in the Macro were two select queries.

Thanks!
 
You must log in or register to reply here.

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

running queries from a macro 4
How to Use Field Twice in Query 1
hiding queries behind a macro 2
Compact & Repair, Open table, close table, then run macro 3
using If,then, else statement in a macro 1
Append Queries in a Macro 6
Filter: field=Variable works once, then gives same result any Var 1
Macro with make table 1

Back
Top