I would like to use the outputTo funtion to export form information as an Excel file. The problem is that I also want to run this same operation for 80 different offices, and the only file name it wants to out put to is that of the form. I tried using vb to change the caption to the form prior to the export, but that makes no difference in the default file name it tries to save as.
any suggestions??
barrhaven01
Last Activity: Dec 2 '08, 06:36 PM
Joined: Nov 26 '08
Location:
-
OutputTo form name change
-
im incredibly stupid.... i cant seem to get this to run.
Also I was wondering how the code would change if rather than a report for each employee, if it summarrized each employee by office building. -
thanks for the code.... just one question.... How do i implement this loop code as the record source, it seems to only want to let me select queries or tables, i cant get to code builder from there.
thanks again for all the help thus farLeave a comment:
-
batch export of reports
Hi there,
I was wondering if anyone could suggest a method using only access ( ie no additional applications) to batch export reports to excel. Basically i have a report with a query for its source data, and the query is based on the selection of an employee from a drop down list. It would be terrific if i could batch export a report for each employee.
Hopefully someone out there has the answer
No activity results to display
Leave a comment: