Search results

Do u mean I have to run the query 3 times? But what if I am not certain about the years, so that I cannot set the query criteria and the number of query I should run?

But the variable filename I want is not the timestamp, but the fields within the recrodset.

I can't understand how it can be used for exporting variable filename. Your code seems going thru each record in the table and printing the result immediately (though I dont the purpose of printing) . However, after printing, there is no further action to export, but just move to another...

I have converted my macro to VBA and the codes are as follows. So, where should I place your code? Thanks. Function Macro1() On Error GoTo Macro1_Err DoCmd.OutputTo acOutputTable, "tblGraduates", "Excel97-Excel2003Workbook(*.xls)", "C:\Desktop\" & tblGraduates.GradYear & ".xls", False, "", ...

Re: Hello and welcome to the forum But how to export the respective list with the respective filename?

I tried in macro, but didn't work.

Hi, all. My access is 2013. Suppose there's a simple query which has two fields, "year" and "graduates", where "year" can be grouped by "2012", "2013", etc and "graduates" are individual names. How can I export the list of graduates to multiple excel files, with the filename based on...