Advertisement

10.13.2008 at 05:38PM PDT, ID: 23811379 | Points: 125
[x]
Attachment Details

MSAcces Output to Excel format changes one Field name from TID to Expr1.

Asked by champIT in Microsoft Excel Spreadsheet Software, Access Coding/Macros, Visual Basic v1.0.5.x

My macro Outputsto an Excel format.  BUT IT CHANGES THE NAME OF THE FIELD from TID to Expr1 as if the field wer not define in the table. however, the field TID DOES exist in the table.  The output even includes data from the query.  Does anyone have an idea about how to Force the Query to outputthe field to the Exxcel format.  

DoCmd.SendObject acQuery, "qryTIDExport", acFormatXLS, "tid@championfactorydirect.com", "", "", "TID Exports", "Here is the TID Export from " & strTableName & " . Please rename the file to " & strTableName & ".xls before saving. ", True, ""Start Free Trial
[+][-]10.13.2008 at 05:43PM PDT, ID: 22707813

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.14.2008 at 06:12AM PDT, ID: 22710934

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.14.2008 at 08:50AM PDT, ID: 22712486

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]11.30.2008 at 12:17AM PST, ID: 23062399

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628