running reports and queries

  • Thread starter Thread starter perplexed
  • Start date Start date
P

perplexed

I have a multistep macro that runs 3 reports and 3 macros.
I would like to know if there is a way to turn off the
output so the user doesnt see it. I am only using them to
get info for the next step.
 
Perplexed

It is not clear what you mean by "turn off the output", nor what "get
info for the next step" might refer to. Can you please give some more
detail. Examples often assist.
 
I do an "openreport" as the first step in the macro, this
report calculates the count of records that I need to use
in the next step's "setvalue". What I would like to do is
not have the output from the "openreport" step show, if
possible.
 
Perplexed

The OpenReport action is unnecessary. If you need a count of records,
use...
DCount("*","NameOfQuery")
.... where NameOfQuery is the query that your report is based on.
 
Where would I do that? In the field property of the field
I want to put the dcount result in? Do I put it as an
event when I open the form? Do I put it as part of a macro?
 
I'm sorry, I don't have enough information about what you are trying to
achieve, in order to answer these questions. How were you going about
obtaining the "count of records" figure form your report? What were you
doing with this figure? What form? Etc
 
Back
Top