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

Sabtu, 25 Februari 2012

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>
>To: MS_Access_Professionals@yahoogroups.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
>
>
>