Report OR Not?

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

Guest

I am writing a vba module which returns values of incorrect information in
data fields.

Due to the complexity of the analysis I couldn't do what I needed with a
simple query based report.

What is the best way to print the return values of the module?

Do I have an unbound text box in a report and set that equal to the variable
which was return from the module?

Can I simply print these values through vba without creating a report? If
so what would be the best way to accomplish this.

Basically I am checking data entry that is being done by my employees. I
would like to create a switchboard which will analyize the different forms
and make sure the data being entered in correctly. The data is being entered
into 3rd party software (Medisoft) so I cannot create error traps during the
data entry.
 
Stefan said:
I am writing a vba module which returns values of incorrect information in
data fields.

Due to the complexity of the analysis I couldn't do what I needed with a
simple query based report.

What is the best way to print the return values of the module?

Do I have an unbound text box in a report and set that equal to the variable
which was return from the module?

Can I simply print these values through vba without creating a report? If
so what would be the best way to accomplish this.

Basically I am checking data entry that is being done by my employees. I
would like to create a switchboard which will analyize the different forms
and make sure the data being entered in correctly. The data is being entered
into 3rd party software (Medisoft) so I cannot create error traps during the
data entry.
Click to expand...


How probably depends on what the function is doing. If it
returns a single value, as functions are supposed to, then
you can just use the function in a text box's control source
expression:
=functionname(arg1, arg2, . . . )

If the function is a procedure with several results to place
on the report, then most likely the procedure would store
the result values directly into separate text boxes in the
report. In this case the procedure would ne easier to
manage if it were in the report's module and you would call
it from the Format event procedure of the section containing
the text boxes.

There are other ways to get calculated data in a report, but
I pretty sure you definitely need to use a report.
 
Back
Top