UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Report Export Or Query Export To Excel Format, Access 2007    
 
   
Quinto1
post Oct 26 2017, 07:35 PM
Post#1



Posts: 39
Joined: 23-April 16



I was trying to email a report but I cannot get the email part to work.
The Database opens and generate and export a report to outlook or desktop.
My question is from a database in the server can I export to multiple desktops in the same local network?
Each laptop have exclusive names and all are mapped to the network server

Thanks
Quinto
Go to the top of the page
 
ranman256
post Oct 27 2017, 12:40 PM
Post#2



Posts: 788
Joined: 25-April 14



you can email sheets using:
docmd.SendObject acSendQuery ,"qsMyQuery",acFormatXLS,sTo,,,sSubj,sBody
or
docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody


or export the query to a file (on their share) using:
docmd.TransferSpreadsheet acExport ,acSpreadsheetTypeExcel12,vQry,vFile,true,vSheetName
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 09:14 PM