Prev: linking queries to create a report
Next: Bound Chart in Report Issues - Access 2007
From: Timothy Millar on 22 May 2010 19:31
I have a form with a command button. If the EndUser clicks the button a
report [rptUTILITIES] is generated and saved to the hard drive and the
EndUser moves to the next form without even knowing the report was generated
and saved.

How would I code this?

Let me thank you ahead of time. Thank you.
From: Steve on 22 May 2010 19:46
Hello Tim,

Look in the Click event of the button. There's a line of code to save the
report and then a line of code that looks like: DoCmd.OpenForm
"NameOfNextForm". Add the following code between these two lines of code:

MsgBox "The Utilities Report has been saved to the harddrive"

Steve
santus(a)penn.com

"Timothy Millar" <TimothyMillar(a)discussions.microsoft.com> wrote in message
news:DCFE3D2D-1503-4628-8C05-6748744BA4AF(a)microsoft.com...
>I have a form with a command button. If the EndUser clicks the button a
> report [rptUTILITIES] is generated and saved to the hard drive and the
> EndUser moves to the next form without even knowing the report was
> generated
> and saved.
>
> How would I code this?
>
> Let me thank you ahead of time. Thank you.


 | 
Pages: 1
Prev: linking queries to create a report
Next: Bound Chart in Report Issues - Access 2007