Adding an ID number to XLS output

R

Robin Chapple

I am attempting to output club records from an Access database to an
XLS format on a per club basis using a command button and a parameter
query.

I can output the single club file with this line:

DoCmd.OutputTo acQuery, "qryRollCall2XLS",
"MicrosoftExcelBiff8(*.xls)", "E:\###\Database.xls", True, "", 0

using the parameter query.

I then attempted to make separate XLS files per club with this which
is based on code I use to make RTF output from a report.

DoCmd.OutputTo acQuery, "qryRollCall2XLS",
"MicrosoftExcelBiff8(*.xls)", "E:\###\" & "Database_ID" & Me![Club
Ident] & ".xls", True, "", 0

I have not adapted it correctly because the error message reports that
it can't find the field [Club Ident].

The next task will be to learn about making the separate XLS files
without the need to use the commend button 60 times.

Robin Chapple
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding an ID number to XLS output file name 1
Running Macro - output pivot table to excel - error message 2046 0
Exporting a Report to Excel 2
Output To Naming problem 16
Can I ouput a report in WORD format using a macro? 1
Excel extention not set 3
Object Library 9.0 needs to be 10.0 1
"Object Invalid or no longer set" on Cmd.Close 4

Top