Report view is incorrect

Do I need to add the module to the report, or leave the action as the current
select Macro?

"CMTH" wrote:

That unfortunatly did not work.
I received the 'Conversion finished' message and then tried running the
report with the same results.

Any other suggestions?

Thanks in advance!

"CMTH" wrote:

I have created a report that when opened, runs a macro that outputs the
report to an excel spreadsheet and also sends the report in a snapshot format
to an email in Outlook.
The problem is...the information in the email attachment is correct, but
after the macro finishes running, the report opens and only displays a couple
lines of the information.
If the report is opened without the macro running, all information is
displayed correctly.

Any help will be greatly appreciated!

The macro name is still listed in the activate property line.
How do I add the module to the report?

Sorry if the question, but I am self taught and just being to work with code.

"Jerry Whittle" wrote:

Add the module to the report. It's probably still looking at the macro.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"CMTH" wrote:

Do I need to add the module to the report, or leave the action as the current
select Macro?

"CMTH" wrote:

That unfortunatly did not work.
I received the 'Conversion finished' message and then tried running the
report with the same results.

Any other suggestions?

Thanks in advance!

"CMTH" wrote:

I have created a report that when opened, runs a macro that outputs the
report to an excel spreadsheet and also sends the report in a snapshot format
to an email in Outlook.
The problem is...the information in the email attachment is correct, but
after the macro finishes running, the report opens and only displays a couple
lines of the information.
If the report is opened without the macro running, all information is
displayed correctly.

Any help will be greatly appreciated!