ACCESS FEED: RE: [MS_AccessPros] Saved report out put to command button.

Minggu, 26 Februari 2012

RE: [MS_AccessPros] Saved report out put to command button.

Robin

Starting in 2007 some actions were deemed unsafe for macro use so you have to
click the Show All actions icon. The unsafe ones will have yellow warning icons
beside them.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile/Bill.Mosca>
https://mvp.support.microsoft.com/profile/Bill.Mosca

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Saturday, February 25, 2012 5:11 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Saved report out put to command button.

Jim,

I have very little experience with macros. I
tried one and failed. I cannot find the option -
TransferSpreadsheet Export which you mention.

I subsequently made this and I do not know how but it works:

Private Sub cmdDirectoryToXls_Click()
On Error GoTo Err_cmdDirectoryToXls_Click

Dim stDocName As String

stDocName = "Directory1213"
DoCmd.OutputTo acReport, stDocName

Exit_cmdDirectoryToXls_Click:
Exit Sub

Err_cmdDirectoryToXls_Click:
MsgBox Err.Description
Resume Exit_cmdDirectoryToXls_Click

End Sub

Cheers,

Robin

At 26/02/2012 11:13 AM, you wrote:
>Robin
>
>Have you tried a macro?
>TransferSpreadsheet Export
>Â
>Jim Wagner
>________________________________
>
>
>
>________________________________
> From: Robin Chapple <robinski@mymail.net.au <mailto:robinski%40mymail.net.au>
>
>To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
>Sent: Saturday, February 25, 2012 4:53 PM
>Subject: [MS_AccessPros] Saved report out put to command button.
>
>
>Â
>I am using Access 2010 on a Windows 7 system.
>
>I have saved an "export to XLS' in the "Saved Exports" folder. I need
>to use a command button to run that export. How do I do that?
>
>Many thanks,
>
>Robin Chapple
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]